Probally a simple question

pipemaker

New Member
Joined
Apr 13, 2002
Messages
23
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
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

pipemaker

New Member
Joined
Apr 13, 2002
Messages
23
 

pipemaker

New Member
Joined
Apr 13, 2002
Messages
23
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
Joined
Apr 13, 2002
Messages
23

ADVERTISEMENT

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
Joined
Oct 4, 2004
Messages
1,862
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
Joined
Apr 13, 2002
Messages
23

ADVERTISEMENT

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

RAM

Well-known Member
Joined
Oct 4, 2004
Messages
1,862
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
 

RAM

Well-known Member
Joined
Oct 4, 2004
Messages
1,862
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,387
Members
412,590
Latest member
Velly
Top