alphabo1201
New Member
- Joined
- May 2, 2019
- Messages
- 16
Hello Excel gurus.
I have a range of formula from A3 through Z3.
I want to copy that row and paste formula to A4 through Z4 as formula first and convert that to value after.
Then reselect A3 through Z3 and paste formula to A5 through Z5 as formula first and convert to value.
I would like this to continue copy paste formula then values until row count N column.
so the main source of formula will stay as formula and rest of the data will be values.
Could someone be kind enough to find the answer?
Thank you
I have a range of formula from A3 through Z3.
I want to copy that row and paste formula to A4 through Z4 as formula first and convert that to value after.
Then reselect A3 through Z3 and paste formula to A5 through Z5 as formula first and convert to value.
I would like this to continue copy paste formula then values until row count N column.
so the main source of formula will stay as formula and rest of the data will be values.
Could someone be kind enough to find the answer?
Thank you