Thread: Copy value from changing cells without VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dguillett@gmail.com is offline
external usenet poster
  
Posts: 27
Default Copy value from changing cells without VBA
On Thursday, September 4, 2014 1:43:08 AM UTC-5, wrote:
I have an excel workbook that continuously reads values from external application via DDE and stores then to a range of cells.

Those values are continuously changing.

When those values are "satisfactory", I need to save a frozen copy into target ranges without using VBA since, by policy, it is denied.

I can use copy-paste values, but it is time consuming since I have to repeat many times.

Is there a formula to put in target ranges that can read from the "source" range and can freeze the value on command?



TIA,

David

http://www.rondebruin.nl/win/s9/win015.htm
Reply With QuoteReply With Quote