how to copy cell ranges from vlookup results

[hillfingerr]

I am doing a vlookup in workbook x, sheet1 and then I filter out the #N/A lines from column B.

From the resulting lines I want to copy the column A values (without header) to workbook y, sheet 4, column B and from column AK to workbook y, sheet 5, column F with a CLEAN function.

Your help with this will be appreciated.

 

[udprocks]

hi hillfinger,

Welcome to the forum

can you please upload a sample file with expected result... it will help tohelping you fast.

 

[hillfingerr]

here is how the resulting excel should look.

thanks,
G

 

[udprocks]

again in this, not clear your requirments.

 

[hillfingerr]

I just want to copy cells from one workbook to another, taking into account that the source cells will always have different rows (being vlookup results).

 

[udprocks]

Then In your workbook where it's showing.... which u want from another sheet.

 

[hillfingerr]

I believe you require the source workbook x? I have attached this also now.