Solved Copy Values to a specific cell

June 6, 2013 at 18:07:44
Specs: Windows 7
I have an expense report in Excel, from the Extended totals column (G) for each expense I want to insert a column (H) that has an assignment Letter (A through E). The Next 5 Columns (I - M) are marked A through E as they relate to the different cost centers. How do I create a formula that lets me quickly code each line in Column G (My totals per line) by just inserting the letter A or B or C or D or E into the corresponding line in Column H and that total automatically copies over to the correct Column

See More: Copy Values to a specific cell

Report •

June 6, 2013 at 18:49:17
✔ Best Answer
In I1:M1 enter your Cost Center letters A - E

Assuming your first Extended Total is in G2, enter this formula in I2 (adjust as required)


Drag this over to M2 and then drag I2:M2 down as far as you need.

The key is to ensure you use the dollar signs exactly as shown.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

June 6, 2013 at 22:17:00
Thank you very much, that worked 100%!!!

Thanks again!

Report •

Related Solutions

Ask Question