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
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

pipemaker

New Member
Joined
Apr 13, 2002
Messages
23
can anyone help me? getting very frustrated, have even pulled out the excel developers handbook
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
Yes, RAM is correct, you'll need VBA. This is what I understand so far:

Date to match will be in A1 of Sheet1.
You would like the three cells (B, C & D) copied to, and transposed (going down), to the matching date column.

Is this correct? If not, please line out what I have missed or mistaken. Also, please provide info on how you know which row on Sheet1 you want to transfer, as there are multiple rows you show. Would this be user selected? Predetermined? Set at runtime? Hardcoded?
 

Forum statistics

Threads
1,171,504
Messages
5,875,906
Members
433,160
Latest member
Tmoff

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?

Disable AdBlock

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
Top