BUTTON LINKING AND GRABING INFO

D

DARRELL

Here is what I have. I have a work book with one sheet in it called IQS_2.xls that I fill in information, and save as a different file name each time.I have made a button with a macro that opens another sheet that grabs the information and enters it into the designated cells, I call this one EMQS.xls. My problem is when I save the IQS_2 files as a name, the EMQS file does not stay linked to the newly renamed file. So I want to push the button in the renamed IQS_2 file and open the EMQS file and automaticly enter the information. Can this be done? I am new to excel and have very limited knowledge, so the more detail you can give would be great

Thanks,
Darrel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Button help 0
Making a button to open a work book 2
Getting Radio Buttons to work, that are inserted via AutoText 0
Excel Saving Issues 1
Link To File That No Longer Exists 1
Lookup functions always return n/a ??? 3
Linking data in MS Word into Excel 5
Links do not recognize .xlsm extension 1

Top