JohnCunningham
New Member
- Joined
- Apr 29, 2011
- Messages
- 1
Hello all,
Here's the issues I'm having, there's a few to be sure.
I am trying to populate 1 summary sheet from 30 or 31 worksheets of data. The summary columns are date based. The rows are where different data is stored like retail sales, next row is commercial sales, etc. What I would like to be able to do is to pull data from each days sheet to populate the summary page, without having to go in and rewrite every cell that calls data from another sheet every month. Basically what I would like it to do is to look at the date for that column, and autofill the date into the data call line.
Sorry if I'm not using the correct terms, I'm no tmuch of an excel user.
Thanks!
John
Here's the issues I'm having, there's a few to be sure.
I am trying to populate 1 summary sheet from 30 or 31 worksheets of data. The summary columns are date based. The rows are where different data is stored like retail sales, next row is commercial sales, etc. What I would like to be able to do is to pull data from each days sheet to populate the summary page, without having to go in and rewrite every cell that calls data from another sheet every month. Basically what I would like it to do is to look at the date for that column, and autofill the date into the data call line.
Sorry if I'm not using the correct terms, I'm no tmuch of an excel user.
Thanks!
John
