View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob O Bob O is offline
external usenet poster
 
Posts: 3
Default 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.