I need to make alot of links from one spreadsheet to a bunch of spreadsheets. I know that I can easily copy data from one spread sheet to another by copy and pasting ranges of cells. But! how can I easily create links between sheets. I also know that I can create individual links by =<click on cell to be linked to> <enter>, but this is tedius and time consuming.
I'm considering making a vba script that sets the formula of the cells to the cells to be linked to, but this is not working.
How can I set links from one large set of cells to another set of cells from a different file?
I'm considering making a vba script that sets the formula of the cells to the cells to be linked to, but this is not working.
How can I set links from one large set of cells to another set of cells from a different file?