Copy Non Contiguous Cells from multiple workbooks into one sheet - Problem with blanks

Hello,
I am looking to make a master table in a master sheet that pulls non contiguous cells from each worksheet. The code works fine if there are always values in the cells I am looking to copy to a master worksheet. However, if one of the worksheets is missing a value in a cell I select, the same cell from the next worksheet is placed where a blank should be in that row. (To try to put it bluntly: row 2 b2 should be blank, since ProcessName on the first sheet is blank, but the value from row3 b3 (ProcessName on the next sheet) has moved into b2.) I'm hoping someone can modify my code to help me account for blanks.

Thanks

Please Login or Register  to view this content.

Hi, Kahmed2R,

instead of looking the last used cell up for each column look it up only for one column which is filled at any time and use that variable for the other columns as well:

Please Login or Register  to view this content.

Ciao,
Holger