Do empty cells affect my linking process since my data is the same in both workbooks the only difference is that the one workbook (WB1) is with empty cells and the other (WB2) is without empty cells. The link should go into the workbook (WB1)that has empty cells. If I copy down in WB1 it puts the link also in the empty cells which i don't want and doing the link individually takes too much time if data is large. I need a simple way (may people work on this file) for the link not to go to empty cells.
Can somebody please help?
