Discussion Locked

Updating one Excel Table from another.

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

3 replies

by chitosunday

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.

by nikky

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

This discussion is closed to new replies.