Copy value from changing cells without VBA

D

dghelardi

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
 
D

dguillett

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
Click to expand...

http://www.rondebruin.nl/win/s9/win015.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting and copy or copy and formatting ?? 2
VBA code for pasting links -- modifying RDB code for summary workbook 10
Copy/Paste_Value problem. 5
Copy sum of two columns from one workbook to one column in another 1
Copy range based on input 1
Copy, Paste and Print Cells from a Named Range 3
How to copy a range of cells from one sheet to another 4
VBA Copy Range of cells with a condition to another worksheet 3

Top