M mkowski Jan 22, 2005 #1 How do I not see the 0's when I past a link to another workbook and the column is empty from the original. Thank you Mickie
How do I not see the 0's when I past a link to another workbook and the column is empty from the original. Thank you Mickie
G Guest Jan 22, 2005 #2 Hi there, Instead of using the Paste Link option you could use a formula. Say for example you wanted information from Sheet1 to appear in sheet 2 In cell A1 in sheet 2 you could eneter in cell A1, =if(sheet1!A1="","",Sheet1!a1) Hope that helps Naz, London
Hi there, Instead of using the Paste Link option you could use a formula. Say for example you wanted information from Sheet1 to appear in sheet 2 In cell A1 in sheet 2 you could eneter in cell A1, =if(sheet1!A1="","",Sheet1!a1) Hope that helps Naz, London
M mkowski Jan 25, 2005 #3 Works like a charm! :-] Mickie Hi there, Instead of using the Paste Link option you could use a formula. Say for example you wanted information from Sheet1 to appear in sheet 2 In cell A1 in sheet 2 you could eneter in cell A1, =if(sheet1!A1="","",Sheet1!a1) Hope that helps Naz, London Click to expand...
Works like a charm! :-] Mickie Hi there, Instead of using the Paste Link option you could use a formula. Say for example you wanted information from Sheet1 to appear in sheet 2 In cell A1 in sheet 2 you could eneter in cell A1, =if(sheet1!A1="","",Sheet1!a1) Hope that helps Naz, London Click to expand...
