I have attached a workbook file with three worksheets. I am trying to find a way so that when I enter a row on either the Supplies worksheet or the Travel worksheet, it will automatically copy columns A-E to the next blank line on the M&O worksheet. and keep a running total. I don't want to paste the entire row so that the formula on the Total worksheet can keep a running balance. There will be other worksheets in the workbook, but these are the only two that I want to combine onto the Total worksheet. Can someone help me with this?
The file is attached.
Thanks.
Bookmarks