Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
new user needs help
Hi,
I have a stocklist (sheet 2) with 4 columns: A= LOT # B=DESCRIPTION C=BIDDER # D=PRICE, and an invoice (sheet 1) with column A=LOT # containing this formula: IF(A16="","",VLOOKUP(A16,STOCKLIST!$A$2:$B$501,2.0 )) so the description comes up automatically in the invoice. Now what i want to do is have an invoice generated automatically when I enter the bidder number and price paid into their respective columns, with bidder no.5 generating an invoice numbered 1005. Row 1 has the invoice no, row 2 has the bidder no. Is this possible? Thank you -- Regards, Sarah |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
new user needs help
Actually, upon further consideration, what I need is a formula that will
enter the information from column A (LOT #), B (DESCRIPTION) from STOCKLIST to INVOICE when I enter the BIDDER # (COLUMN C) and the PRICE (COLUMN D). It's for an auction, and one bidder may purchase serveral lots. I also need the invoice to save as I enter the above information into the stocklist. I will manually set up invoices as each person registers, giving them a bidder number, and entering their personal details into an invoice. -- Regards, Sarah "Sarah" wrote: Hi, I have a stocklist (sheet 2) with 4 columns: A= LOT # B=DESCRIPTION C=BIDDER # D=PRICE, and an invoice (sheet 1) with column A=LOT # containing this formula: IF(A16="","",VLOOKUP(A16,STOCKLIST!$A$2:$B$501,2.0 )) so the description comes up automatically in the invoice. Now what i want to do is have an invoice generated automatically when I enter the bidder number and price paid into their respective columns, with bidder no.5 generating an invoice numbered 1005. Row 1 has the invoice no, row 2 has the bidder no. Is this possible? Thank you -- Regards, Sarah |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
new user needs help
Hi Sarah
Advanced Filter, extracting the relevant rows to your invoice sheet will achieve this. Take a look at Debra Dalgleish's site for more information. http://www.contextures.com/xladvfilter01.html#ExtractWs There is a downloadable file that you could modify. http://www.contextures.com/excelfiles.html#Filter -- Regards Roger Govier "Sarah" wrote in message ... Actually, upon further consideration, what I need is a formula that will enter the information from column A (LOT #), B (DESCRIPTION) from STOCKLIST to INVOICE when I enter the BIDDER # (COLUMN C) and the PRICE (COLUMN D). It's for an auction, and one bidder may purchase serveral lots. I also need the invoice to save as I enter the above information into the stocklist. I will manually set up invoices as each person registers, giving them a bidder number, and entering their personal details into an invoice. -- Regards, Sarah "Sarah" wrote: Hi, I have a stocklist (sheet 2) with 4 columns: A= LOT # B=DESCRIPTION C=BIDDER # D=PRICE, and an invoice (sheet 1) with column A=LOT # containing this formula: IF(A16="","",VLOOKUP(A16,STOCKLIST!$A$2:$B$501,2.0 )) so the description comes up automatically in the invoice. Now what i want to do is have an invoice generated automatically when I enter the bidder number and price paid into their respective columns, with bidder no.5 generating an invoice numbered 1005. Row 1 has the invoice no, row 2 has the bidder no. Is this possible? Thank you -- Regards, Sarah |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
new user needs help
Hi Roger,
Thanks for you response, I can't get it to work for me though....Perhaps I'm missing something out? Or doing something wrong, most likely.... Or maybe I didn't explain my problem very well. What I need to have happen is: when I enter a bidder number into column C in sheet 2, named STOCKLIST (next to the lot number, column A, and the matching description, column B), and the price the bidder paid for the lot into column D, I want the information from columns A,B & D to be entered into that bidder's invoice (they may buy lot number 8 -row 12-and lot number 246-row 248), and I want the invoice to be saved with that information. Is this possible with Advanced Filters? -- Regards, Sarah "Roger Govier" wrote: Hi Sarah Advanced Filter, extracting the relevant rows to your invoice sheet will achieve this. Take a look at Debra Dalgleish's site for more information. http://www.contextures.com/xladvfilter01.html#ExtractWs There is a downloadable file that you could modify. http://www.contextures.com/excelfiles.html#Filter -- Regards Roger Govier "Sarah" wrote in message ... Actually, upon further consideration, what I need is a formula that will enter the information from column A (LOT #), B (DESCRIPTION) from STOCKLIST to INVOICE when I enter the BIDDER # (COLUMN C) and the PRICE (COLUMN D). It's for an auction, and one bidder may purchase serveral lots. I also need the invoice to save as I enter the above information into the stocklist. I will manually set up invoices as each person registers, giving them a bidder number, and entering their personal details into an invoice. -- Regards, Sarah "Sarah" wrote: Hi, I have a stocklist (sheet 2) with 4 columns: A= LOT # B=DESCRIPTION C=BIDDER # D=PRICE, and an invoice (sheet 1) with column A=LOT # containing this formula: IF(A16="","",VLOOKUP(A16,STOCKLIST!$A$2:$B$501,2.0 )) so the description comes up automatically in the invoice. Now what i want to do is have an invoice generated automatically when I enter the bidder number and price paid into their respective columns, with bidder no.5 generating an invoice numbered 1005. Row 1 has the invoice no, row 2 has the bidder no. Is this possible? Thank you -- Regards, Sarah |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
new user needs help
Hi Sarah
Yes, advanced Filter can extract data in that way. You must start the filter from the Destination sheet. --Regards Roger Govier "Sarah" wrote in message ... Hi Roger, Thanks for you response, I can't get it to work for me though....Perhaps I'm missing something out? Or doing something wrong, most likely.... Or maybe I didn't explain my problem very well. What I need to have happen is: when I enter a bidder number into column C in sheet 2, named STOCKLIST (next to the lot number, column A, and the matching description, column B), and the price the bidder paid for the lot into column D, I want the information from columns A,B & D to be entered into that bidder's invoice (they may buy lot number 8 -row 12-and lot number 246-row 248), and I want the invoice to be saved with that information. Is this possible with Advanced Filters? -- Regards, Sarah "Roger Govier" wrote: Hi Sarah Advanced Filter, extracting the relevant rows to your invoice sheet will achieve this. Take a look at Debra Dalgleish's site for more information. http://www.contextures.com/xladvfilter01.html#ExtractWs There is a downloadable file that you could modify. http://www.contextures.com/excelfiles.html#Filter -- Regards Roger Govier "Sarah" wrote in message ... Actually, upon further consideration, what I need is a formula that will enter the information from column A (LOT #), B (DESCRIPTION) from STOCKLIST to INVOICE when I enter the BIDDER # (COLUMN C) and the PRICE (COLUMN D). It's for an auction, and one bidder may purchase serveral lots. I also need the invoice to save as I enter the above information into the stocklist. I will manually set up invoices as each person registers, giving them a bidder number, and entering their personal details into an invoice. -- Regards, Sarah "Sarah" wrote: Hi, I have a stocklist (sheet 2) with 4 columns: A= LOT # B=DESCRIPTION C=BIDDER # D=PRICE, and an invoice (sheet 1) with column A=LOT # containing this formula: IF(A16="","",VLOOKUP(A16,STOCKLIST!$A$2:$B$501,2.0 )) so the description comes up automatically in the invoice. Now what i want to do is have an invoice generated automatically when I enter the bidder number and price paid into their respective columns, with bidder no.5 generating an invoice numbered 1005. Row 1 has the invoice no, row 2 has the bidder no. Is this possible? Thank you -- Regards, Sarah |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
new user needs help
Hello again Roger,
I really do appreciate your help, however I seem to be having a great deal of difficulty in following the instructions.....I just can't make it work. -- Regards, Sarah "Roger Govier" wrote: Hi Sarah Yes, advanced Filter can extract data in that way. You must start the filter from the Destination sheet. --Regards Roger Govier "Sarah" wrote in message ... Hi Roger, Thanks for you response, I can't get it to work for me though....Perhaps I'm missing something out? Or doing something wrong, most likely.... Or maybe I didn't explain my problem very well. What I need to have happen is: when I enter a bidder number into column C in sheet 2, named STOCKLIST (next to the lot number, column A, and the matching description, column B), and the price the bidder paid for the lot into column D, I want the information from columns A,B & D to be entered into that bidder's invoice (they may buy lot number 8 -row 12-and lot number 246-row 248), and I want the invoice to be saved with that information. Is this possible with Advanced Filters? -- Regards, Sarah "Roger Govier" wrote: Hi Sarah Advanced Filter, extracting the relevant rows to your invoice sheet will achieve this. Take a look at Debra Dalgleish's site for more information. http://www.contextures.com/xladvfilter01.html#ExtractWs There is a downloadable file that you could modify. http://www.contextures.com/excelfiles.html#Filter -- Regards Roger Govier "Sarah" wrote in message ... Actually, upon further consideration, what I need is a formula that will enter the information from column A (LOT #), B (DESCRIPTION) from STOCKLIST to INVOICE when I enter the BIDDER # (COLUMN C) and the PRICE (COLUMN D). It's for an auction, and one bidder may purchase serveral lots. I also need the invoice to save as I enter the above information into the stocklist. I will manually set up invoices as each person registers, giving them a bidder number, and entering their personal details into an invoice. -- Regards, Sarah "Sarah" wrote: Hi, I have a stocklist (sheet 2) with 4 columns: A= LOT # B=DESCRIPTION C=BIDDER # D=PRICE, and an invoice (sheet 1) with column A=LOT # containing this formula: IF(A16="","",VLOOKUP(A16,STOCKLIST!$A$2:$B$501,2.0 )) so the description comes up automatically in the invoice. Now what i want to do is have an invoice generated automatically when I enter the bidder number and price paid into their respective columns, with bidder no.5 generating an invoice numbered 1005. Row 1 has the invoice no, row 2 has the bidder no. Is this possible? Thank you -- Regards, Sarah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
new user | New Users to Excel | |||
For a User | Excel Discussion (Misc queries) | |||
new user | Excel Discussion (Misc queries) |