Forum Discussion
Save Previous Cell Value Of A Changed Cell In Excel
Maksim7570 I'm sorry, you did say you have Excel 2019. see attached:
I created formulas for 30 columns to see up to 30 days but you could fill right for more if needed.
That said, in previous post you said you wanted another value to the right of those cells and you said for example the data is in A:K and you would have something in L but that would have to be in AF or so to have up to 30 columns available for the data. Or incorporate that cell information as an alternative formula/data in the formula I created based on it being X columns more than then total requested...
mtarler
Your decision with the button looks great, but I have one problem)
My Excel doesn't recognize these formulas and maybe there are other decisions? other function or macro?
Maksim7570 I'm sorry, you did say you have Excel 2019. see attached:
I created formulas for 30 columns to see up to 30 days but you could fill right for more if needed.
That said, in previous post you said you wanted another value to the right of those cells and you said for example the data is in A:K and you would have something in L but that would have to be in AF or so to have up to 30 columns available for the data. Or incorporate that cell information as an alternative formula/data in the formula I created based on it being X columns more than then total requested...
- it works very good.Earlier I thought my problems could solve only macros, but you used one macro, You are the best man!)
- You are the genius! I'm so excited! You solved my problems and did my work life better Thank you very much!