Hello,
I am new to VBA and am trying to set up a workbook that logs expenses and that does that following: a.) automatically copies data from the Summary Tab to the appropriate Details Tab based on data in one column and b.) on each Details Tab, automatically calculate the sum of data in one column as new entries are added from the Summary Tab.
End users want to enter data on the Summary Tab only so that they can view all of the entries at once, and sort or filter as needed. As a new row of data is added to the Summary Tab, I would like Excel to copy the row, based on the Account number, to the appropriate Account Tab. In addition, I would like to automatically calculate the total sum on each Account and have it update automatically as new data is entered onto the Summary Tab.
I’ve attached a sample data set and how I would like the final outcome to look on each tab.
Any advice is greatly appreciated and please let me know if additional info is needed to clarify my request. Or if a more efficient solution is more appropriate, please advise also.
Bookmarks