Pulling client info from various spreadsheets for each month

[mardo]

Hi Guys,

I have monthly reports of sales by client number. I am now trying to pull the annual sales info by month for one client by name. Eg. each month, XYZ ltd has sales figures for various products. Is there a way of me grabbing all his sales info for the year with out having to open each spreadsheet

Thanks

[k64]

Yes. You can write a macro with the form

Please Login or Register  to view this content.

[mardo]

Thanks for your help. I am attaching much smaller versions of my files for the months of Jan to May. I want to pull all the info for Steve in one spreadsheet by month and by client number and company # which is the first column as we have various company codes

Can you do the coding based on the files I have sent you.

[k64]

Here you go. I made two versions. 1 adds all the data to the same sheet, with the headers still there so you can tell where the break is. The other adds the data to separate sheets. Note that if possible, you should change your naming convention to either always abbreviate or always use the full month name. It will make everything easier in the future if you need to change this code. For the time being, I had to make the code check for both cases.

Please Login or Register  to view this content.