Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Consolidation of Info from Different Tabs
Hello,
I have an excel file with different worksheets that contain tables of data that are imported from other sources on a month to month basis. I would like to be able to have a macro that will populate a "master sheet" (with no spaces) that will contain all the data from all these worksheets. The problem is that each time the data is imported to Excel, the amount of data grows and formulas would not be the best answer since the amount of info on each worksheet keeps growing and would have to be redone every time. Any help would be greatly appreciated. Thank you for your time |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Consolidation of Info from Different Tabs
Hi,
see Ron de Bruin web he has the solution to your problem http://www.rondebruin.nl/copy2.htm if this helps please click yes, thanks "cardan" wrote: Hello, I have an excel file with different worksheets that contain tables of data that are imported from other sources on a month to month basis. I would like to be able to have a macro that will populate a "master sheet" (with no spaces) that will contain all the data from all these worksheets. The problem is that each time the data is imported to Excel, the amount of data grows and formulas would not be the best answer since the amount of info on each worksheet keeps growing and would have to be redone every time. Any help would be greatly appreciated. Thank you for your time |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help w/ formula referring to different tabs & different info in ce | Excel Discussion (Misc queries) | |||
merging info from different tabs | Excel Worksheet Functions | |||
Pulling info from multiple worksheet tabs? | Excel Discussion (Misc queries) | |||
Can I have info on first tab transferred to subsequent tabs? | Excel Worksheet Functions | |||
Keeping Linked Info When Tabs are Renamed | Excel Programming |