Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 435
- Office Version
- 365
- Platform
- Windows
I have a list of products A35 to A300 on Sheet 1
I have a second list of products A35 to A50 on Sheet 2
I want to add the second list one by one to the bottom of the list on sheet 1, but the end of sheet 1 may be 300 or could be 303 or 306 etc.
Is there a cell formula that can achieve this?
I thought it might be an If with a count etc.
As always any help you can give would be great.
Thanks
I have a second list of products A35 to A50 on Sheet 2
I want to add the second list one by one to the bottom of the list on sheet 1, but the end of sheet 1 may be 300 or could be 303 or 306 etc.
Is there a cell formula that can achieve this?
I thought it might be an If with a count etc.
As always any help you can give would be great.
Thanks