Free Microsoft Excel 2013 Quick Reference

Creating a purchase order Results

So, my complete moron of a teacher has once again messed up our schedule, and refuses to help us on anything. I've actually written a letter of complaint, but the deadline's in 4 days. Here's the spreadsheet:

http://www.koolpages.com/shaneo/SPREADPROPER.zip

Here's what I need help on. Basically, if you could open the sheet and actually apply it, that'd be cool, but if you just wanna tell me or give any advice, that's cool too, and thanks again:

1) LOGIN SCREEN = I need the member login to only work if the password is entered - "29111985". Otherwise, I want an error message - e.g. "You must enter the correct password!" to appear.

2) INPUT (MEMBER) = At the moment, you can only order one item, and it automatically appears in the OUTPUT sheet as soon as selected on the box. I want it so that they select the item, platform and quantity, and then they have to click the add to cart button, or it doesn't add to the OUTPUT sheet.

Also, I want the clear cart button to actually work, so it clears and items added to the OUTPUT sheet.

I also want a stock management system. When an item and its quantities are selected, I want it to display under "thanks for shopping here!", the stock left once it's been added to the cart - e.g. "MGS3 has 193 stock remaining." Also, it needs an auto-refill level, so that as soon as the stock drops below 50, it re-fills to 1000.

3) OUTPUT (MEMBER) = I want the output sheet to display the price of the game next to the title and quantity - e.g. You have purchased: MGS3 for the PS2 (100), for £399.99.

I want the output sheet to be able to display multiple games ordered, with multiple quantities and prices, so the there can be a total at the bottom of all of the games ordered. This might require the adjustment of the rows or columns or something.

4) INPUT/OUTPUT (NON-MEMBER) = I've created a copy of the Input and Output sheets for non-members, which basically just doesn't given them a member discount. For some reason though, the copy doesn't work at all. If it could work the same as above without the member discount, that'd be cool.

Many thanks again to anyone who can help. I wouldn't usually ask for stuff like this, but my teacher is an incompetent of the highest order.

I'm an analyst but i'm also the resident excel guy when there is a problem, and our purchasing dept is asking me to bring data (entered manualy) in from a previous report to the updated new version. this requires looking up the data against three or four Columns

the below feilds are on both reports and those with an (*) beside them are the ones i need to match it up by
Purchase order*
Created date
vendor Acct*
Item*
Factory*
warehouse*
and original PO qty*

attatched is the spreadsheet, in the first sheet is the orginal report, the second sheet is the report that is new and needs the old reports information.

I've tried index match and that's not cutting it, any thoughts or ideas?

I want to create a single excel sheet of 100 consecutively numbered purchase orders. (PO 1-100) I have looked all over for help but to no avail. Please help.

Thanks Joe

I need to test all possible combinations to check reorder points (negative result under "excess" column means need to order coil). I already created a code to get all possible combinations for the dropdown menus (did not run the macro for this template because there are 74,000 combinations and the file end up to big to upload here). Now I need to test these combinations againt my stock, backlog, etc. All the data in available under oosr, coil log, purchase and stock.

I thought about doing a vlookup with concatenate for the combinations but no success so far. Any ideas?

Thank you so much! COIL AVAILABILITY - to excelforum.xlsm

At least I think I should use pivot tables for my spreadsheet. I don't know much about excel. I mostly draw very simple tables and the odd time calculate sums.

In a nutshell..

I just started a new side business and I would like to take the 48 products from our catalogue and create a worksheet and identify each with an item name plus order # and add the price for each of these items in book 1. Then in book 2 I would like to type either the name of a particular item OR the order # identified in book 1 and have the program recognize this item and automatically enter the price of the item. After the list of items to be purchased is entered I would like to see a subtotal box followed by a 6% (Shipping fee) box, another subtotal box, a 13% applicable taxes box and a new grand total box. Hope this makes sense.

Cheers,
Tina

Hi,

I am fairly sure this is a totally muppet question so I apologise in advance

