ziad alsayed
Well-known Member
- Joined
- Jul 17, 2010
- Messages
- 665
dear all
i have two workbooks. the first is named data and the second is named study
the data workbook has two sheets the first is named "phdata" and the second is named "apapadata". both has the same format . each include month ( jan till dec) starting from B1 till M1
i need to move th date in each worksheets starting from B2 to M2 to the study workbook.
the study workbook has also two sheets the first is "phstudy" and the second is "apapastudy" . they also has the same format like the data workbook
what is need to do is to copy the data from the data workbook to the study workbook, it means from the sheet "phdata" to the Sheet "phstudy" and from the sheet "apapadata" to "apapastudy"
in summary both workbook has the same format.
apprceciate any assistance.
below is what is have in the data workbook and need to move sheet by sheet to the study workbook
Excel 2010
Excel 2010
i have two workbooks. the first is named data and the second is named study
the data workbook has two sheets the first is named "phdata" and the second is named "apapadata". both has the same format . each include month ( jan till dec) starting from B1 till M1
i need to move th date in each worksheets starting from B2 to M2 to the study workbook.
the study workbook has also two sheets the first is "phstudy" and the second is "apapastudy" . they also has the same format like the data workbook
what is need to do is to copy the data from the data workbook to the study workbook, it means from the sheet "phdata" to the Sheet "phstudy" and from the sheet "apapadata" to "apapastudy"
in summary both workbook has the same format.
apprceciate any assistance.
below is what is have in the data workbook and need to move sheet by sheet to the study workbook
| Excel Workbook | |||
|---|---|---|---|
| H | |||
| 5 | |||
phdata | |||
| Excel Workbook | |||
|---|---|---|---|
| G | |||
| 3 | |||
ApapaData | |||
