software

Hi all!

I *was* very proficient with Excel back in the days when you could use
the old command macro language, but haven't really had the chance to
get up to speed with Excel and the VBA (?) based language now used -
I'm not even sure I've described that accurately. Anyway...

I've got two spreadsheets of large enough size that I'd rather not do
this process by hand. One spreadsheet is pretty much a quot;subsetquot; of the
other based on a few columns, e.g. quot;Namequot;, quot;Addressquot;, quot;Agequot;. I'd like
to take a row from the quot;subsetquot; spreadsheet and copy the data
corresponding to quot;Namequot;, quot;Addressquot;, quot;Agequot;, etc. and paste it into the
quot;masterquot; spreadsheet. The end result would be all rows found in the
quot;masterquot; with additional data found in quot;subsetquot; would be updated.

Here's an abbreviated example:

MASTER SPREADSHEET
col1 col2 col3 col4
a 1 2 3
a 4 7 2
b 5 6 7
c 8 9 0

SUBSET SPREADSHEET
col1 col2 col3 col4
a 1 z y
c 8 q r

RESULTING SPREADSHEET
col1 col2 col3 col4 col5 col6
a 1 2 3 z y
c 8 9 0 q r

Does that make sense? How do I approach this? Macros? Excel database
functions? (which I haven't had the opportunity to play with)

Thanks for reading!
DennisThe easyest way would be Microsoft Query
Datagt;External Datagt;Create Query

HTH
--
AP

gt; a écrit dans le message de oups.com...
gt; Hi all!
gt;
gt; I *was* very proficient with Excel back in the days when you could use
gt; the old command macro language, but haven't really had the chance to
gt; get up to speed with Excel and the VBA (?) based language now used -
gt; I'm not even sure I've described that accurately. Anyway...
gt;
gt; I've got two spreadsheets of large enough size that I'd rather not do
gt; this process by hand. One spreadsheet is pretty much a quot;subsetquot; of the
gt; other based on a few columns, e.g. quot;Namequot;, quot;Addressquot;, quot;Agequot;. I'd like
gt; to take a row from the quot;subsetquot; spreadsheet and copy the data
gt; corresponding to quot;Namequot;, quot;Addressquot;, quot;Agequot;, etc. and paste it into the
gt; quot;masterquot; spreadsheet. The end result would be all rows found in the
gt; quot;masterquot; with additional data found in quot;subsetquot; would be updated.
gt;
gt; Here's an abbreviated example:
gt;
gt; MASTER SPREADSHEET
gt; col1 col2 col3 col4
gt; a 1 2 3
gt; a 4 7 2
gt; b 5 6 7
gt; c 8 9 0
gt;
gt; SUBSET SPREADSHEET
gt; col1 col2 col3 col4
gt; a 1 z y
gt; c 8 q r
gt;
gt; RESULTING SPREADSHEET
gt; col1 col2 col3 col4 col5 col6
gt; a 1 2 3 z y
gt; c 8 9 0 q r
gt;
gt; Does that make sense? How do I approach this? Macros? Excel database
gt; functions? (which I haven't had the opportunity to play with)
gt;
gt; Thanks for reading!
gt; Dennis
gt;