Hi - got a problem i hope you'd be able to help me solve.
I have workbook (attached here) with two sheets, "Data Input" & "Format" - "Format" is a hidden sheet. In the "Data Input" sheet I have 1 header row (row 1) and X data rows (rows 2-X). I need to for each data-row:
- Create a copy of the "Format" sheet
- Copy the current data row from "Data Input" into the newly created copy of "Format" in A36:X36
- set the name of the newly created sheet to the value in cell B36
- Hide range A35:X36 in the newly created sheet
When done for all data-rows i need to
- Hide the "Data Input" sheet
Any help would be greatly appreciated!
Br Jonas Solar-Weekly-0.1.xls