Hi community:

I've been searching for a while to find an answer to my problem but
couldn't, so here it is:

A B
1 1001 Food Sales Lunch
2 1002 Food Sales Dinner
3 1003 Food Sales Catering
...

I have the same struture of data on another 40 sheets in the same workbook.
I want to name each of the cells A1, A2, A3, ... 'ACCOUNT'.
the same for Sheet2, Sheet3, .... sort of a relative rather than absolute
reference.

So, when using ACCOUNT in a formula in e.g. Sheet1, cell C1, ACCOUNT refers
to cell A1, when using the same name in line 3, it refers to A3 and so on.

thanks a lot in advance!
Thomas