LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Prevent previous entered data from updating

File One.xls contains cells that pull information (i.e. a percentage of some
number) from Two.xls. I want to be able to update information (the
percentage) in Two.xls, then go back into One.xls and have the previous
information stay the same (using the old percentage) and have any new data
use the updated percentage.

Any ideas?
 
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
Data Range updating automatically as new data is entered mgnrke28 Charts and Charting in Excel 1 July 10th 08 02:02 PM
Prevent duplicate data from being entered into the same column Char Excel Worksheet Functions 3 August 29th 07 03:28 PM
How do I prevent data from being entered into a particular cell? Bryan Excel Discussion (Misc queries) 1 April 7th 07 01:24 AM
how to prevent Excel from reformatting a chart wen updating data? Cmd_Marco Charts and Charting in Excel 3 February 10th 06 02:47 PM
Data in column predetermined by what has been entered in previous zan123 Excel Discussion (Misc queries) 6 February 23rd 05 08:03 PM


All times are GMT +1. The time now is 06:24 AM.

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"