Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Autofill row with a column entry
8 views
Skip to first unread message
Ferdy
Nov 2, 2009, 1:59:01 PM11/2/09
to
Is there a way to autofill a row with alpha numeric data using data entered
in the first column. i.e.
D1 D2 D3 D4
in the first column. i.e.
D1 D2 D3 D4
P1234 Prog1 Prog2 Prog3 etc
Where typing P1234 will automatically fill in theneccessary operations for
that job in D2,3,4 etc
T. Valko
Nov 2, 2009, 2:09:43 PM11/2/09
to
See if this helps:
http://contextures.com/xlFunctions02.html
--
Biff
Microsoft Excel MVP
"Ferdy" <Fe...@discussions.microsoft.com> wrote in message
news:564A9E34-D9C2-4616...@microsoft.com...
Gord Dibben
Nov 2, 2009, 2:21:10 PM11/2/09
to
I think you have your rows and columns mixed up.
But see Biff's reply pointing you to a website.
Gord Dibben MS Excel MVP
On Mon, 2 Nov 2009 10:59:01 -0800, Ferdy <Fe...@discussions.microsoft.com>
wrote:
Cory Howard
Nov 25, 2009, 2:34:00 AM11/25/09
to
I have a question. I need a formula and have no idea how to write it.
I need it to be alpha numeric listing as shown below.
I need it to be alpha numeric listing as shown below.
A-1A
A-1B
A-1C
A-2A
A-2B
A-2C
Going from A-1A to A-8C for every letter A-Z so will start at A-1A and
ent at Z-8C.
Can anyone help me out?
0 new messages