Automatic Update in Microsoft Excel 2003

By goutham4mail ·
Hi ,
i want to know how to update one xls file automatically after saving another xls file.
It mean both the files are having some same colums.
So, i want to find the matching column and it should get updated automatically.

Thanks in advance...

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

You can write a macro to do it......

by ThumbsUp2 In reply to Automatic Update in Micro ...

A Macro (VBScript) can be written to update one spreadsheet/workbook based on input in another. Of course, it's not really automatic. You would have to update the one spreadsheet/workbook, then execute the macro which would update the other spreadsheet/workbook.

Related Discussions

Related Forums