Hi bazza36
Could you let us know how the data is organised in the "Orders" worksheet in
Workbook 1?
What columns/rows do you want copied and where in Workbook 2 do you want
them?
Is there a column which would be filled in on the last row used in
worksheet "Orders"
What are the names of the files (including extensions)
What is the name of the destination sheet in Workbook 2 ?
What version of Excel are you using?
Are the two workbooks always going to be in the same directory?
Best Regards
David Grugeon
Excel VBA Group Moderator
-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of bazza36
Sent: Wednesday, 1 August 2012 3:10 PM
To: ExcelVBA@yahoogroups.com
Subject: [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 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
----------------------------------Yahoo! Groups Links
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