Copy and Insert Entire Row into another sheet

Hi Folks,

I have a macro (courtesy another forum which I modified) which copies an entire row based on a 'cell value' and moves it to another sheet which is named as the 'cell value'. All the cell values are in the same column. For ex: If the cell value is Parag, then it copies all the rows with Parag to the sheet named Parag and so on.

But when I refresh the sheet it overwrites instead of inserting new rows in the sheet named Parag.

I am not a VBA expert and I have very limited knowledge.

Below is my code:

Please Login or Register  to view this content.

Please help

Thanks Shiva

Hi shivark79,

Why don't you try:

Please Login or Register  to view this content.

for "Parag" as well as "Ganesh"??

thanks Adept!!

I have another question.. Can I modify my macro to do the below:

The sheet PendingItems is always refreshed with new data. Some of those data may already be available in Sheets 'Parag' and 'Ganesh'. Is it possible to check for duplicate rows from the PendingItems sheet with sheets 'Parag' and 'Ganesh' and delete duplicate rows from the PendingItems sheet only?

Yes, it's possible.

Is there a way to do it? Sorry for the trouble if I am asking too much..

Say sheet PendingItems Row A4 should check against sheets Parag and Ganesh, if its not available move to row A5 and if available delete it from PendingItems sheet and then move to row A6 and so on..

The problem I am facing is that are many other sheets in the workbook which should not be checked during this macro. I am not able to come to a conclusion..

Tried this code and included it in my macro above.. but still does not work..

Please Login or Register  to view this content.

Hi Shiva,

Can you post an example book?