Code to copy, paste without replacing the existing data

Hello,

I have two sheets - sheet1 and sheet2. Everytime i run a macro in the sheet1and manually copy the rows from sheet1 {starting (A2:AI2)} and paste as values it in the sheet2 {starting (A2:AI2)}.

Then I ll delete the available datas in the sheet1 and will run a macro for different customer.

Again I need to repeat the same action (manually copy and paste the datas to sheet2) without replacing the existing data in the sheet1.

In simple I require a macro code where it copy the available information in sheet1 and paste it as values in the sheet2 without replacing the existing one.

I know this is very simple for you people, but not for me:-)

Thank You!

Hi,
Can you post the sample workbook.

Regards,
Vaibhav

I have attached it. I ve hidden few cells to show you the format it looks like (though it doesn't any info).

I ve already copy, pasted the first set of datas to the sheet2.
Now I have given some info in the sheet1 which i need to copy,paste in the sheet2 without replacing the existing ones.

Thank You!

I have a recorded macro for this.. but it is replacing the existing datas..

Any help is appreciated..

Anyone find a code for this:-)

Thank You!

Is this very tough task...
:-(

can someone help me out with this. I have been trying various ways to do this.. nothing worked out:-(

I Have been trying for this almost a very long time :-(((((

Hi
Thank u for the code

I have protected the column A as it contains formulas till cell A100, so it is showing the error message "the column is protected"
Then I have unprotected the column, then tried running the macro.. Now it is copying the column A alone and pasting it.
I would like to copy the entire row from A2 to AI2 ans paste in the sheet2 as values

Column A contains formulas till A100. But the information in Column D2 to AI2 might be lesser than the Column A which contains formulas.
Randomly I have given the formulas till cell 100

Awesome Tiger

Thank You so much

:-))))))))))))))))))))))))))))))))))))))))))))))

share knowledge
Please remember to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

I will do that. But before that I have a small problem in this macro.

If there is only one line/row. I am getting an error in the line

Set rDe = shDe.Range("A" & iR & ":AI" & iR).Resize(nR)

I want this macro to run even if there are no rows or any single row.

Thanks a lot.

Experts, Any solution for this?

Can anyone help me editing this code?

Thanks in advance

Can anyone help me out in editing this code?

still need help? you were asked to mark this thread as solved you didn't