I have a workbook with two sheets in it

Sheet 1 - A list of Purchase Orders received by the company (goods received into the warehouse). The important information on this sheet is the;
- The PO number
- The date
- The stock code of the item recieved (each stock code gets a new row therefore creating duplicates in the PO number column)
- The quantity received.

Sheet 2 - A list of all Sales orders held by the company (over 7,000 currently). The important columns on this one are;
- The Sales order number
- The stock code of the items on the Sales order (each stock code gets a new row therefore creating duplicates in the Sales order number column)
- The quantity ordered
- The quantity delivered
- The quantity outstanding

What I need to do is be able to run some sort of routine (I think that is the term) that will follow something like the following sequence...

1. Start
2. Routine filters sheet 1 by todays date
3. Routine filters sheet 2 by quantity outstanding >0
4. User inputs a PO Number (sheet 1 data)
5. Routine Identifies Stock codes relevent to that PO (sheet 1)
6. Routine matches stock codes identified in step 5 with Stock codes on sheet 2.
7. Routine 'delivers' the Sales order number relevent to the stock codes identified in step 6.
8. End

In simple terms, the user inputs a PO number and the routine gives a Sales order number with the link between the two being common stock codes.

Hope that makes some sense and that someone can help me.

Thanks.

Hello, I was wondering if anyone would be able to help me with an Excel problem I am having.

I have a large Excel workbook which contains around 40-50 seperate spreadsheets, each of the spreadsheets holding information about a different project, I also have a front sheet which rolls up all the basic project information. However what I am trying to do now is a little bit more complicated.

I have created a Spreadsheet entitled Budget Codes which contains all the different budget codes which could be used to purchase something against an order for a project. In this spreadsheet I have 'Budget Code' 'Amount Allocated' 'Amount Spent' and 'Amount Remaining'. What I want a formula to do, is to look into the order lines of ALL the other project sheets, identify where a particular budget code is used, and where it matches the code in the respective cell to add the value of that order, thus totalling all the orders placed against that project code...where there may be multiple order lines, if this makes sense.

If it doesnt (because I am not great at explaining), I need a formula to look up where the budget code in one cell matches the budget code in multiple other cells and then know to look at the value/amount on the same line as the project code and them all up together. I am thinking that SUMIF and VLOOKUP may be able to help me but at the moment I feel like I am banging my head against a brick wall.

If anyone is able to help I would be exceptionally grateful.

So, I've logged nearly 20+ hours so far in building (what I think) is a fabulous personal budget template. I plan to log quite a few more hours in order to fully automate a variety of functions and overall enhancements to an existing template I had (and also spent much time on).

I've seen people out on ebay and random websites who have created excel based 'software/template' packages and are selling them. I want to do the same. However, I'm concerned that once I email the template to someone after they purchased it that they could just forward it to others who want it as well.

Probably a stupid question - but is it possible to somehow 'build' in some functionality (maybe based on date the template is sent to the buyer) that will increase the size of the file somehow to prevent it from being emailed (not sure what the general size threshold is for email) to other people?

I know that those who are computer smart will be able to circumvent this - however I feel the general technology level of where I intend to post this is relatively low and would therefore prevent others from getting it for free.

Any suggestions at all. Its quite possible that I have too much of a pipe dream.

Thanks in advance.
B2b

I have a worksheet (worksheet 1) in which I am creating formulas that reference data in another worksheet ("Oct 03 Fcst" in a different workbook "Data Export.xls"). The number and order of rows in the Oct 03 Fcst worksheet may change over time. If this happens, my formulas in worksheet 1 will then be incorrect since they reference specific cell values in the Oct 03 Fcst worksheet (e.g., ='C:Temp[Data Export.xls]Oct 03 Fcst'!$B$13).

I'm looking for a way to re-write those formulas to reference a specific dimension value and then look for the corresponding data value for that dimension in the data column in that row. For example, for this type of data:

