extracting a part of a cell

[daveyc18]

so pretty much every day...there will be an adjustment to, say, cell A1 in a file I open

cell A1 would have =random numbers +adjustment

where the adjustment number which will change daily

I then take the adjustment number and offset in cell A2 by typying

=random numbers - adjustment


(the random numbers are originally hardcoded numbers in both cells)

probably a long shot, but any way to automate this??

 

[daveyc18]

yes my mistake ..thanks

 

[Joe4]

You are welcome.
Glad we got it all sorted out now, and you have a working solution.

 

[daveyc18]

You are welcome.
Glad we got it all sorted out now, and you have a working solution.

yes, thanks again...indeed excel mvp lol