matrix26
Board Regular
- Joined
- Dec 16, 2020
- Messages
- 57
- Office Version
- 365
- Platform
- Windows
Hi,
I'm using this formula to check if a specific cel reference on a sheet has any data in it and if it does then that is copied to the relevant cell
=IF('Sheet1'!H2="","",'Sheet1'!H2)
How would I amend this so that if it found a blank cell on Sheet1 it filled the relevant cell with the word PAUSE and stopped processing any following lines, I don't want lots of lines with PAUSE?
Is this even possible?
Thanks in advance
I'm using this formula to check if a specific cel reference on a sheet has any data in it and if it does then that is copied to the relevant cell
=IF('Sheet1'!H2="","",'Sheet1'!H2)
How would I amend this so that if it found a blank cell on Sheet1 it filled the relevant cell with the word PAUSE and stopped processing any following lines, I don't want lots of lines with PAUSE?
Is this even possible?
Thanks in advance