How to Link Formula One Sheet to other Sheets in MS Excel

Hi,

Please upload the workbook here. The paperclip icon isn't working so use the Go Advanced option and look underneath your post for the Manage Attachments option.

But before you go too far creating 365 sheets, one for each day I suggest you seriously reconsider that approach.

You are making the same mistake that I see time and time again. You are mixing up the two elements of data capture and final reporting. The two require quite different treatments. Whenever you find yourself creating the same sheet layouts for each day/week/department/product code/staff member/.....etc. think long and hard.

A lot of people start by designing the form that they expect to see as the final report or which at first glance seems the best way of capturing data, and then wonder why it's so difficult to subsequently analyse and summarise or extract information from it. Yours exhibits all those features.

You should always capture data in a simple two dimensional table and worry about reporting information from it afterwards. Without exception doing this you will always be able to easily obtain management information. Rarely is this the case if you start the other way round. Just add an extra column which records the information that you were going to put on individual sheets - in your case simply the date.
You will also throw open the whole wonderful world of the powerful Pivot table functionality.

You have been asked to upload the file HERE, not to a file-sharing site.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.