[ExcelVBA] Worksheet update Automatically from same cell in another workbook

  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...

READ MORE....

[belajar-excel] Digest Number 1711

Milis Belajar Microsoft Excel Group 15 New Messages Digest #1711 1a mencocokan data by "MIKE" 1b Re: mencocokan data by ...

READ MORE....