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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 19, 2014 at 10:51 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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.
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.
Related:
- How to copy data from one excel table to other
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- How to delete part of a table in word - Guide
- Tmobile data check - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 19, 2014 at 10:51 AM
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
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