How can be done when I write to one workbook and at the same time update another one (workbook on other locations) and lets say when cell F is changed to save automaticly both workbooks
is this possible
thnx for your answers
How can be done when I write to one workbook and at the same time update another one (workbook on other locations) and lets say when cell F is changed to save automaticly both workbooks
is this possible
thnx for your answers
Re: write in one and update another
What is the purpose of this? What does the other workbook hold exactly? Can you have both workbooks open at the same time?
Re: write in one and update another
In other workbook is exactly the same data as in first one actually it is just a clone of first workbook except it is stored in another location and it would be nice if just first one would be open not both
and then I write into first workbook and other is updated automaticly and saved when last cells (reference) is entered with data and so on for each row
thnx for your help
Re: write in one and update another
If it is a clone of the first workbook, then whenever you close the first workbook, have the workbook save, and then save as the second workbook, creating a copy of what has just been saved.
Re: write in one and update another
Is ther any event like on save or on sheet change(but this would take to much time) or maybe on close
The best would be if when workbook is closed it is automaticly saved and also save the clone or when workbook is saved then save the clone also
this would be the best method Do you maybe know how would this be done
thnx
Re: write in one and update another
Well done. There is also the Workbook_BeforeClose event, which you may want to consider if your processing becomes too slow.
Don’t have an account yet? Register yourself now and be a part of our community!