Hi all, thanks for being there to help out. I am looking to have a workbook that automatically updates itself from the same cell in another workbook.
I.E. Workbook 1 has a few worksheets, 1 of which is called orders.
I would like to enter the info into a different workbook (workbook 2), with 1 worksheet called orders, so that when it is entered into workbook 2, into cell b5, it should automatically update (or at least when opened) in Workbook 1, worksheet "orders", into cell b5.
If no data in workbook 2, workbook 1 should be blank.
(If it is relevant: I want to do this because I enter some info from a mobile device, and workbook 1 has formulas that get changed when the file is opened on the mobile device. This way I can make a simple input workbook (2) for orders, and then it will get pulled into workbook 1 where the formulas can all go to work etc. I will set it up so that each cell should be the same in both workbooks. ).
Thanks so much for any help!
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar