Hi members,
I have 4 workbooks and each workbook has tab1 with data from A2 to V48 ,and some formula’s from cell K2 to V48.
I want to copy and paste all workbook in ons to consolidated as one but i want to copy formulas without cell reference from the other 4 workbooks.
Format is the same A2 to v48?
Thanks
I have 4 workbooks and each workbook has tab1 with data from A2 to V48 ,and some formula’s from cell K2 to V48.
I want to copy and paste all workbook in ons to consolidated as one but i want to copy formulas without cell reference from the other 4 workbooks.
Format is the same A2 to v48?
Thanks