Create a "recap" worksheet that includes all info from all worksh.
I need to recap all information from all worksheets on one worksheet. How is
the best way to accomplish this? Is it best to put the info first into the all-inclusive worksheet and then use a formula on each individual worksheet to pull certain information? |
hi,
i think it would be best to put formula on the recap sheet to pull the needed information from the other sheets. fomula's like =(sheet2!A1) will return the contents of cell A1 on sheete2 =sum(sheet2!a1:a10) will sum the range A1:A10 on sheet2 -----Original Message----- I need to recap all information from all worksheets on one worksheet. How is the best way to accomplish this? Is it best to put the info first into the all-inclusive worksheet and then use a formula on each individual worksheet to pull certain information? . |
All times are GMT +1. The time now is 05:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com