Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Linking Entire Worksheet

I have an Excel workbook named Master that has a worksheet named Price List.
I also have an Excel workbook named Updated that is stored on our webserver.
This workbook is an exact copy of Master. Finally, I have an Excel workbook
named Client Copy that is e-mailed to clients. This is also an exacty copy
of Master.

What we need to do is set up links so we can update the Price List worksheet
in Master, it in turn updates Updated on the server and then the Client Copy
is updated from the workbook stored on a server.

Right now we have links for each individual cell in each workbook, and it
seems to be working fine. My question is - is there an easier way to just
link everything on the entire worksheet so when one is updated (whether it is
changing a cell or inserting or deleting a row) the others automatially
update as well - kind of like a copy and paste but one that is automatic?

I hope I explained that well enough. Thanks in advance to anyone who has
suggestions!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 - Linking Formulas, Worksheet to Worksheet windsong Excel Discussion (Misc queries) 4 November 15th 05 03:10 PM
Linking Entire Worksheets Mr Mike Excel Worksheet Functions 0 July 20th 05 07:20 PM
Linking to an Entire Sheet Chaplain Doug Links and Linking in Excel 2 December 24th 04 07:39 AM
Linking an entire worksheet from a restricted drive? mkichar Excel Worksheet Functions 1 November 4th 04 06:29 PM
Linking an entire worksheet from a restricted drive? mkichar Excel Worksheet Functions 0 November 4th 04 02:59 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"