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 |
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 |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com