LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default merging two worksheets

I have two woksheets of voter data. The first worksheet has three columns:
Voter ID#, Election Date, Election discription, Voting Method.

The second worksheet has multiple columns, the first being Voter ID#. The
remaining columns are -First Name, Last Name, Street number, Street Name,
Phone number, Precinct Name, ....and so on.

I wish to pull the individual information columns from the second worksheet
into the First worksheet based upon the 1st column that is common to both
worksheets-Voter ID#.

There are more entiries in the second worksheet than the first. I only need
the additional info from the second worksheet for the Voter ID#s that are
listed in the First worksheet.

This is 140,755 rows for The First woksheet.

I am a novice at this. I have the original data of these worksheets on a CD
in text, comma deliniated format also, if this helps make it easier. I do not
have Access, but I am not opposed to getting it if it would make this easier.
--
Jim B
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
merging worksheets KRK New Users to Excel 1 June 25th 09 03:30 PM
merging worksheets rsjmk Excel Discussion (Misc queries) 1 October 31st 07 07:43 PM
Merging worksheets together sschwickrath Excel Discussion (Misc queries) 1 September 30th 07 06:08 AM
merging worksheets thebaldsoprano Excel Discussion (Misc queries) 3 February 24th 07 11:25 PM
Need help merging worksheets carmeljo Excel Discussion (Misc queries) 4 January 28th 06 11:15 PM


All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"