Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. * |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
want to copy formula, only change one number in formula | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Copy formula so destination displays formula as text | Excel Discussion (Misc queries) |