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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SetLinkOnData only fires once? 0
How to sync OL365 contacts and calendar to iPhone without iTunes? 1
event that cannot be disabled? 6
Stop SetLinkOnData 0
New computer, how do i move outlook 365 ENTIRELY? 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
External cell reference between two excel worksheets both in One Drive 0
Create timeline with event being hyperlinks to documents on drive 1

Top