Copy Data in excel 2003

  • Thread starter Thread starter JS1
  • Start date Start date
J

JS1

Hi Forum,

In Excel 2003, I have a list of 1300 headers for 13000 records. My headers
are like below (Dogs, Cats, Balls...) and are associated to a varied amount
of records.

I want to replicate the headers to all associaed records (like Dogs A1-A3,
Cats to A4-A8, Balls to A9-A12, or into another column).

Dogs Spaniel
Poodle
Hound
Cats Black
Brown
Dark
Bright
White
Balls Black
Red
Blue
Green

Hope I've made what I am after, clear.
Thanks for your help.

John.
 
--Select a unused cell say E2
--Enter the formula in cell E2 which references the top cell (=E1)
--Copy the cell
--Keeping the copy select the data range in ColA (say A1:A12).
--Press F5. From Goto window select blanks
--This will select all blanks.. Now Right click>PasteSpecial>Formulas. will
fill in with the data you need..
--Once done you can select col A > Copy >PasteSpecial>Values to turn
formulas to actual values

If this post helps click Yes
 
Highlight your data area with the active cell as A1, then press F5
(GoTo), and click on Special, then click Blanks - A2 will now be the
active cell. Begin to enter a formula by typing =, then click on the
cell above (A1), then do CTRL-Enter and the formula will be propagated
to all the blank cells. You could then fix the values.

Hope this helps.

Pete
 
Thanks to you both, for your quick & expert advice. Worked a treat & saved me
lots of manual work.

Rgds.,
John.
 
Back
Top