DKRbella0814
Board Regular
- Joined
- Aug 10, 2008
- Messages
- 155
I have a workbook that has been constructed as follows
sheet1 = data (production data specific to machining cells (there are 6 cells total))
CL = constraint lathe
L09 = Lathe constraint
M01 = Mill constraint
M03 = Mill constraint
Plastic constraint
VCM = vertical constraint mill
On any given day, a maximum of three of the above cells will be active on the floor, and production data will be gathered for each of the machines that were running within that cell.
sheet2 = CL Map (should pull active jobs (from data sheet) and paste them into appropriate cells on the map of the machining cell)
sheet3 = CL (production - expected vs actual calculations); should pull actual # pcs run per time period (from data sheet) and past them into appropriate cells on the form to generate expected vs actual calculations.
*The Map and Calculation sheets are set up within the SAME workbook for each of the 6 machining cells referenced above.
So,
sheet4 = L09 map
sheet5 = L09 Calculations
Sheet6 = M01 Map
sheet7 = M01 Calculations
sheet8 = M03 map
sheet9 = M03 Calculations
sheet10=Plastic map
sheet 11=Plastic calculations
sheet 12=VCM map
sheet 13 = VCM calculations
My question is whether there is a way to write a macro that would look up the active row in the data sheet and identify which machining cell it is for so that it would copy and paste the values from the data sheet into the appropriate Map and Calculation worksheets contained within the same workbook. OR...do I have to write individual macros and have the user of the workbook select the correct macro to run from the Macros menu based on which cell they are entering the data for?
sheet1 = data (production data specific to machining cells (there are 6 cells total))
CL = constraint lathe
L09 = Lathe constraint
M01 = Mill constraint
M03 = Mill constraint
Plastic constraint
VCM = vertical constraint mill
On any given day, a maximum of three of the above cells will be active on the floor, and production data will be gathered for each of the machines that were running within that cell.
sheet2 = CL Map (should pull active jobs (from data sheet) and paste them into appropriate cells on the map of the machining cell)
sheet3 = CL (production - expected vs actual calculations); should pull actual # pcs run per time period (from data sheet) and past them into appropriate cells on the form to generate expected vs actual calculations.
*The Map and Calculation sheets are set up within the SAME workbook for each of the 6 machining cells referenced above.
So,
sheet4 = L09 map
sheet5 = L09 Calculations
Sheet6 = M01 Map
sheet7 = M01 Calculations
sheet8 = M03 map
sheet9 = M03 Calculations
sheet10=Plastic map
sheet 11=Plastic calculations
sheet 12=VCM map
sheet 13 = VCM calculations
My question is whether there is a way to write a macro that would look up the active row in the data sheet and identify which machining cell it is for so that it would copy and paste the values from the data sheet into the appropriate Map and Calculation worksheets contained within the same workbook. OR...do I have to write individual macros and have the user of the workbook select the correct macro to run from the Macros menu based on which cell they are entering the data for?
all formulas have been copied down to row 5000 for the appropriate column
