How to copy data from one excel table to other

Closed
rkindia
Posts
1
Registration date
Wednesday June 18, 2014
Status
Member
Last seen
June 18, 2014
- Jun 18, 2014 at 05:02 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Jun 19, 2014 at 10:51 AM
I have two sets of excel tables. The master table has got several columns with heads defined. Similarly, the row heads have also been defined.

Now, I want to populate this table from another excel table which is a subset of the master table ( only certain columns and row heads common with the master table). In other words, I need to write a micro, which can do a two way ( vertical / horizontal ) lookup in table 2, and then populate the data at an appropriate cell in the master table.

Any assistance is greatly appreciated.

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
Jun 19, 2014 at 10:51 AM
Hi Rkindia,

Try putting VLOOKUP functions in your master table to pull data from your subset table.

Let us know if you get stuck.

Best regards,
Trowa
0