Hi Guys,
First of al,l I would like to thank you for all your help in the past.
My issue is, I need to copy cells from another workbook, the only problem is that it needs to be a sequence of adding 7 cells each time.
eg.
formula in cell A1 on linked to workbook =IF('[Short Audit Form.xlsx]Call Audit Form'!F262=0,"",'[Short Audit Form.xlsx]Call Audit Form'!F262)
formula in cell A2 on linked to workbook =IF('[Short Audit Form.xlsx]Call Audit Form'!F269=0,"",'[Short Audit Form.xlsx]Call Audit Form'!F269)
formula in cell A3 on linked to workbook =IF('[Short Audit Form.xlsx]Call Audit Form'!F276=0,"",'[Short Audit Form.xlsx]Call Audit Form'!F276)
As you can see the value for 2nd wookbook is from '[Short Audit Form.xlsx]Call Audit Form' (1st Wookbook)
I have been doing this but manually & changing numbers after copy pasting, but there will be 90 cells in 7 columns so it taks a long time.
I need to do a new one each month.
I hope this can be done as a 'Flash Fill' for example.
Thank you in advance,
Gary
Im
First of al,l I would like to thank you for all your help in the past.
My issue is, I need to copy cells from another workbook, the only problem is that it needs to be a sequence of adding 7 cells each time.
eg.
formula in cell A1 on linked to workbook =IF('[Short Audit Form.xlsx]Call Audit Form'!F262=0,"",'[Short Audit Form.xlsx]Call Audit Form'!F262)
formula in cell A2 on linked to workbook =IF('[Short Audit Form.xlsx]Call Audit Form'!F269=0,"",'[Short Audit Form.xlsx]Call Audit Form'!F269)
formula in cell A3 on linked to workbook =IF('[Short Audit Form.xlsx]Call Audit Form'!F276=0,"",'[Short Audit Form.xlsx]Call Audit Form'!F276)
As you can see the value for 2nd wookbook is from '[Short Audit Form.xlsx]Call Audit Form' (1st Wookbook)
I have been doing this but manually & changing numbers after copy pasting, but there will be 90 cells in 7 columns so it taks a long time.
I need to do a new one each month.
I hope this can be done as a 'Flash Fill' for example.
Thank you in advance,
Gary
Im