N
Neil
Hi there, i have been asked to get involved in a mini project at my work -
and im just thinking of robust/dynamic solutions.......
Basicaly, we have an order form, which is emailable - and contains maybe a
hundred products or so - this goes to 50 different locations/units, within
the one company - e.g. - a hotel chain.
As it is the now, there is one master sheet - (control), and 50 other sheets
for each location - the products on each location sheet are siply linked to
the control sheet- so that if they change description/name/price - it is
reflected in the "child linked" sheet(s).
To me, this way seems like along way for a shortcut - and not very
robust.....
I have seen one which my mothers company use for stationery orders - but it
is protected, and so cant view how it is done, but is very clever.
Basicaly, there is a menu (drop down) - with each employers name (in my
case, each hptel name it would be) - and when they select their name, it
filters the current sheet - to only show, the products, in which they are
authorised to order........
what im want to do, is hava a control sheet - with all the products, and
beside every product, a tick box, or the like, for each location that i
allowed to order this product.
If ticked, this product appears in their filtered list (when they select
their hotel/location name), and obviously if unticked, it doesnt appear in
their list.
Then, if one location is allowed to rder a product, it is simply matter of
going into the control sheet and ticking the box, for their location, for
that product.
Also - my mothers sheet, has a button, that when pressed - it automaticaly
emails the sheet to somewhere and grabs the local email address of the
machine (i know this, cause i tested iut form my work, which is
unnassociated with my mums work- and i got an emai lback saying i had sent a
blank order !! )
Is this a really complex project, or is it fairly straight forward once used
to it.
Many Many thanks for your time,
Neil
and im just thinking of robust/dynamic solutions.......
Basicaly, we have an order form, which is emailable - and contains maybe a
hundred products or so - this goes to 50 different locations/units, within
the one company - e.g. - a hotel chain.
As it is the now, there is one master sheet - (control), and 50 other sheets
for each location - the products on each location sheet are siply linked to
the control sheet- so that if they change description/name/price - it is
reflected in the "child linked" sheet(s).
To me, this way seems like along way for a shortcut - and not very
robust.....
I have seen one which my mothers company use for stationery orders - but it
is protected, and so cant view how it is done, but is very clever.
Basicaly, there is a menu (drop down) - with each employers name (in my
case, each hptel name it would be) - and when they select their name, it
filters the current sheet - to only show, the products, in which they are
authorised to order........
what im want to do, is hava a control sheet - with all the products, and
beside every product, a tick box, or the like, for each location that i
allowed to order this product.
If ticked, this product appears in their filtered list (when they select
their hotel/location name), and obviously if unticked, it doesnt appear in
their list.
Then, if one location is allowed to rder a product, it is simply matter of
going into the control sheet and ticking the box, for their location, for
that product.
Also - my mothers sheet, has a button, that when pressed - it automaticaly
emails the sheet to somewhere and grabs the local email address of the
machine (i know this, cause i tested iut form my work, which is
unnassociated with my mums work- and i got an emai lback saying i had sent a
blank order !! )
Is this a really complex project, or is it fairly straight forward once used
to it.
Many Many thanks for your time,
Neil