drop down lists to populate an order form

**john dalton** · 04-02-2010, 04:45 AM

hi all,

I am trying to use two drop down lists in an attempt to populate an order form -

the drop down boxes are called

SUPPLIER - this contains all the names of the suppliers I use

STOCK DESIGNATION - this contains two phrases CONSIGNMENT STOCK and BOUGHT STOCK

I want to be able to select a supplier and a stock designation and then for all matching items in the data sheet to auto fill an order form -

Example

in supplier i select PLUMB CENTER and in stock designation i select CONSIGNMENT

the fields in the order form are headed ITEM DESCRIPTION, STOCK CODE and RE-ORDER QTY - i would need all the instances where PLUMB CENTER and correspondes with CONSIGNMENT STOCK to then fill the 25 or so lines of the order form automatically

please help - desperate to get this working

**ratcat** · 04-02-2010, 05:08 AM

G'day John,

(It will be best for me if you) Upload a dummy worksheet with a before and after result as you are asking a number of steps.

Plus here is some info on Excel Data Validation -- Create Dependent Lists

Cheers

RC

**john dalton** · 04-02-2010, 05:30 AM

how do i upload to you

**ratcat** · 04-02-2010, 05:59 AM

Must add 10 characters or more to just post the quote on its own.

Originally Posted by Excel Help Forum FAQ

How do I attach a file to a post?

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'. To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments. You can upload an attachment either from your computer or from another URL by using the appropriate box on this page. Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file. To upload a file from another URL, enter the full URL for the file in the second box on this page. Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.

**john dalton** · 04-02-2010, 06:19 AM

here is an attachment for you to have a look at i have only included the tab stock order data to try and give you a better idea of how i need the order form to work - the tab ORDER SHEET is one of two front header sheets I will be using to run the stock control the other is the stock movement sheet - any queries please ask

**john dalton** · 04-02-2010, 06:21 AM

just a quick note - the data in the tab RUNNING STOCK is the preferred feeder data for the stock order sheet

**martindwilson** · 04-02-2010, 06:24 AM

nope no attachment

**john dalton** · 04-02-2010, 08:03 AM

cheers martin

**martindwilson** · 04-02-2010, 09:40 AM

ok this is how i'd approach with functions it see notes on data sheet
i t would probably be easier to use auto filter then copy paste which could be done with vba
ps edit your post to remove that email address before you get badly spammed

**john dalton** · 04-02-2010, 10:30 AM

thats brilliant - would this work for stock levels then so when I selected the supplier and the stock designation it would automatically select only the stock relating to the criteria that was due for reorder via a re-order level in the running stock sheet?

hope thats sounds right lol

genius mate

**martindwilson** · 04-02-2010, 10:46 AM

probably... as long as you can make an unique key then you can match anything but youd probably have to have an extra column that says true/false for each item then you could unique key all the trues in the same way 1-true 2-true and so on

**john dalton** · 04-02-2010, 11:03 AM

is it possible to thave the consignment and the bought stock listed as one set of data in the feeder sheet instead of two sheets saying CONSIGNMENT STOCK and BOUGHT STOCK - the reason i am asking is that my stock data sheet is listed as one whole list of information and there is no way I can split it - it works brilliantly I just need to be able to tweek it a bit to suit my format -

next question - is there a way of having a button on the order sheet to run a macro that would automatically place all ordered items into the running stock sheet

cheers JD

**martindwilson** · 04-02-2010, 11:49 AM

you can do that but a slightly different approach is needed(i did it all on one sheet for clarity)
as for the macro id suggest you start that as a new thread in the programming sub forum
and as i said before you could use code to do the whole thing without functions

**martindwilson** · 04-02-2010, 12:18 PM

oops wrong thread

drop down lists to populate an order form

LinkBack

Thread Tools

Rate This Thread

Display

drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Re: drop down lists to populate an order form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions