need to put text in a different cell if destination cell contains text.

[jacobtest]

Hello,

I have a problem and I need some help, I think this will involve a combination of IF statement and ISNUMBER functions but I'm not sure.


I want to create a button that will put specific text in a cell when pressed, or if the cell has text in it already put the text in the cell below.


This doesn't sound as if it should be too difficult, but I've tried a few things but can't make it work.


Any help or advice appreciated.

Thanks, Jacob

[jraj1106]

Hi Jacob,

Where do you want the text to be inserted?Specify the cell..

[jacobtest]

Thanks for getting back to me so quickly,

I'll give some more information...

I've got a spreadsheet with several sheets,

I need to create a button that will put specific text in Cell P27 of a different sheet in my spreadsheet, or if this already has text in it, in P28, or P29, and onwards.

[jraj1106]

Try this.Please change the source part. I have simply put a text.

puttext.xlsm

[jacobtest]

Awesome! that's great! I've made that work really well, Thankyou!!

[jraj1106]

Happy to hear that

Please click the star below.

Thanks