ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Event Question (https://www.excelbanter.com/excel-programming/272204-event-question.html)

bwilcox

Event Question
 
What Event or other such process will automatically update
a 2nd spreadsheet when the first sheet has been updated
via an external link set up through the SetLinkOnData
method?

Tom Ogilvy

Event Question
 
You could have the macro specified in the setlinkondata do the updating or
you could simply have a formula on the second sheet refer to the cell on the
first sheet.

=Sheet1!A1

Regards,
Tom Ogilvy


"bwilcox" wrote in message
...
What Event or other such process will automatically update
a 2nd spreadsheet when the first sheet has been updated
via an external link set up through the SetLinkOnData
method?





All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com