Hi all, I have a macro which takes live data every second from Range P5 to P60 and pastes it into cells AA105 to AA160 - it then shifts the data already in AA105 to AA160 into AB104 to AB160 thus shifting everything to the right as per the code below
What I want to do in rows 205: 260 is calculate the difference between AB105:AB160 and AA105:AB160 as that moves along.
Something like
Range("AA205:AA260").Value = Range("AB105:AB160").Value - Range("AA105:AA160").Value
Only the code above is not correct and I would like to know the correct way to do this. I hope I have explained it well enough
Bookmarks