Excel 2007 one to many relationships

  • Thread starter Thread starter Bruce D.
  • Start date Start date
B

Bruce D.

I am using version 2007 and have imported about 10,000 records containing
account numbers and other various fields. The problem is that from the import
I will have the primary record showing the account number and then maybe 4
secondary records below the primary record but with no account number. I
would like to find a way to copy the account number to the empty account
number fields in the records below the primary. I do not want to have to
manually copy & paste from each account number to the empty secondary records
below. Is there a formula I could use?

Thanks to anyone who responds!
 
Bruce,

Select the column with the blanks, use the Editing section on the Home tab,
click the small arrow next to Find & Select. Select Go To Special. Select
the Blanks radio button and click OK.
Then type = press up arrow once, and press Ctrl-Enter. Then copy the
column and paste values, and you're done.

HTH,
Bernie
MS Excel MVP
 
Back
Top