ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Controlling Linked Data to Workbooks (https://www.excelbanter.com/excel-worksheet-functions/6528-controlling-linked-data-workbooks.html)

Myrna

Controlling Linked Data to Workbooks
 
Hi,
Using Excell 2000.
Workbook 1 = Employees Name changes
This workbook links to many other workbooks.
How can I control the name changes & other data to only change in workbooks
beyond the date I entered them.
Example:
book 1=
Employees Names/////Federal tax%////StateTax%
Joe .05 .01
Mark .06 .02
Bob
If I change Mark in workbook 1, how do you formulate the value to change
only to the assigned linked data for that month and every workbook after
that. I do not want the data to change for the previous months on my
worksheets.
I notice when I change Mark all the sheets change. Just want to change on
the date I enter the changed data.
Or when I change the % to Federal tax. I don't want all the sheets to
change. I will have a false reading..

Thank you


All times are GMT +1. The time now is 08:40 PM.

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