Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
big problem selecting and saving data
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
big problem selecting and saving data
Pierre
Your explanation of what you have and what you want to happen is somewhat convoluted and difficult to follow. Here is what I think you have and what you want. You have a sheet, say Sheet2. It has a listing of companies in Column A. The rest of the columns have data for a specific employee in each row. You have another sheet, say Sheet1. It is blank except for column headers in Columns B:F. You want to type the name of a company in cell A1 of Sheet1. When you do so, you want Excel to extract all the employee data corresponding to that one company from Sheet2 and place that data in Sheet1. Is this correct? HTH Otto "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:550e3ee6bb267@uwe... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
big problem selecting and saving data
Hi otto,
yes, you are correct. can you help ? By the way, i'am also looking for a solution the other way....that is to save all employees of this particular company in sheet 2. Otto Moehrbach wrote: Pierre Your explanation of what you have and what you want to happen is somewhat convoluted and difficult to follow. Here is what I think you have and what you want. You have a sheet, say Sheet2. It has a listing of companies in Column A. The rest of the columns have data for a specific employee in each row. You have another sheet, say Sheet1. It is blank except for column headers in Columns B:F. You want to type the name of a company in cell A1 of Sheet1. When you do so, you want Excel to extract all the employee data corresponding to that one company from Sheet2 and place that data in Sheet1. Is this correct? HTH Otto Hi, [quoted text clipped - 32 lines] I would be much obliged !! Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200509/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem in the data of the file in the FTP after the saving of excelsheets | Excel Discussion (Misc queries) | |||
Problem with selecting cells | Excel Discussion (Misc queries) | |||
saving to two places by selecting one (VBA) | Excel Programming | |||
saving to two folders by selecting one | Excel Programming | |||
problem with selecting something | Excel Programming |