Now i have a new question,
1.on the first tab "Scenario" ,i want to copy value from F5 and paste it over to B5 of tab"Plan Attributes", then on the plan attributes tab, copy C62 to HJ74 the whole block, paste values to results starting from C2.
2. then i want to copy value from G5 and paste it over B5 of tab plan attributes, then on the same tab, copy C62 to HJ74 whole block ,and paste add values starting from D2.
3. then i want to copy value from H5 and paste it over B5 of tab plan attributes, then on the same tab, copy C62 to HJ74 whole block ,and paste add values starting from E2.
........do this until we stop at Q5 last value .
after we finish all values from ROW 5, we start on row 6, the same procedure. unitl we finish on row 51.
I have the excel sheet.
Bookmarks