Forum Discussion
varible in link to another file or generating formula from a formula?
pc/office 10 excel version 2404 likely over my head again, but ... I need to generated formula in cells on worksheet to look at cells on other sheets. I need to be able to paste list of part...
JackShield Thanks for the file. Not sure what you want to achieve though. The 'formula' you refer to references another workbook (another xlsm file). Without that one, there's much I can do. Perhaps someone else.
i need to generate link to another file in b2, c2, etc.
the file name varies by the the text listed in a2, a3, etc.
the cells framed in red let me stitch the file name together, but would like the link to appear in b2, c2, etc. automatically, without the need to copy and paste.
im a novice user tasked with the job ....
the file name varies by the the text listed in a2, a3, etc.
the cells framed in red let me stitch the file name together, but would like the link to appear in b2, c2, etc. automatically, without the need to copy and paste.
im a novice user tasked with the job ....
