Pierre
I don't know what you mean when you say "save". To save a file is to
write it to disk. Obviously you mean something else when you say you want
to save data to Sheet2. Do you mean copy to Sheet2? From where?
If you wish, send me direct via email a small file showing what you have on
each of the two sheets. Then include some examples of what you want Excel
to do. Assume that I know nothing about what you have, what you are doing,
and what you want Excel to do. Also tell me the version of Excel you are
using. My email address is . Remove the "nop" from
this address. HTH Otto
"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:5521b7ec1b2e1@uwe...
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