Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help Creating a Macro Multiple Workbooks to One
HI I need Help Creating a Macro for my job!
We currently have two workbooks, one has multiple worksheets containing invoice information. The other has one worksheet containing all of the information of the other workbook. We are double entering the information right now so I would like to run a macro that will allow my entry on the first workbook be automatcially entered into the second workbook on the next available line. Can anyone help me???? Thanks!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help Creating a Macro Multiple Workbooks to One
Have a look at Ron de Bruin's Copy/Paste/Merge examples.
http://www.rondebruin.nl/tips.htm Gord Dibben MS Excel MVP On Thu, 7 Jun 2007 09:17:01 -0700, Howeecow wrote: HI I need Help Creating a Macro for my job! We currently have two workbooks, one has multiple worksheets containing invoice information. The other has one worksheet containing all of the information of the other workbook. We are double entering the information right now so I would like to run a macro that will allow my entry on the first workbook be automatcially entered into the second workbook on the next available line. Can anyone help me???? Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a single workbook from multiple workbooks | Excel Discussion (Misc queries) | |||
Creating New Macro Workbooks | Excel Discussion (Misc queries) | |||
macro or code to open multiple workbooks | Excel Discussion (Misc queries) | |||
Creating multiple workbooks from summary workbook | Excel Discussion (Misc queries) | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) |