Event Question

B

bwilcox

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?
 
T

Tom Ogilvy

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
 
Top