I am currently writing a spreadsheet where i put numbers across a page and
they are in columns 1 to 14.

I want a code to look up the last used cell on column "g4" for example

and give me the corresponding cell on g1

I am not sure on how to word this. Hope this is clear enough

Thanks in advance

Greg