View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bruce D. Bruce D. is offline
external usenet poster
 
Posts: 14
Default Excel 2007 one to many relationships

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