sujittalukde
02-23-2008, 12:48 AM
I have a workbook named ?RowBasedSheet.xls? which contains data across rows in various sheets.
The rows contains the name of the employees and other related data.
I want to create a output report for all the rows ie employees to a new workbook by taking values from different sheets.
A sample WB is attached to clarify the matter.
Note that in all the sheets, the name of the employees will be same in order, position etc.
While transferring data from the rows to the new workbook and placing the data to new WB, some calculations has to be made also which will be same for all the records.
How can this be done?
Other thing is that as the report in new workbook will be in a fixed format can I use the Template(xlt) file ie One template file will the saved and sheets will be added for the rows?
The rows contains the name of the employees and other related data.
I want to create a output report for all the rows ie employees to a new workbook by taking values from different sheets.
A sample WB is attached to clarify the matter.
Note that in all the sheets, the name of the employees will be same in order, position etc.
While transferring data from the rows to the new workbook and placing the data to new WB, some calculations has to be made also which will be same for all the records.
How can this be done?
Other thing is that as the report in new workbook will be in a fixed format can I use the Template(xlt) file ie One template file will the saved and sheets will be added for the rows?