Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default assign dataset to matching dataset

Hello
Ich have two tables. The datasets of these tables should be assigned to
the matching dataset.
The identification of the dataset goes by the content of column A

That means : copy dataset1 from Table1 to Dataset xy if the content in
cell A2 matches
How can I programm this in Excel?

Thank you very much for your help!
MIchael


Table1
A B C
big 1 2
ltl 34 21
mid 4 5


Table2
A B C
mid 44 33
ltl 11 22


Endtable
A B C D E
ltl 1 2 11 22
big 34 21 44 33
mid 4 5
Reply
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
Converting A Quarterly Dataset to Weekly Dataset Dan Thompson Excel Programming 5 November 25th 05 09:27 PM
Counting a Filtered Dataset T De Villiers Excel Worksheet Functions 1 September 5th 05 04:28 PM
Sum a dataset with 2 criteria ineedhelp2[_5_] Excel Programming 0 August 24th 05 09:44 PM
creating a new dataset brian kaufmann Excel Programming 0 August 16th 04 08:47 PM
two dataset comparison Scoomie Excel Programming 1 June 19th 04 07:47 PM


All times are GMT +1. The time now is 04:00 AM.

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"