code to work out from 2 workbooks

[Patriot2879]

Hi i hope you can help, i have 2 workbooks (Book13 and Book14) these both have the same data, for example in cell C12 is the number 13 in both workbooks, but if someone reduces this number to 11 in either of the workbooks i want the other workbook to automatically update the cell to 11, i dont want to mirrow the workbook as i want them both live. please can you help with the code?

 

[gallen]

Strange, it worked for me. Do you get any errors? Delete this line:

[COLOR=#333333]wb.close[/COLOR]

this will keep the workbook that was closed open. It will let you check 1) if it opens at all 2) It sends the changes over

 

[Patriot2879]

Hi i removed the wb.close it now works great thanks.
Is there anyway to stop the closed book opening?

 

[gallen]

No. You can't write to it without it opening.

You can hide it but that causes issues.

It's strange however that not closing it has fixed it which means that the save didn't work. Like I said it works for me

 

[Patriot2879]

i got it to work now thank you, for some reason the save bit didnt work so i added some code at the bottom to save the range selected this has worked

thanks for your help, can i also share the sheet and have more than one person have it open? will it still update?

 

[gallen]

If the workbook being auto updated is being closed every time then yes it COULD work but the open workbook with more than one user can only have one that is allowed to edit (and save).

 

[Patriot2879]

ok thank you and thanks again for your help.