Finding the 1st blank cell in a column and returning the Cell reference

[buyshirts]

So i have a workbook with several worksheets in the 1st i have data that i input manually and then on the other worksheets i present that data in various ways.
What i ideally would look to be able to do is use the Go to ((F5) function, so when viewing the presented data i would like to be on of the the worksheets hit F5 that bring up the Go to box and then click and that take me back to the data input worksheet in the 1st blank cell in column A and i can then just start inputting new data.

I have have asked to find the 1st blank cell in a column and return the cell reference as i feel if i can get that i probably can work the rest out myself (so not being too lazy and getting the fine minds on here to do it all for me, feel feel to give me the total solution if you know it!)

Thanks in advance

 

[Fluff]

Duplicate to: Using Lookup + Row functions with Go to (F5)

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.