Hello,
I have a workbook for our teams budget that has 1 master sheet with 28 columns. The master sheet will be updated with more rows often (adding new budget items). I would like to use a macro button so that every time a certain person (one who makes a decision for one column) updates that sheet she can click the button. What I need the macro to do is copy all of the rows that have "Pre-Pay" in the "Payment Source" column and paste them into different sheets based on what vendor is listed in another column.
I have attached an image of what the main sheet looks like since I can't figure out how to attach a file.
I'm very new to marcos so I would love if you could help create the code for me. Happy to send the file if you can tell me how.
Best,
Danielle