7+ files with multiple contracts created in excel. Each contract contains many different fields of information - address, phone, name, etc.... There are also multiple cells which contain information IF the billing is applicable for a certain month....in other words, August may have a billing amount, but not September.
What I need....
A macro (or possibly code) that I can navigate to any one of the files and then will transfer the business name, address, and billing amount (IF billing is applicable for the month I choose) from each individual contract and place them in a spreadsheet for easy viewing.
I'll need a way of changing the chosen month and year in the resulting spreadsheet so that it will pull the correct billing amount.
I've recorded lots of macros, but have never tried my hand at code. I've tried recording, but it will only transfer the one document I copy and no others....I'm obviously missing something.