I cuurently have data setup in the following format:
Columns:
A: Year
B: SS#
C: Dept#
D: Employee
E: Start Date
F: All Other
G: IS Pro
H: IS Dev
I want to take the information in columns F-H, or a selected range, and put them in rows only if the value in the cell is not zero. So if cell F5 has a value of .5, and G5 has a value of .5, and H5 is 0 then two rows will be created in a new workbook with columns A-E being the same, column F as the heading from F-G and column G as the value from the cell (.5)
Sound possible?
Columns:
A: Year
B: SS#
C: Dept#
D: Employee
E: Start Date
F: All Other
G: IS Pro
H: IS Dev
I want to take the information in columns F-H, or a selected range, and put them in rows only if the value in the cell is not zero. So if cell F5 has a value of .5, and G5 has a value of .5, and H5 is 0 then two rows will be created in a new workbook with columns A-E being the same, column F as the heading from F-G and column G as the value from the cell (.5)
Sound possible?