Dear Excel Gurus.
I`m trying to copy 3 sheets from one excel worksbook to another where there are the same 3 sheets with the same formula links and connections.
The document have huge macro in the background and i`m improving from time to time. (i`m not good in coding. real beginner....)
My question is how to move the 3 sheets from one workbook to another while keeping the formulas/links.
If i copy it creates sheet_name(2)
if i copy content i need to go and break the link. Still not good. (really basic users are using the file and i whant to create automation for them)
Can it be done programatically ?
Hope my explanation is not too messy
Thanks