Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Help
I have two spread sheets. One called "Lot" the other called "Invoice"
Lot contains all of the billing information for each location. Store, City, State, Invoice Number, Billing Amount, Sales Tax, Total I need to compile this data onto the "Invoice" spreadsheet, and print individual invoices for each store. I figure I will use Vlookup for everything but the store number, and possibly have a macro input the store numbers. Is there a way that I can record a macro to copy the store number (starting in A7) to the invoice spreadsheet, and have it print....then copy the data in A8, print...copy A9, print so on and so on, until there is no more data in A. Any help you can provide would be great. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |