Excel Workbook Question

[Carter79]

Hello everyone, I am stuck. I am trying to combine several different reports we fill out daily into one workbook with different pages for each report as opposed to seperate files for each report. My problem is these reports were created by someone that is no longer with us and one of the documents has a built in calender. Each day you click on the calender and choose your day, the form will reset for each day but it keeps a log of everything put into it, so at any given time you can click on the calender and choose a day in the past and see the production reports for that day. I can integrate the rest of my reports into this workbook on different tabs but I need to change some of the content on the page with the calendar. My problem is when I change it one one day it does not update the future forms. Each day it is reverting back to the original form. This is probably an easy fix but I just can not figure it out. Also is there a way to map cells on other tabs to pull from each other. i.e. when you enter the date on the first tab have it update the date on all tabs. There are several cells that have repeated information and would be a huge time saver if I could figure out how to do this. Thanks for any help.

 

[Andrew Poulsom]

Welcome to MrExcel.

Did you copy the UserForm with the calendar to your new workbook? To reference a cell on another sheet:

=Sheet2!A1

You can type = and point at the source cell with your mouse to enter the formula.

 

[Carter79]

Not sure where to find the UserForm, not sure what it is. I have access to edit the original form though so all the files should be there

 

[Andrew Poulsom]

A UserForm is a dialog box, in your case one that displays a calendar. You find it by pressing Alt+F11 to open the Visual Basic Editor. Here's an example:

Use the Calendar control to fill in dates

 

[Carter79]

All of these files are here. I still am unable to figure out how to update certain cells for the future.

For example I have four different cells
White Saw
Red Saw
Blue Saw
Green Saw

I need to be able to change them to read differnetly i.e.
S/S One
S/S Two
Wet Router
Dry Router


I can change it on the sheet but when I move to the next day it resets it back to the original. I can not get it to change this across all forms.

 

[Andrew Poulsom]

Sorry, I don't see how a calendar can affect text in cells. To get more help you will have to give a lot more details.