I am doing a financial analysis spreadsheet and need help please with a formula!
I have my total figures in column B. I have done a Data Validation list in column C and I then have my analysis columns D, E, F, G, H, and I.
My question is once i select from the data validation list. Is there a formula that will copy the total figure from column B into the correct analysis column?
Many Thanks!
Bookmarks