I have a project that requires a large macro that is beyond my capabilities. I provided an attachment of what I am looking to accomplish with the macros. "Input" is where a person would enter the "B1" name on a check or cash receipt; "B2" check # and then "B5" is all of the options that a person can fill in the dollar amount of the giving per item. "G26" is where any miscellaneous items not already listed would be inputted and their $$ amount. "A28" is the macro "enter" button which would push the data to "master" and then wipe "input" clear for the next check or cash receipt. On "Master" you can see how I have mocked a few items like "jane" gave to multiple items that were on "input" as well as building supplies which was an add-in on "other". On "Master" I only want to see those items that have been used, otherwise I could create a macro that can pull to each and every item on a pre-generated list. That is where I am drawing a blank on where to even start.
Bookmarks