Kay
Help us out here. Pretend that you have to do this manually (no
automation). Now come up with all the different scenarios of the possible
conditions that you might have, things like the Action# exists in sheet1 but
not in sheet 2, the Action# exists in both sheets, any other scenarios you
know about. Then give us a step-by-step of how you would handle each
scenario. Don't leave out any steps. Nobody knows what you have and what
you want like you do. HTH Otto
"kay" wrote in message
...
Hi
I have tow excel sheets.- sheet1 and sheet2
in sheet2 i have all columns from sheet1 + additional columns.
in sheet1 i have unique Action# column which does not have dublicate data.
and that ACtion# is in sheet2 (as i have copied Sheet1 data).

So what i want when some one adds or update data of sheet1,
i want to run a macro which adds new data(rows) into sheet2 and updates
data
as well (update means- if someone updates the data in sheet1, it should
update those data in sheet2 when you run a macro)

So need help to code macro which adds data in sheet2 and if data is there
then update it.

I appreciate for any help.

Thanks!