| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary sheet for multiple worksheets
Hi
I have produced a template which requires information regarding the hardware and software for each PC within out Department. I need to copy data (around 150 cells) from each worksheet (110 worksheets and increasing) to two summary sheets (hardware and software). I know the cell ranges for each of the requirements as they are standard for each template - i.e. A1:B5 for hardware and C1:H5 for software. What is the best way to transfer this information? Thanks for your help John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summary sheet for multiple worksheets
See your other thread
Please post in one group -- Regards Ron de Bruin http://www.rondebruin.nl "JohnnieBoy" wrote in message ... Hi I have produced a template which requires information regarding the hardware and software for each PC within out Department. I need to copy data (around 150 cells) from each worksheet (110 worksheets and increasing) to two summary sheets (hardware and software). I know the cell ranges for each of the requirements as they are standard for each template - i.e. A1:B5 for hardware and C1:H5 for software. What is the best way to transfer this information? Thanks for your help John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summary Sheet help with multiple sheets | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| Creating a summary sheet from data across multiple worksheets | Excel Discussion (Misc queries) | |||
| Daily Totals on a summary sheet | Excel Worksheet Functions | |||
| Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Linear Mode
