Cell formula for adding a second list of products to the bottom of the first variable list

[Peter Davison]

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

 

[smozgur]

I have managed a work around.

Glad to hear you got the solution.

If you could post your workaround, then it is perfectly fine to mark your post as the solution to help future readers.
Otherwise, please do not mark a comment as a solution.

 

[Peter Davison]

Okay no problem