LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
metrueblood
 
Posts: n/a
Default Combining Tables

I have two tables with different sets of information, but they have a column
in common - the ID number. The tables have differing numbers of rows, ie.
some of the ID numbers in one table are not in the other table. How do I go
about combining the two tables, so that the ID's match up, and the info from
one table is carried to the matching ID in the other table? Sure appreciate
your help on this - i'm under a lot of pressure to do this quickly, and
cannot afford the time to go line by line matching ID's!!! :-) Thanks!
mary trueblood
 
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
Autofiltering multiple tables on a spreadsheet Paul Excel Worksheet Functions 1 January 26th 05 12:47 AM
refresh pivot tables through a macro dolph Excel Worksheet Functions 1 January 12th 05 03:16 AM
Pivot Tables - Variance and % Variance fields CraigS Excel Discussion (Misc queries) 5 January 6th 05 12:22 AM
Can I use median function in Pivot Tables? larrymorris4 Excel Worksheet Functions 2 December 30th 04 06:49 PM
How to paste Xcel tables legibly into Word . Help!! Nimo Excel Discussion (Misc queries) 1 December 14th 04 09:53 PM


All times are GMT +1. The time now is 01:16 AM.

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

About Us

"It's about Microsoft Excel"