Hello,
I'm using Excel 2021 Home edition.
I want to automate the process where entering a transaction row on my checkbook sheet dynamically populates a row on the corresponding category sheet, but in a different order.
For instance, on my checkbook sheet, I input:
Date
Payee
Choose "utility" from a dropdown list
Amount
Then, on my utility sheet, I'd like a row to automatically appear as:
Payee
Date
Amount
I'm open to using VBA code, but I'm not familiar with writing or editing it. Is there an Excel formula or function that can accomplish this task?
I'm using Excel 2021 Home edition.
I want to automate the process where entering a transaction row on my checkbook sheet dynamically populates a row on the corresponding category sheet, but in a different order.
For instance, on my checkbook sheet, I input:
Date
Payee
Choose "utility" from a dropdown list
Amount
Then, on my utility sheet, I'd like a row to automatically appear as:
Payee
Date
Amount
I'm open to using VBA code, but I'm not familiar with writing or editing it. Is there an Excel formula or function that can accomplish this task?