Software

Ask something
Question Locked

Automatic Update in Microsoft Excel 2003

0 helpful
2 replies

by goutham4mail

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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...

2 replies

by thumbsup2

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.

This discussion is closed to new replies.