A B C
1 Center Forecast
2 ===== =======
3 Accounting $1000
4 Marketing $5444
5 Purchasing $3000
6 Security $4888

I want to be able to write a formula that would contain what I've referred to in a different programming language as a qualified data reference. I would like this to look something like the following for the cell in worksheet 1 that shows the October forecast value for the Marketing department:

='C:Temp[Data Export.xls]Oct 03 Fcst'!Marketing(Forecast))

Is there a way to do this in Excel? If so, I can be assured that the Accounting forecast value in Oct 03 Fcst will always be copied to the Accounting forecast cell in worksheet 1 even if the Accounting entry in Oct 03 Fcst moves from row 3 column B (as it is now) to row 6 column B. (Note: The dimension labels in column A will always stay the same over time. E.g., Accounting will always be "Accounting" and Marketing will always be "Marketing". They won't change to "Acctg" or "Mrktg" in a future data export. However, I may get a new value like "Information Technology" that was not in the original Oct 03 Fcst sheet.)

Sorry, the Excel representation above didn't format very well. There are supposed to be 3 columns above: Center, Forecast, and a blank column along with row and column labels.

Hello,
I'm working on a file that tracks our daily sales data. There is a separate worksheet for each day of the month, and each sheet contains the accounts that purchased, the sales person, number of pieces ordered, etc.

I've been asked to create new worksheets within the same workbook for each sales person. So I need a formula that will lookup all of "SalesRep1" sales for each day, and then paste them in a list with all the account info, number of pieces ordered, etc.

I know how to create vertical lookups. The problem I'm having is that "SalesRep1" may have multiple sales on any given day, and the number of sales is always changing. The lookups only give me the first sale, or the highest valued sale, and not ALL the sales.

The "countif" function gives me the number of sales, but I want more information than that, namely, the account names, pieces ordered, etc.

Is there any way to have a vertical lookup repeat itself until it finds every reference? Is there something I'm missing here?

Your help is greatly appreciated!

Angela


Thanks in advance to all those who answer.

Before i ask what i need to know i will clarify some things i already know to help out those who answer.

1. I know that you can conditionally format Excel to change the background color if it meets a value.

2. I know that you can change the formatting of a cell in column A based on a value in Column B.

3. I know that you can only set 3 conditions in Excel 2002.

4. I know you can set unlimited conditions in Excel 2007. (i dont want to get 2007)

5. I know that you can use VBA code and apply it in excel 2002 in order to create more conditions.

MY QUESTION IS:how can i get VBA code that can add conditions (more than 3 per column) to a work sheet that allows conditioning of cells in Row B based on values of Cells in Row A.

If you could supply a VBA code that i could copy that would be great.

I am also open to purchasing an excel plug in for 2002 that allows unlimited format conditions.

And an open to any other suggestions you may have.

Thanks for your help.

I would need this completed by tomorrow sometime so I will have time to debug and have completed 100% by Tuesday morning. I don't think anything in the scope is too time consuming, as the framework for this database is already completed. Thank you in advance for considering this project.

IF YOU ARE INTERESTED, PLEASE EMAIL ME AT (Truncated) , AND I CAN FORWARD THE FILE TO YOU. THE .XLSM FILE IS 243KB, SO OVER THE LIMIT FOR POSTING HERE. THANKS!!

The following is the scope:

1. Password protect "database, convodatabase, and contact profile tabs
2. Add "Blank" selection to all listboxes

Contact profile form:
1. Make drop down selection based on current known contacts for company from company input form
2. Make default birthdate = nothing. If birthday is entered, automatically populate age field. Otherwise blank or entered by user manually.
3. Add macro for "Print to TearSheet" (I already added the contact profile tear sheet)
3.a. Sheet will delete when database is closed

ConvoLog Userform:
1. Contact date default to nothing unless entered
2. Add macro for "Print to TearSheet" (I already created the convolog tear sheet)
2.a. Sheet will delete when database is closed

Filter Form:
1. Add hyperlink that will take user to website listed in database for selected company (see attached pdf)
2. Add hyperlink that will take user to folder for any stored documents for company (see attached pdf)
3. Changed filtered list to only show the following items in this order: Link to URL, Link to File Storage Folder, Link to Conversation Log, Company Name, Strategic Fit, Sales, EBITDA, Gross Margin, Raw Material Purchase Value, # of Employees. (see attached pdf file for what I was thinking)

Company Input Form:
1. Change red "x" delete button for listboxes to yes or cancel option, and write code to delete any checked items in the userbox if "x" is clicked.
2. Add file storage capabilities...after a user clicks on "Upload Document" within Company Input form, a dialog box will open allowing user to select a file(could be pdf, doc, picture...doesnt matter), and whichever file they select from an explorer window is uploaded to the following directory "usamt79iszepshpprojectgrowShared DocumentsCompanies(macro to create new folder for specific company)"file is stored here"
3."Today's Date" is not working correctly (doesn't refresh to current date)

Main Menu:
1. After clicking on "View Personality Profile" and entering password, allow a user to either a)select a company from the drop down box, and then select a contact from the filtered & alphabetized list below, or b) select a contact from the unfiltered list before choosing a company.
2. After clicking "View conversation log" and entering password, a user can select a company from the drop down and view the conversation log for the associated company.

