merge worksheets

  • Thread starter Thread starter Dave Melosi
  • Start date Start date
D

Dave Melosi

Hi,
I have 2 excel worksheets. They both have a common
field "councilNum". 1 worksheet has 400 records, the
other has 30,000 records. The worksheet with 400 records
has a field "district" in it. All of the 30,000 records
need to have the correct district applied to it.
(several records in the 30,000 will have the same
district in it)

I am at a loss on how to do this. Is there a formula in
excel to do it?

Thanks,
Dave
 
Hi
and what should this formula do?. Check if every district number in
your 30.000 records file is valid?
 
No I want to insert the district from the 400 records
into a field that i will also name district (but is
blank) in the 30,000 sheet when the councilName = the
councilName
 
Back
Top