Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Link-to-cell copy problem
I have a spreadsheet that I work up quotes on. Using the control toolbox I
have created drop down lists to select certain items for calculations on the quote. On many occasions I need to work up various "options" to any given quote. I have created a Macro that will perform a copy/paste of all the cells and formulas beneath the last row of the original set of formulas, giving me a second set to work up an option on, and it displays the total results in one area of all the options for comparison. Problem 1. When copying I have to manually put the spreadsheet in "design" mode before running my macro or it will not copy the control boxes. Problem 2. While all the formulas copy perfectly, the control boxes retain the original "Linked Cell" reference. I have to edit each one individually to the new cell. I've tried to record a macro but it won't work as it fails to recognize when I go into design mode. I am more interested in a solution to problem 2. I can live with having to manually put the spreadsheet in design mode but if there is a solution I'd love to hear it. Thanks in advance, -Squeaky |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
copy combobox - cell link to change automatically | Excel Worksheet Functions | |||
On click, copy text into another cell - XL2K | Excel Worksheet Functions |