Hello team,
I have to paste lots of rows to another workbook, the first workbook is a time sheet. it has columns as: project name, sub project, days of the week and date (which is the first week of April). If a project Manager has worked on a project on Monday, Tuesday and Wednesday (days are across the row in cell F2 to L2), then in the second sheet: I have to repeat the Project name three times and put the hours in front of that project in an adjacent column vertically and then dates are from 04/01/02014 to 04/06/2014 (which the first week of April), I have put a drop down list in a column that I can select the date for the that pertaining hour.
The project hours are across column but when I want to paste it to second workbook, I have to paste it vertically (which I can paste it transpose).
We need to move data to a system so we need data to be transposed, I need to paste data from rows to columns that I know we can do that in excel.
Is there an easy way to take care of this task?
I always appreciate your help.
GN0001
I have to paste lots of rows to another workbook, the first workbook is a time sheet. it has columns as: project name, sub project, days of the week and date (which is the first week of April). If a project Manager has worked on a project on Monday, Tuesday and Wednesday (days are across the row in cell F2 to L2), then in the second sheet: I have to repeat the Project name three times and put the hours in front of that project in an adjacent column vertically and then dates are from 04/01/02014 to 04/06/2014 (which the first week of April), I have put a drop down list in a column that I can select the date for the that pertaining hour.
The project hours are across column but when I want to paste it to second workbook, I have to paste it vertically (which I can paste it transpose).
We need to move data to a system so we need data to be transposed, I need to paste data from rows to columns that I know we can do that in excel.
Is there an easy way to take care of this task?
I always appreciate your help.
GN0001