Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert dynamic formula
Hello -
I hope somebody can help with this ... find/replacing manually is taking forever ... What I'd like to do is copy and modify links, using data in column A to modify. Here are the steps: 1) copy a range of cells (E6:I371) 2) paste this into cell E372 (so immediately below the copied range) 3) replace STORE_A in link with STORE_B (which is the value in ColumnA) 4) repeat steps #1-3 for the next store Cells E6:I371 are already linked to an external file ... I just want to duplicate the links, but to a different store's file, for each of the other 27 stores that I have. Ideas? Thanks ,ray |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert dynamic formula
This might be better with a macro to get the info desired or use dynamic
links in the destination workbook that refer to the source workbooks. -- Don Guillett SalesAid Software "Ray" wrote in message oups.com... Hello - I hope somebody can help with this ... find/replacing manually is taking forever ... What I'd like to do is copy and modify links, using data in column A to modify. Here are the steps: 1) copy a range of cells (E6:I371) 2) paste this into cell E372 (so immediately below the copied range) 3) replace STORE_A in link with STORE_B (which is the value in ColumnA) 4) repeat steps #1-3 for the next store Cells E6:I371 are already linked to an external file ... I just want to duplicate the links, but to a different store's file, for each of the other 27 stores that I have. Ideas? Thanks ,ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic column insert (macro) | Excel Discussion (Misc queries) | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Excel Programming | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel |