# Probally a simple question

#### pipemaker

##### New Member
I will be having 5 sheets in the workbook. First sheet is data entry sheet looking like so:

Operation # Complete Expected Hours Actual Hours
Mill 1 80 1.7
Mill 2 400 3.6
Select 22

the following sheets will be trackers for the different items. First sheet being basket with dates across the top. the other sheets the same for each item. ie:

12/13/2005 12/14/2005 12/15/2005
Footage 102.5 100 60 50
Run Time 5.4 5.6 5.2 5
Down time 3.6 2.5 5.3 2.3

Now the problem. I would like to retain the date from one day to the next. Enter data on the main page then have it flow to its individual sheets and be retained for data analysis. Anyone help with htis. I know it is a crude example, but people on here work wonders with this. Thank you

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### RAM

##### Well-known Member
pipemaker,

I think if you read up on this link (you will find it very simple to use) the board will have a better chance to solve your topic.

http://www.mrexcel.com/board2/viewtopic.php?t=92622

Do you mean that input data on sheet 1 will display on other sheets?

HTH

RAM

#### pipemaker

##### New Member
this will be sheet one.
test expectations.xls
ABCD
3
4Operation#CompleteExpectedHoursActualHours
5Mill11025
6Mill21157
7Select48
8StitchCut22
9Lining11
Sheet1

This is the other sheets:
test expectations.xls
ABCDE
212/13/200512/14/200512/15/200512/16/2005
3Footage
4RunTime
5Downtime
Mill 1

Want the input from the first sheet to copy to the second sheets under the date.

#### pipemaker

##### New Member

let me try again. The first sheet above is the data input sheet. Data is entered in B5,C5, and D5. I want this to move over to the second sheet and land in B3, B4, B5. Trick is i want it by date. The first sheet will be dated and i need the data to be in the correct date across the sheets.

B5 = B3
C5 = B4
D5 = B5

#### RAM

##### Well-known Member
Good,

Select B3 in Mill 1 and type in =

Open Sheet 1 and select B5. Now you have a link and everything you enter in Sheet 1 will display in Mill 1.

Did this help?

RAM

PS. Click on View Code in the HTML Maker and copy and paste the code into Mr. Excel. You will avoid all the (space) symbols.

#### pipemaker

##### New Member

The date will be located in Cell A1 on the first sheet. Thanks for all your help

#### RAM

##### Well-known Member
let me try again. The first sheet above is the data input sheet. Data is entered in B5,C5, and D5. I want this to move over to the second sheet and land in B3, B4, B5. Trick is i want it by date. The first sheet will be dated and i need the data to be in the correct date across the sheets.

B5 = B3
C5 = B4
D5 = B5
You must have entered this quote just before I entered my answer. Sorry I missed it and gave you an incorrect answer.

RAM

#### pipemaker

##### New Member
I think i lost a reply that i was looking for.

#### RAM

##### Well-known Member
Sorry I can't help you on this one. For what I understand you need the input data to remain on the second sheet even when you enter a new date on the first sheet. You might need VBA for this, but I'm not sure.

RAM

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### Forum statistics

1,168,120
Messages
5,857,492
Members
431,882
Latest member
saaaaaaaaaaaaaaaaaaaaaa

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back