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.

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

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

I'm still confused (a common state).

And I think your question may be lost in the thread.

Can you rephrase and start a new thread?

Or maybe someone can jump in who understands.

Bob O wrote:

Dave
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:C104

Just to reiterate....the number of sheets changes each day, thus START! and END!
Hopes this clarifies some

Thanks again!



--

Dave Peterson