Hi,

can anyone help me with this problem please? (have included details required
first)

cell where IFSUM formula is to be placed = E15 ( where i need to create
formula)
cell where IFSUM item is located = D2 ( job No. 1234)
cell where other book name is = C15 ( this text is November 2005 )
other workbook location = S:Purchasing ( then other book name )

i have written this macro-

sub GETWIP()
MonthEqual = range("C15").Select
monthcheck = "=SUMIF(S:Purchasing'[" & MonthEqual & ".xls]Front Order
Summary'C10:C1010,D2,[" & MonthEqual & ".xls]Front Order Summary'!F10:F1010)"
getjobcode = Range("C2").Value

if getjobcode = "Complete" Then
MsgBox " please enter job number in space provided"
Exit Sub
End If
if getjobcode <> "Complete" Then
Range("E15").Value = monthcheck
End If
Exit Sub
End Sub

my normal workbook formula for this would be-
=SUMIF('[November 2005.xls]Front Order Summary'!$C$10:$C$36,D13,'[November
2005.xls]Front Order Summary'!$F$10:$F$34)
which takes "November 2005" from "MonthEqual" and compiles the formula to
cell E15.

i get an error highlighting Range("E15").Value = monthcheck.

basically, i am trying to compile a formula from the month, year & xls to
look at the job no value and find it in november 2005 workbook at location
specified, then return the value in the range required but i cannot get it to
work.

thanks in advance,

Nigel

Can anyone assist me in my design?

Real world:
I am a manufacturer of goods sold to a national retail chain. I have 10
different items in 1800 stores.
Every week I get a report from the chain that shows inventory levels and #
of purchases that week for each item, each store; 18,000 line on a
spreadsheet.

In Excel :
I have a worksheet "Store List" which has all the information about the
stores; Store number, address, regional info, etc. all pertinent info the
chain uses to describe its stores.
I have a worksheet "Product List" that has all info on each of the 11 items,
SKU number, our part number, size, weight, cost, retail, description
I have a worksheet "Sales Data" that contain a line for every store, every
item... a reflection of the reports received from the chain with an
inventory column, sales column, and on order column for each weeks report I
receive. I transfer over the Inventory and sales data to a new column by
hand.

I have written many functions and acros to analize the data, but it is very
inefficient.
I would like to utilize classes to improve performance and ease of
programming future improvements.

So far I have:

A store class: Describes any one store with all the store data from the
"store list" worksheet
An item class: Describes any one item
A Product Line class: Which creates an array of 10 item classes

