General discussion

Locked

Updating one Excel Table from another.

By cwe ·
How to retrieve data to an Excel Table from another identical Excel table on the basis of records of a particular field/ column common to other table from which the data is to be retrieved

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Updating one Excel Table from another.

by DKlippert In reply to Updating one Excel Table ...

Take a look at the VLOOKUP function

Collapse -

Updating one Excel Table from another.

by chitosunday In reply to Updating one Excel Table ...

You can use the "edit" then "find" to match one data to another and then copy and paste it. To automate it, you can use macro for this. It you like you can send me your file and i will prepare a macro for you based on the existing column used.

Collapse -

Updating one Excel Table from another.

by Nikky In reply to Updating one Excel Table ...

open the file on the current page and double click on the file for text edit

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Forums