Master Shipping Schedule Drawing From Separate Files

[Nebu]

Change Dim c, j As Long to Dim c, j, i As Long The macro closes all the PM files after retrieving data that is taken care off.....

 

[Matthew Berg]

So that worked; it pulled from 'PM1' and closed it, but did not pull anything from PM2 through PM6. Is it possible it's only looking to 'N1' and not the 'N' column?

 

[Nebu]

Did you create separate xl files with the names PM1,PM2 and so on and saved in the same path as Master file?

 

[Matthew Berg]

Yes.

 

[Nebu]

Hi:

The macro is fixed , it will work for all 3 PM files now , if you want to add more PM files add it in column N of Master tab and save the files in the same folder as Master Tab....

 

[Matthew Berg]

This is incredible, and I hate to have to write this but the 'Sort' macro causes Excel to freeze, but I can always just sort manually. I'm getting error messages when I try to save it too. I did add more PM files (up to 6) and it did run the macro perfectly, and without opening each file which is incredible. But as I said I get error messages when I try to save it. I've attached some screen shots though I'm not certain they will be of help....

 

[Nebu]

Hi:

I guess your file is corrupted, please try to repair it or copy the macro to a different file...

 

[Matthew Berg]

Okay, I think I've repaired it. I've attached it, and it seems to work like a charm.

Is it possible to move the 'N' column to the 'PM' tab? When I print the 'MASTER' tab, I'm trying to avoid printing a page that just has the 'N' column in it.

Again, many thanks

 

[Nebu]

Hi:

the easiest way is to change the colour of the font white...

 

[Nebu]

However, I have fixed it but I would assume that you would still get the PM file names as a second page in your PDF file , since your code for converting the xl file into pdf will convert all the sheets into pdf .....