Probally a simple question

[pipemaker]

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

 

[pipemaker]

 

[RAM]

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]

this will be sheet one.

test expectations.xls
	A	B	C	D
3
4	Operation	#Complete	ExpectedHours	ActualHours
5	Mill1	1025
6	Mill2	1157
7	Select	48
8	StitchCut	22
9	Lining	11
Sheet1

This is the other sheets:

test expectations.xls
	A	B	C	D	E
2		12/13/2005	12/14/2005	12/15/2005	12/16/2005
3	Footage
4	RunTime
5	Downtime
Mill 1

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

 

[pipemaker]

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]

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]

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

 

[RAM]

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]

I think i lost a reply that i was looking for.

 

[RAM]

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