Sorry I meant sheet not workbook
Hi
I have 1 workbook, example, I have 1 sheet named 'Calls', in cell C4 a value will be entered for example '1 day'
I have another sheet on the bottom 'Collection' I want it to log/copy '1 day', from A1. But I still want this info to remain on 'Collection' even when '1 day' is deleted. Then I want it to jump onto row A2 ready for when a value is input again
So,
'1 day' is inputted into C4
On the other sheet starting from A1 it will log '1 day' then jump onto the next line when anything else is inputted onto C4
Hope that makes sense
Thanks
Hi
I have 1 workbook, example, I have 1 sheet named 'Calls', in cell C4 a value will be entered for example '1 day'
I have another sheet on the bottom 'Collection' I want it to log/copy '1 day', from A1. But I still want this info to remain on 'Collection' even when '1 day' is deleted. Then I want it to jump onto row A2 ready for when a value is input again
So,
'1 day' is inputted into C4
On the other sheet starting from A1 it will log '1 day' then jump onto the next line when anything else is inputted onto C4
Hope that makes sense
Thanks
Last edited: