Hello,
I need to change one specific cell with another cell. I mean YTD for January should be same as January Beginning balances $100
Hi, @kauser
@kauser - can you please provide a bit more detail here. Not quite sure what you are trying to accomplish. Top row doesnt add up, but the bottom two do. then if you look at the columns the first three add up but not the last two.
A little more explanation around what we are looking at would go a long way.
Thanks
Maybe this is your want :
Thanks for sharing but can you please share the workflow because its confusion without the workflow. i am not sure how did you get YTD back into summarize tool because i saw you dont have ytd on transpose tool.
@DanielG
sorry for confusion. i am typing to link January beginning balance into January YTD cell. means January YTD balances will be same as January beginning balances. hope this will answer your question.
@kauser just a quick question. Typically January beginning balance would not equal the January YTD balance unless there is no activity for January. Did you mean ending balance?
@flying008
Thank you so much for your help.
@jdminton
Agree but they wany an exception on January YTD cell
