I'm trying to take data from my check register sheet and put it in my Year to date sheet. What I need excel to do is look in the category column list for "Business Lunch in my check register and if it find it, then look at the date column for the date of the transaction and then place the amount from the withdraw column into my Year to Date sheet.
Can anyone help me on this issue? I am using excel 2011 on my MacBook.
Can anyone help me on this issue? I am using excel 2011 on my MacBook.