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.
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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Automatic Update in Microsoft Excel 2003
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...