using a formula to copy a row

  • Thread starter Thread starter RB
  • Start date Start date
R

RB

I don't know if this can be done, but I would like Excel to be create an
order form. I have a list of, say 300 items and in one instance need to order
only 3 items from that list of 300. I've chosen the quantities I require of
those 3 items, however I only want to display the items I need to order,
maybe on a seperate sheet within the same workbook.
 
You don't give any detail about your data, so I can only give you a
general comment - use VLOOKUP to do this. You should have a unique
code for each of your 300 items and you enter this code in your order
sheet. VLOOKUP can retrieve the other data associated with that code,
such as description, unit price, quantity in stock etc. You can find
more details in Excel Help.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference Formula Help 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Formula Help 2
calculating values where it depends on the value of a previous cel 2
Manipulating Order Quantities with a Formula 2
Deleting blank rows with formulas in them 7
Help again 1
Conditional Formatting 5

Back
Top