cocolasticot50
New Member
- Joined
- Mar 19, 2024
- Messages
- 5
- Office Version
- 365
Hi everyone !
first of all thank you for all your posts.
It is my first query on this forum but I've already read some very interesting things !
Here is my problem. I'm having a hard time figuring out how to do the following, and I'm wondering if you could help out.
I have a worksheet with two differents sheets which have the same columns and I want to copy the rows from sheet 2 to sheet 1 but first, I need to check sheet 1 to make sure it doesn't already contain the rows (based on Cells Ato H) then I need to find the first empty row on sheet 1 and finally copy from sheet 2 the rows that don't already exists onto sheet 1.
Any idea how this could be achieved ?
Thanks a lot in advance for any help you can provide
first of all thank you for all your posts.
It is my first query on this forum but I've already read some very interesting things !

Here is my problem. I'm having a hard time figuring out how to do the following, and I'm wondering if you could help out.
I have a worksheet with two differents sheets which have the same columns and I want to copy the rows from sheet 2 to sheet 1 but first, I need to check sheet 1 to make sure it doesn't already contain the rows (based on Cells Ato H) then I need to find the first empty row on sheet 1 and finally copy from sheet 2 the rows that don't already exists onto sheet 1.
Any idea how this could be achieved ?
Thanks a lot in advance for any help you can provide
