Copy data from one excel sheet to another based on condition

Hi all,
I am having a new workbook with 2 sheets, where sheet1 contains the data as follows

sheet1.png

Now when I started changing cell in sheet1(Except first row which is ID), I need to do the following

If there are no records in Sheet2 I need to create the columns with same headers of Sheet1
I need to copy entire data from Sheet1 to shee2 based on active row of Sheet1 (means if I am doing modifications for the row2 then I need to save only that row to sheet2)
If the same row already exists in sheet2 I want to replace the entire row with the current changes in sheet1

Please check my word document where I have given scenarios how my requirement is

Originally Posted by mehmetcik

You should attach spreadsheets really.

Perfect thanks mehmetcik

Originally Posted by sktneer

Hi,
Welcome to the forum.

Please find the attached sheet and see if this is what you are trying to achieve.
The code is present on Sheet1 Module.

Perfect thanks sktneer

One small question if I had more columns like address, phone number how can I make it in dynamic way for the same

Here is the sample attached, in this I am having 3 columns like ID, Name, Address what I need is the macro that you have given should work for all the columns I am having.

Originally Posted by sktneer

Please find the attached sheet and see if this is what you are trying to achieve.

Thanks sktneer, I will give it a try

Originally Posted by sktneer

Did you check the file attached in post#9?

Yes but when I opened the document entire data should not get copied, sheets should be same as the original document but when I start editing data on any sheet then only that data should go to newly created one, like your solution for #3

Originally Posted by sktneer

Did you check the file attached in post#9?

Yes but when I opened the document entire data should not get copied, sheets should be same as the original document but when I start editing data on any sheet then only that data should go to newly created one, like your solution for #3

Originally Posted by sktneer

Please find the attached sheet to see if this works now as per your expectations.

Thanks sktneer this meets my requirement

Originally Posted by sktneer

You're welcome. Good to know that.

If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

Done sktneer, thanks for helping

Hi I got one problem with the macro When I am having the same names and when editing the data instead of pasting it in original cell it was placing in another cell can you help me