Move Cell in non active sheet to specific range

I want to move the cell to B2 after the below macro is executed.

Please Login or Register  to view this content.

The macro is copying data from User1 Report and User2 Report and pasting it into Overall Data, the data in the User sheets will be added daily and once the Append is done, data in both the sheets will be cleared and the cell is not referring to second row of the user sheet i.e. B2. I need to manually move the cell to B2 in both sheets.

Is there any code to add to the above macro to move the cell to B2 in both the sheet?

Please help me on this.
Pradeep

Is this what you mean?

Please Login or Register  to view this content.

Thalassa,

Thank you so much.........really appreciated your quick response.

Is it possible to add a message box if both the sheets does not have any data to append?

In the morning i have posted a thread for the solution and no one replied, instead Forum moderator is telling me all the rules to follow.

then i changed the status to solved an post a new thread with all the forum rules. I was so disappointed.
But at last i saw u online thought let me try once and left a PM, tht worked.

Thanks
Pradeep

Maybe like this

Please Login or Register  to view this content.

U r Gr8 Thalassa

Thank you once again for helping me.

It worked a treat