Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm relatively new to the excel macro writing and so I was wondering if you guys could help me. I want to create a dynamic link to a cell in another closed workbook. I need the information in the master workbook to change as the user changes the values in certain cells. For example, lets say the value in cell A1 is 11 and the value in cell A2 is 22. I need A3 to link to cell C6 in the file 11-22.xls. If I were to change the value in A1 to be 33 and the value in A2 to be 44 then I need A3 to link to cell C6 in the file 33-44.xls. Please include detailed code to complete this task since I am so new to writing macros. Any help is greatly appreciated. Thank you.

share|improve this question
add comment

1 Answer

You will need to write a macro that opens the 'master' spreadsheet, changes it, saves is and closes it again.

To get started, check out these MSDN entries:

Warning: If you want more than one user or file accessing the master at a time you'll run into problems.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.