Excel: scripting the copying of data to specific cells

[CFeyrer]

OK, here's the situation:
I have a spreadsheet that sorts related records like this.
FIELD1(tabl)RELATED RECORD1
(tab)(tab)RELATED RECORD2
(tab)(tab)RELATED RECORD3
FIELD1(tab)RELATED RECORD1
(tab)(tab)RELATED RECORD2
etc.
Now, I need FIELD1 to appear on every row for every related record. This would be simple, I'd just drag FIELD1 down in Excel with the grab bar for each set of related records -- but I'm dealing with 64,000 records. Any ideas would be welcome on how to automate FIELD1 being inserted into its appropriate following rows.

Thanks,

Christopher Feyrer

 

[SkipVought]

Christopher,

You can use a formula like this in COLUMN C, for instance...
[tt]
C2: =if(isblank(A2),C1,A2)
[/tt]
Copy the formula in C2 down thru the rows of data.

Copy Column C

Select A1

Edit/Paste Special - Values

BTW, be sure to save a copy before attempting this.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[CFeyrer]

Hi Skip,

Great idea. I have a few questions:
How do I use this formula without destroying the related record data in column C?
Why, when I go to paste, do I not have a paste values option in Column A (it only asks to paste unicode or text in paste special).

Thanks.

Chris

 

[SkipVought]

THis formula goes in an empty column NOT in one with data or formulas.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884