How can data automatically go into a calendar created on excel?

[Closed]
Report
-
 RayH -
Hello,

I created a calendar on excel to collect past, present and future data but I wish to run it automatically. I know how to link data from one worksheet to another but as I want to create a calendar which automatically shifts day by day. I collect data every day except Saturday and Sunday on different excel sheets and i want all that information to move to the calendar so I have a clear image. collected on another. For example; if i had data collected on 2nd April 2015, then I want that data collected to move to the calendar under the date 2nd April 2015.

I really need to sort out this problem as I just need clear information instead of searching through all my files.

1 reply

What I think you need to use for this (don't have much to go on regarding the data structure) is a PIVOT table.


Look at this link to help you set it up:

http://www.excel-easy.com/data-analysis/pivot-tables.html

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!