using a formula to copy a row
 

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.

using a formula to copy a row
 

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

On Aug 19, 1:16*am, RB wrote:
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. *

using a formula to copy a row
 

Appreciate the help, thank you. I'll give it a shot.

"Pete_UK" wrote:

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

On Aug 19, 1:16 am, RB wrote:
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.

using a formula to copy a row
 

You're welcome. Post back if you have any problems (but give some more
details).

Pete

On Aug 19, 6:35*pm, RB wrote:
Appreciate the help, thank you. *I'll give it a shot.



"Pete_UK" wrote:
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

On Aug 19, 1:16 am, RB wrote:
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. *- Hide quoted text -

- Show quoted text -

using a formula to copy a row
 

I'm starting to get the idea of Vlookup. Here is, I hope, more clear info on
more help I need.
For example:
Sheet 1 (Quantity to order, part # and description) pretend there are 300
items listed on this sheet
QTY Part# Description
1 123 ABC
223 BBC (QTY left blank because there is no need to
order the item)
3 333 BBB
4 444 CCC
555 DDD (QTY left blank because there is no need to
order the item)


Sheet 2 would be the sheet to send in for items that need to be ordered, ie.
items that have a value less than 0 would not be listed.

QTY Part# Description
1 123 ABC
3 333 BBB
4 444 CCC

Does this explain better?

"Pete_UK" wrote:

You're welcome. Post back if you have any problems (but give some more
details).

Pete

On Aug 19, 6:35 pm, RB wrote:
Appreciate the help, thank you. I'll give it a shot.



"Pete_UK" wrote:
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

On Aug 19, 1:16 am, RB wrote:
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. - Hide quoted text -

- Show quoted text -

using a formula to copy a row
 

Well, the easiest way to do this would be to apply autofilter to the
QTY column in Sheet1, and select Non-blank from the filter pull-down.
You can then copy all the visible data, including the header row into
Sheet2 and you will then have your list. Next time all you will need
to do is select All from the filter pull-down, highlight the QTY
column and delete the contents, and then start again putting
quantities against each item and then apply the filter again.

Hope this helps.

Pete

On Aug 19, 7:35*pm, RB wrote:
I'm starting to get the idea of Vlookup. *Here is, I hope, more clear info on
more help I need.
For example:
Sheet 1 (Quantity to order, part # and description) pretend there are 300
items listed on this sheet
QTY * * *Part# * * *Description
1 * * * * * 123 * * * *ABC
* * * * * * *223 * * * *BBC (QTY left blank because there is no need to
order the item)
3 * * * * * 333 * * * *BBB
4 * * * * * 444 * * * *CCC
* * * * * * *555 * * * *DDD (QTY left blank because there is no need to
order the item)

Sheet 2 would be the sheet to send in for items that need to be ordered, ie.
items that have a value less than 0 would not be listed.

QTY * * *Part# * * *Description
1 * * * * * 123 * * * *ABC
3 * * * * * 333 * * * *BBB
4 * * * * * 444 * * * *CCC

Does this explain better?



"Pete_UK" wrote:
You're welcome. Post back if you have any problems (but give some more
details).

Pete

On Aug 19, 6:35 pm, RB wrote:
Appreciate the help, thank you. *I'll give it a shot.

"Pete_UK" wrote:
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

On Aug 19, 1:16 am, RB wrote:
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. *- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

using a formula to copy a row
 

Sweet, thanks.

"Pete_UK" wrote:

Well, the easiest way to do this would be to apply autofilter to the
QTY column in Sheet1, and select Non-blank from the filter pull-down.
You can then copy all the visible data, including the header row into
Sheet2 and you will then have your list. Next time all you will need
to do is select All from the filter pull-down, highlight the QTY
column and delete the contents, and then start again putting
quantities against each item and then apply the filter again.

Hope this helps.

Pete

On Aug 19, 7:35 pm, RB wrote:
I'm starting to get the idea of Vlookup. Here is, I hope, more clear info on
more help I need.
For example:
Sheet 1 (Quantity to order, part # and description) pretend there are 300
items listed on this sheet
QTY Part# Description
1 123 ABC
223 BBC (QTY left blank because there is no need to
order the item)
3 333 BBB
4 444 CCC
555 DDD (QTY left blank because there is no need to
order the item)

Sheet 2 would be the sheet to send in for items that need to be ordered, ie.
items that have a value less than 0 would not be listed.

QTY Part# Description
1 123 ABC
3 333 BBB
4 444 CCC

Does this explain better?



"Pete_UK" wrote:
You're welcome. Post back if you have any problems (but give some more
details).

Pete

On Aug 19, 6:35 pm, RB wrote:
Appreciate the help, thank you. I'll give it a shot.

"Pete_UK" wrote:
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

On Aug 19, 1:16 am, RB wrote:
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. - Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

using a formula to copy a row
 

You're welcome.

Pete

On Aug 20, 1:48*am, RB wrote:
Sweet, thanks.



"Pete_UK" wrote:
Well, the easiest way to do this would be to apply autofilter to the
QTY column in Sheet1, and select Non-blank from the filter pull-down.
You can then copy all the visible data, including the header row into
Sheet2 and you will then have your list. Next time all you will need
to do is select All from the filter pull-down, highlight the QTY
column and delete the contents, and then start again putting
quantities against each item and then apply the filter again.

Hope this helps.

Pete