Where should I store each stores sales and inventory data?
Should "Qty on hand", "Quantity on order", "Quantity sold" all be private
members of the item class?
Should each weeks sales info be held in an array within the items class or
the store class?
Should the store class have an array of weekly product line snapshots?
Should I be using a database?
Should I go back to college?

Any direction will be apreciated.
Thanks

My company has upgraded to XL2003, and I am forced to play 'catch up'. I
have only a few co-workers, so two
dedicated machines still run standalone with xl2k as a fallback, if needed.

Addins do not seem to be a problem, so far, but a few 'template' workbooks
(eg: an Order form, Fax form, etc)
are a problem.

They are not 'true' Templates or Forms, simply single-sheet books, with
code in the ThisWorkbook module.
When opened, I'm getting macro warning messages, and I can simply bypass the
code leaving me with a "useless" sheet.

My research suggests that a Certificate is required.
Can I create this myself, or must it be purchased?

If relevent, my co-workers Order/Fax is e-mailed to the intended recipient,
but Chip Pearson's code is 'borrowed'
to remove all code, before sending.

Can I resolve this easily and cheaply? Or perhaps I should consider moving
these 'templates' so that they become
options under the AddIns?

Advice much appreciated, please.

Regards.

Here is my situation.
I have a file called:
Customers
Within there, each customer has their own file. From there is a file called orders, where I created an invoice that I type each order into. I place orders every two weeks, so there are 26 sheets within each order file. Hope I have not lost you!
I offer the customer a free gift with ever 15 products purchased. So on my invoice, I have a spot that will calculate the total number of qualifying products for each invoice.
I would like a separate sheet that would go out and look at that amount for each customer and evaluate it to see if they are at a point of getting a free item. If so, I calcuate the dollar amount of their last 15 products to come up with an average, and their free item value will be the same as their average cost.
Also, once they have hit 15, then the page that tracks this will then need to start back at zero again.
I don't know if I explained this well enough for anyone to make any sense of it.
Thanks in advance for your help!!!

Hello all-

This being my first post, and extremely new to this community, I'd just like to say that any help on this topic would be greatly appreciated.

I'm working on a spreadsheet I've kept for several years dealing with my personal accounting. I have columns set up such as "Date", "Time", "State", "City", "Establishment", & "Address", among others. It is naturally more then I need to keep a balanced checkbook, but it's helped me really get accustomed to Excel & I've had a fun time making it better & better over the years.

My question for this forum is: Is there a way that I can incorporate drop down menus in order to select a State, and then in the next column, be able to select a certain City that belongs to that state?

For instance, I live in Virginia, and this is where 90% of my purchases occur. Could I select "VA" from a drop down menu, and in the next column, be able to have a drop down menu that lists cities only pertinent to the state of Virginia?

I've been able to create drop downs using validation, but I'm unsure how I can make them dependent on variables, only selecting from a list.

Ultimately I'd like to be able to select a state of purchase from a menu, then a city in the next column (limiting only to Cities within the State I selected in the previous column), followed by an establishment in the next column (which would only show those establishments I've been to in that specific City I selected in the previous column), and then a specific address of that establishment in the next one, and so forth.

Any help would again be greatly appreciated... and if this description was not enough, and you need more information, please msg me, thanks!

-CaveMaN

Hello All,

I am new to the Forum and relatively new to VBA programming. Here is the problem I am having:

At one point within my code, I am attempting to Remove Duplicates. However, once the macro gets to that line, it throws a Run-time error 9. So, I decided to take just that line and put it into a separate macro. I then put a Call within the original code, and it seems to work just fine???? I will post the code below just in case that may be helpful. Thanks for any insights.

