Hi, I have a workbook that is meant to track travel costs across various departments. it has 11 department spreadsheets and one summary sheet. My issue is finding either a macro or function that will transfer the individual travel cost entries on the various sheets, to a single cost cell on the summary sheet and keep it as a running total for each dept sheet.
Can anyone help??
Can anyone help??