Hi. I'm creating a spreadsheet to track my self-employed business expenses. I suspect I need VBA to do what I need to do, but I've not used it before. Here's the setup:
Sheet 1 is where I track my checking account activity (both expenditures and credits to my account). Columns as follows:
A: Date of transaction
B: Description
C: Amount debited
D: Amount credited
E: Running balance
(F: skipped column)
G: A dropdown menu where I indicate what kind of business expense an item was, if any (e.g. office supplies, insurance, transportation, etc., as categorized on IRS tax form Schedule C)
Sheet 2 is set up to be a business expense statement for my taxes. Columns as follows:
A: Date of transaction
B: Description
C and onward: each column matches one of the expense categories in the dropdown menu on Sheet 1
What I'd like it to do is: whenever I enter an expense on Sheet 1 and choose a business expense category in the dropdown, I'd like the date, description, and expense amount to be automatically populated into Sheet 2, with the expense amount appearing in the correct column for its category. I don't care if those rows on Sheet 1 and Sheet 2 are forever linked; I'm just after one-time population of data, so that I don't have to re-enter every business expense by hand. How do I program that?
I really appreciate the help! If I get this figured out I'll be glad to share the .xlsx template with the group.
Bookmarks