Hi
In a sheet i have a formula in Cell A11 where it adds from Cell A1 to A10.
In Cell A12 i need to have a formula where it can just paste the values of the Cell A11 Automatic.
Is it possible.
Hi
In a sheet i have a formula in Cell A11 where it adds from Cell A1 to A10.
In Cell A12 i need to have a formula where it can just paste the values of the Cell A11 Automatic.
Is it possible.
Use Paste Special / Values
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I need a formula to do so because this values to to be linked with same sheet and it goes as cell reference.
So any formula which can directly just give the cell falues whenever it changes
All formulas give a value
Sounds like a job for VBA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks