Autofill row with a column entry


F

Ferdy

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

P1234 Prog1 Prog2 Prog3 etc

Where typing P1234 will automatically fill in theneccessary operations for
that job in D2,3,4 etc
 
Ad

Advertisements

G

Gord Dibben

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
 
Ad

Advertisements

C

Cory Howard

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.

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top