Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
put all sheets in one
i need to put the numbers of all the sheets i have created onto one sheet
have this done automatically is there anyone out there that can do this |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
put all sheets in one
Laura
This is very doable with a macro. You set up a consolidated_data sheet and a loop to cycle through all of you source data sheets copy target range and paste to next blank row in consolidated_data sheet. Is the layout for each source sheet the same? How many sheets? All sheets in book or selected sheets? Will you be doing this one time or repeatedly? Do you know VBA or do you have access to a VBA programmer? The answers to these questions address whether you are better off doing it manually or with a macro. For < 10 sheets, may be quicker to do it manually. ...Kelly "laura" wrote in message ... i need to put the numbers of all the sheets i have created onto one sheet have this done automatically is there anyone out there that can do this |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Multiple sheets selected | Excel Discussion (Misc queries) |