• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Daily Reports to Worksheet

F

FOSSTER

New Member
I have a question for you all:
"I am trying to create a monthly report from a series of daily reports, all daily sheets are on a template, 31 worksheets representing each day of the month, and 1 worksheet representing the months summary. The value I want to get from each daily sheet is in cell C21. On the monthly summary worksheet I have have the dates (1,2,3,etc) aligned in one column, now as I move down my monthly report sheet I would like the daily sales total to move from sheet to sheet ie from the 1st to 2nd to 3rd of the month, and pick the value that is in cell C21 on each daily sheet.
I am not looking for sums, just deliver the value from each of the 31 sheets (days of the month to 1 sheet (monthly report).
If this is not clear, I can email you the excel file for all to view. I am sure others can take advantage of this as well.
I have tried to drill through many videos to find my answer without any luck. Can you help? Thanks in advance.
 
Hi FOSSTER,

Welcome to chandoo forum.

You can upload your file here if the size is less than or equal to 1 MB. Try to create a sample file with say 5 sheets and upload it here.

Regards,
 
Thank you all for your replies thus far.
I have uploaded a sample file here that shows what I would like to appear from the daily to monthly report.
I found the use of INDIRECT function intriguing. Would that work here as well?
Please apply the function that best works. Look forward to your replies.
Thanks in advance.
 

Attachments

Hi Foster

You need to change your sheet names so they don't have special characters in them. This will allow the technique to work. I have moched up an example for you..

Take care

Smallman
 

Attachments

You must log in or register to reply here.
Back
Top