shifting data down a row?==SOLVED thanks TsTom

[mcleve]

Hi,

Maybe you can help me out with excel. Im using a dde topic to fill cell A1 with a number, 155 for instance. I need to send this value to cell B1 "155". When cell A1 changes "105" i need the new value to go to cell B1"105". And the old B1 value to go to B2 "155". When cell A1 changes again "215" I want the new value to go to Cell B1 "215" and the old B1 data to go to B2 the old B2 data to go to B3 "155" and so on. Any idea how I can accomplish this?

A1 215 B1 215
B2 105
B3 155

Each time A1 changes I need all the data in column B to shift down and insert the new data from A1 on top, leaving the oldest data at the bottom of the column and the newest data at the top.

I could even put the first data in b1 the next in b2 then b3 and so on but the data has to come from A1 and move this data automatically.

Thank you so much for your help,
Marty Clevenger
This message was edited by mcleve on 2002-05-19 19:26

 

[mcleve]

Thank you so much for all your help. This board is filled With extreme intelligence. A very good resource!

I have reviewed my problem and have one more question.

If cell A1 has a Dynamic Data Exchange entry of either 1 or 0. Is it possible that if A1=1 then put a timestamp of when the cell A1 went to 1 in B1 and the word "started" in cell c1. when cell A1 goes to 0 then put a timestamp of when A1 went to 0 in B2 then the word "stopped" in cell C2 and so on.

I am trying to log uptime and downtime of a peice of equipment. What time the machine stopped and what time it started back 1=on 0=off.

I hope that I am not being too much of a Nuisance. and Thank you all again for all your help!!!
Marty Clevenger

 

[Legacy 98055]

There is some code I pasted in your duplicate post...
Tom

 

[brian5857]

I have some code I know would do just what you want. I need to dig it up. let me know if you are still monitoring this forum and you still need it.