Import Paystub Data to My Expenses and Income Spreadsheet

Hello,

Every two weeks I can download my paystub in Excel. Over the years I have been manually importing my pay and deductions into another Excel spreadsheet of my income and expenses. Now that I feel more comfortable with Excel, I'm turning to the Forum for the easiest way to automate this. I would prefer a non-macro solution but I'm open to trying a macro if it is simple enough. I'm guessing I will need to use 'Match' and 'Index' function for the date but I just need a little help to push me in the right direction.

1. Based on the 'Check Date' of the paystub, I would like certain cells to be auto-populated in the Income/Expenses OR summed first and then auto-populated in the Income/Expenses in the row corresponding to that same date.

2. This is just a made up example of a paystub and actual Income/Expenses spreadsheet. Not all columns are together or will necessarily be in this same order.


Thanks in advance.