Autofilling Alpha-Numeric numbers with column headers
 

Edited to clarify question...

I have to complete an unfiltered table using formulas....The columns go from 1-16 and the rows g from A-Z. In row A it goes....1A, 2A,3A,4A all the way to column 16, which is 16A. The same happens for Row B. I have to create a formula to fill in the rest of the rows/columns with the same sequence. What formula do I use? Or does this require a macro formula? I'm really stumped on this one and have to have this compete by Monday morning...HELP!

Autofilling Alpha-Numeric numbers with column headers
 

Hi Jack,

Am Sun, 3 Jun 2012 11:15:59 +0000 schrieb JackofAllTrades:

I have to complete an unfiltered table using formulas....The columns go
from 1-16 and the rows g from A-Z. In row A it goes....1A, 2A,3A,4A all
the way to column 16, which is 16A. The same happens for Row B. I have
to create a formula to fill in the rest of the rows/columns with the
same sequence. What formula do I use? Or does this require a macro
formula?

A1 = 1A, B1 = 2A,
A2 = 1B, B2 = 2B and so on?


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Not sure I understand what you mean. Could you post an example with some details of how you got to the results. That would make it easier to help out with formulas/macros.

Autofilling Alpha-Numeric numbers with column headers
 

Hi Jack,

Am Sun, 3 Jun 2012 15:54:54 +0200 schrieb Claus Busch:

A1 = 1A, B1 = 2A,
A2 = 1B, B2 = 2B and so on?

then try in A1:
=COLUMN()&CHAR(64+ROW())
and fill to P16


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2