Need help creating a macro

Closed
Report
Posts
1
Registration date
Wednesday August 8, 2012
Status
Member
Last seen
August 8, 2012
-
Posts
12
Registration date
Wednesday August 8, 2012
Status
Contributor
Last seen
October 12, 2012
-
Hello,

So here's what I have....

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.

Thanks for any tips you can give me!

K

1 reply

Posts
12
Registration date
Wednesday August 8, 2012
Status
Contributor
Last seen
October 12, 2012

KLyLa:

I believe a sample file would be needed in order to help you with this. So, if you're able to give us a sample file with fake information in it, we should be able to help you out.

Good luck,
Josh