Hi,

I'am struggling with the following...

on sheet1 i have the folowing columns containing the data ofemployees

In cell A1: the company name
B: name
C: date of birth
D: age
E: salary
F: parttime%

There could be x (different for eacht company) people in the sheet

when the project is closed, i would like to save the data of the employees in
sheet2 in the columns:
A: name of the company
B: name employee
C: date of birth
D: salary
E: parttime%

note: not all columns of sheet 1 need to be saved, just a few.

Each time a company is put in it should add the employees on sheet 2 to the
list of employees. So sheet2 can contain multiple employees of multiple
companies and sheet1 will contain only the employees of one company.

Does anybody have the code to be able to save the data from sheet1 in sheet 2
(starting from the last empty row)
I would be much obliged !!
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200509/1