|
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. |
Maybe a repost----Creating Summary
First, the easy question:
If you have Outlook Express installed, try clicking on these links (or copy and paste into MSIE). news://msnews.microsoft.com/microsof...ic.excel.setup news://msnews.microsoft.com/microsoft.public.excel.misc news://msnews.microsoft.com/microsof...heet.functions news://msnews.microsoft.com/microsof...excel.newusers news://msnews.microsoft.com/microsof...el.programming (You can always connect to more later) Here are some links that explain it better: Chip Pearson has some notes written by Leonard Meads at: http://www.cpearson.com/excel/DirectConnect.htm David McRitchie's notes at: http://www.mvps.org/dmcritchie/excel/xlnews.htm http://www.mvps.org/dmcritchie/excel/oe6.htm http://www.mvps.org/dmcritchie/excel/oe6nws01.htm Tushar Mehta's notes at: http://www.tushar-mehta.com/misc_tut...e_ng/index.htm And if you're looking for old posts: Or you can use google (maybe a few hours behind) to search for stuff you've posted (and find the replies, too) http://groups.google.com/advanced_group_search http://groups.google.com/advanced_gr...Excel*&num=100 Ron de Bruin has an excel addin that you may like: http://www.rondebruin.nl/Google.htm ================= Now the difficult one. You said you want this columnar. But it looks like sheet1 uses multiple columns. If you don't get a useful response, you may want to rephrase and ask in a new thread (this one may be too old to get replies???) Bob O wrote: 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!C7 C1=SHEET1!C4 D1=SHEET1!C2 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. -- Dave Peterson |
Maybe a repost----Creating Summary
Dav
Yes sheet 1 uses multile columns, but the columns would be the same on the summary except for the every 4th. I suppose I could format summary! and hide the extra rows (and get around the every 4th cell issue). Then it would be a matter of just copying the rows from SHEETx! to SUMMARY! Reformatted it would look like... SUMMARY!C7='SHEETx!' (Sheet Name SUMMARY!B8:C104=SHEETx!B8:C10 Just to reiterate....the number of sheets changes each day, thus START! and END! Hopes this clarifies som Thanks again |
| All times are GMT +1. The time now is 05:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com