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![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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 !
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)