Update data function across 2 workbooks

  • Thread starter Thread starter provis
  • Start date Start date
P

provis

My question is, is it possible for data to be ported over 2 workbook
just by clicking on the data on the first one via external links?

For example, I have 2 workbooks - -catalogue.xls- and -order.xls-. Wha
i want is for my customers to be able to look at the items available i
-catalogue.xls-, and when they see an item that they want to order, al
they have to do is to click on it, and the data in that highlighted ro
will be ported over to -order.xls-.

Is such a thing even possible? If it is, how shoud I go abou
constructing such a spreadsheet? What values shoudl I define, etc etc?

thank you so very much
 
Provis

The only way this could be done by simply clicking is using code in a
Worksheet_Change() event. This is possible, but with lots of inexperienced
users would need tons of error checking to make it robust.

You may want to use an index, such as 'enter a sequential number against
your order' (1,2,3,4,5). You could then pick these up in your order form
using a VLOOKUP function. (This is the simplest)

My last suggestion would be to get the customers to mark the catalogue
somehow, maybe you could automate a click putting a 'X' in a cell next to
their selection, you could then use a 'complete order' button to move the
data to an order form.

Just a few ideas to get you thinking

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Thanks nick, for the speedy reply.

I'll do some research on the suggestions you gave, but I'm especiall
intrigued by your last suggestion.
My last suggestion would be to get the customers to mark the catalogu
somehow, maybe you could automate a click putting a 'X' in the cel
next to their seletion, you could then use a 'complete order' button t
move the data to an order form.
Click to expand...

How is this possible to achieve on Excel? is there a tutorial that
can read up on? cos very likely we may adopt this because it will b
most user-friendly for our customers.

thank you
 
Back
Top