Option Base 1
Sub Step_4_Purchasing_Detail()
    
    Dim fillVar As Long
    Dim getNamc As String
    Dim summaryFillVar As Long
    Dim icRef As Variant
    Dim startVar As Long
    Dim endVar As Long
    Dim icArray() As String
    Dim icCount As Long
    
    Application.ScreenUpdating = False

    getNamc = Application.InputBox(Prompt:="Enter NAMC.", Title:="NAMC", Type:=2)

    Sheets("AAPJ182").Select
    Columns("A:H").Select
    Selection.Copy

    ' Remove rows and columns not needed by Purchasing
    Sheets("Purchasing").Select
    Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
    Rows("1:2").Select
    Selection.Delete Shift:=xlUp
    Columns("C:C").Select
    Selection.Delete Shift:=xlToLeft
    Rows("2:2").Select
    Selection.Delete Shift:=xlUp

    fillVar = Application.WorksheetFunction.CountA(Range("A:A"))

    ' Add NAMC column
    Columns("A:A").Select
    Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
    Range("A1").Formula = "NAMC"
    Range("A2").Value = getNamc
    Range("A2").Select
    Selection.AutoFill Destination:=Range("A2:A" & fillVar)

    Columns("A:H").Select
    ActiveWorkbook.Worksheets("Purchasing").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Purchasing").Sort.SortFields.Add Key:=Range( _
        "B:B"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal
    With ActiveWorkbook.Worksheets("Purchasing").Sort
        .SetRange Range("A:H")
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With

    Sheets("InterCompany").Select
    icCount = Application.WorksheetFunction.CountA(Range("H:H"))
    
    ReDim icArray(icCount)
    
    For i = 3 To icCount + 1
        icArray(i - 2) = Range("H" & i).Value
    Next i
    
    Sheets("Purchasing").Select

    For i = 1 To icCount - 1
        Range("B1").Select
        Set icRef = Columns("B:B").Find(What:=icArray(i), After:=ActiveCell, LookIn:=xlFormulas, LookAt _
                :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
                False, SearchFormat:=False)
        If Not icRef Is Nothing Then
            Range("B1").Select
            Columns("B:B").Find(What:=icArray(i), After:=ActiveCell, LookIn:=xlFormulas, LookAt _
                :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
                False, SearchFormat:=False).Activate
            startVar = ActiveCell.Row
            Range("B1048576").Activate
            Columns("B:B").Find(What:=icArray(i), After:=ActiveCell, LookIn:=xlFormulas, LookAt _
                :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:= _
                False, SearchFormat:=False).Activate
            endVar = ActiveCell.Row
            Rows(startVar & ":" & endVar).Select
            Selection.Delete Shift:=xlUp
        End If
    Next i
    
    Columns("A:H").Select
    ActiveWorkbook.Worksheets("Purchasing").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Purchasing").Sort.SortFields.Add Key:=Range( _
        "B:B"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal
    ActiveWorkbook.Worksheets("Purchasing").Sort.SortFields.Add Key:=Range( _
        "D:D"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal
    ActiveWorkbook.Worksheets("Purchasing").Sort.SortFields.Add Key:=Range( _
        "E:E"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal
    With ActiveWorkbook.Worksheets("Purchasing").Sort
        .SetRange Range("A:H")
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
    
    ' Create Summary data from Detail data
    Columns("A:E").Select
    Selection.Copy
    Range("J1").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    Columns("G:G").Select
    Selection.Copy
    Range("O1").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False


    ' This is the line causing the error. If I delete it and uncomment the Call, it seems to work fine???
    ActiveSheet.Range("$J:$O").RemoveDuplicates Columns:=Array(2, 3, 4), _
        Header:=xlNo

    'Call Macro2
        
    summaryFillVar = Application.WorksheetFunction.CountA(Range("J:J"))
    
    ' Insert formulae and headers
    Range("N1").Formula = "AGING DATE"
    Range("O1").Formula = "UNIT PRICE"
    Range("P1").Formula = "QTY"
    Range("Q1").Formula = "AMOUNT"
    Range("R1").Formula = "BUYER CODE"
    Range("S1").Formula = "BUYER NAME"
    Range("T1").Formula = "A/M"
    Range("U1").Formula = "MANAGER"
    
    Range("P2").Formula = _
        "=SUMIFS($F:$F,$B:$B,K2,$C:$C,L2,$D:$D,M2)"
    Range("Q2").Formula = _
        "=SUMIFS($H:$H,$B:$B,K2,$C:$C,L2,$D:$D,M2)"
    Range("R2").Formula = _
        "=VLOOKUP(K2,'Buyer Info'!$A:$B,2,FALSE)"
    Range("S2").Formula = _
        "=VLOOKUP(K2,'Buyer Info'!$A:$C,3,FALSE)"
    Range("T2").Formula = _
        "=VLOOKUP(K2,'Buyer Info'!$A:$D,4,FALSE)"
    Range("U2").Formula = _
        "=VLOOKUP(K2,'Buyer Info'!$A:$E,5,FALSE)"
    Range("P2:U2").Select
    Selection.AutoFill Destination:=Range("P2:U" & summaryFillVar)
    Columns("J:U").Select
    
    Rows("1:1").Select
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    Range("A1:H1").Select
    With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
    Selection.Merge
    Range("A1").Value = "DETAIL"
    Range("J1:U1").Select
    With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
    Selection.Merge
    Range("J1").Value = "SUMMARY"
    Range("A1").Select
    Selection.Font.Bold = True
    With Selection.Font
        .Name = "Arial"
        .Size = 12
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ColorIndex = xlAutomatic
        .TintAndShade = 0
        .ThemeFont = xlThemeFontNone
    End With
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent1
        .TintAndShade = -0.499984740745262
        .PatternTintAndShade = 0
    End With
    With Selection.Font
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = 0
    End With
    Range("J1").Select
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent3
        .TintAndShade = -0.499984740745262
        .PatternTintAndShade = 0
    End With
    With Selection.Font
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = 0
    End With
    Selection.Font.Bold = True
    With Selection.Font
        .Name = "Arial"
        .Size = 12
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = 0
        .ThemeFont = xlThemeFontNone
    End With
    Range("G3:H1048576").Select
    Selection.Style = "Currency"
    Range("O3:O1048576").Select
    Selection.Style = "Currency"
    Range("Q3:Q1048576").Select
    Selection.Style = "Currency"
    Range("N3:N1048576").Select
    Selection.NumberFormat = "m/d/yyyy"
    Range("E3:E1048576").Select
    Selection.NumberFormat = "m/d/yyyy"
    Cells.Select
    Cells.EntireColumn.AutoFit
    Range("A1").Select
    
    Application.ScreenUpdating = True

End Sub
Sub Macro2()

    ActiveSheet.Range("$J:$O").RemoveDuplicates Columns:=Array(2, 3, 4), _
        Header:=xlNo
        
End Sub


Hello everyone,

I am working on a little side-project for school. I would like to include an Excel spreadsheet that updates automatically depending on the selection made in a dropdown menu.

The scenario is this:
I am a reseller of various goods. My products come from multiple vendors which are located in a variety of countries. I purchase these goods in bulk, markup the price by various percentages, and then resell the goods to multiple customers. I am trying to utilize the power of Excel in order to track the successes and failures of various transactions.

A sample of the data I am using, and graphs I created in Photoshop (which I would like the final Excel graphs to look similar to), can be found in an Excel file located here:
http://www.nwcomputersolutions.net/p...ng_example.xls
The document is also attached to this post.

Any help/advice that anyone can provide is greatly appreciated.

Thank you!

I'm new to Excel, haven't done much at all so maybe there is an obvious answer for this question!

I am using Excel for OS X. I purchase inventory from a company that uses an Excel workbook to send the latest price list, and there are multiple pages to the workbook, which must have macros enabled. The workbook was created on a windows machine. The pages are: master price list, retail list, order form and blank price list. When I place an order, I'm supposed to fill in the order form which automatically calculates the totals (number of cases, total order amount, etc.), which all works fine on my Mac. The trouble comes when I want to email or print the order form. All I get is a blank page. If I do print preview, it comes up blank. What am I missing?!

betsy