How can I create a link button in bookwork

[fabianor]

I have a master work book that feed information to my master template with all my information being linked by 3 daily reports that I run.

How can I create a button to link my three closed worksheets to my open workbook without having to open all four workbooks.

Masterbook POS ZCSI 2067500 RegAlanly.xlt

Workbook 1 cupolosreganaly.xls

Workbook 2 Sales Tax.xls

Workbook 3 Department Sales.xls

 

[SkipVought]

Hi,

How are they linked?

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[fabianor]

Skip

They are all linked to the master workbook template by special paste links.

Thanks

 

[SkipVought]

The all you need to do is Update Links, right?

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[fabianor]

Yes I just need then to update the links in the master template workbook from the closed 3 other worksheets or workbooks.

I know can do it by using edit > link > update source but I need to make it simple for other people to use with less computer ablities.

Since the 3 linked report are Created by Crystal Reports and the exported to 3 excel worksheets.

Just need to make it easier for them to click on something that will do the linking with no thought involved.

 

[SkipVought]

Turn on your macro recorder and have at it.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}