| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maybe a repost----Creating Summary
I am trying to create a summary page that takes data from a dynamic number of worksheets. This numbers varies from day to day. They are located between blank sheets start! and end!. On execution of the macro I would like the following information, from each sheet, copied to the summary sheet in a columnwise fashion
On the summary B1=SHEET1!C C1=SHEET1!C D1=SHEET1!C B4:B27=SHEET!1B12:B104 (every 4th cell C4:C27=SHEET!1C12:C104 (every 4th cell D4:D27=SUMMARY!B4:B27-SUMMARY!C4:C27 (difference between B4 and C4 copied down the range A second general question... I posted this yesterday from webreader and it never showed up (I got a confirmation screen saying it was sent). Did I do something wrong or does this happen occasionally. What NNTP do I use for my newsreader Thanks for all of your help You guys are great. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help creating a summary tab (strategy) | Excel Discussion (Misc queries) | |||
| Creating a Summary of invoice | Excel Discussion (Misc queries) | |||
| Creating Summary Files | Excel Discussion (Misc queries) | |||
| creating a summary sheet | Excel Discussion (Misc queries) | |||
| Creating a large number of charts automatically (repost) | Excel Programming | |||
Threaded Mode
