LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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
 
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
Changing Cells depending on data entered in other cells [email protected] Excel Programming 1 October 20th 11 10:57 PM
Copy changing group of cells from Sheet1 to Sheet2 Brad Excel Programming 3 July 23rd 09 01:09 PM
Adjustable Cells (Changing Cells) Limit - Solver Marcio Excel Discussion (Misc queries) 0 April 7th 08 04:41 PM
Copy formula into multiple cells without changing range frankjh19701 Excel Worksheet Functions 4 December 28th 06 03:45 PM
Show cells with formulas without permanently changing the cells DoctorG Excel Programming 10 July 19th 06 12:43 PM


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

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

About Us

"It's about Microsoft Excel"