Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to retrive the exact figures
hi every body ; the problem i have is very important for me to get the
solution and i do hope that u all of my friend will help basically we sell the products that contain the serial numbers and all of our business is running on that particular serial number suppose i have keep the record of each product serial number that i sell and i will keep the record of the unsold serial number as well.let me give the example the item i purchased and then some of them sold so what stock will be in my hand then for example : purchases item Quanity Serial Start Serial End Cobra 40 56710093200 567100093239 let's suppose if i sell the serial number item quantity serial start serial End Cobra 10 56710093220 567100093229 now i want to know which serial is left in stock with me regards gul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to retrive the exact figures
"Naveed Pathan" je napisao u poruci
interesnoj ... each product serial number that i sell and i will keep the record of the unsold serial number as well.let me give the example the item i purchased and don't know how large is your stock, but basicly, you may use excel sheet, filling one row for *each* separate serial number, having three columns: 1-item identifier 2-serial number 3-sold yes/no like: cobra 40001 no cobra 40002 no cobra 40003 yes cobra 40004 no now, using data-filter, you may show just "unsold" setting column filters, item=cobra and sold=no of course, you may have other columns as well, like date-in, date-sold, etc .... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to retrive the exact figures
I agree with Sali. I think you need to have a list of all serial numbers,
not start and end serial numbers. When the item is sold you can change the cell in Column 5 to "SOLD". Then you can use a filter to view all "SOLD" items. You can even use Conditional Formatting for easy identification of "SOLD" items. Use conditional formatting to highlight all rows red if Column 5 = "SOLD". Hope this helps! If so, click "YES" below. -- Cheers, Ryan "Naveed Pathan" wrote: hi every body ; the problem i have is very important for me to get the solution and i do hope that u all of my friend will help basically we sell the products that contain the serial numbers and all of our business is running on that particular serial number suppose i have keep the record of each product serial number that i sell and i will keep the record of the unsold serial number as well.let me give the example the item i purchased and then some of them sold so what stock will be in my hand then for example : purchases item Quanity Serial Start Serial End Cobra 40 56710093200 567100093239 let's suppose if i sell the serial number item quantity serial start serial End Cobra 10 56710093220 567100093229 now i want to know which serial is left in stock with me regards gul |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to retrive the exact figures
Setup your spreadsheet like this:
Item Serial Number Status Cobra 56710093200 SOLD Cobra 56710093201 Rattler 56710093202 SOLD Rattler 56710093203 Garden 56710093204 SOLD Garden 56710093205 Use conditional formatting for Column C (Status) top hightlight the row or cell. Or just filter all items that are SOLD. -- Cheers, Ryan "Ryan H" wrote: I agree with Sali. I think you need to have a list of all serial numbers, not start and end serial numbers. When the item is sold you can change the cell in Column 5 to "SOLD". Then you can use a filter to view all "SOLD" items. You can even use Conditional Formatting for easy identification of "SOLD" items. Use conditional formatting to highlight all rows red if Column 5 = "SOLD". Hope this helps! If so, click "YES" below. -- Cheers, Ryan "Naveed Pathan" wrote: hi every body ; the problem i have is very important for me to get the solution and i do hope that u all of my friend will help basically we sell the products that contain the serial numbers and all of our business is running on that particular serial number suppose i have keep the record of each product serial number that i sell and i will keep the record of the unsold serial number as well.let me give the example the item i purchased and then some of them sold so what stock will be in my hand then for example : purchases item Quanity Serial Start Serial End Cobra 40 56710093200 567100093239 let's suppose if i sell the serial number item quantity serial start serial End Cobra 10 56710093220 567100093229 now i want to know which serial is left in stock with me regards gul |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to retrive the exact figures
that;s ok but on the daily basis i sell more than 4000 items
so is it easy? "Ryan H" wrote: Setup your spreadsheet like this: Item Serial Number Status Cobra 56710093200 SOLD Cobra 56710093201 Rattler 56710093202 SOLD Rattler 56710093203 Garden 56710093204 SOLD Garden 56710093205 Use conditional formatting for Column C (Status) top hightlight the row or cell. Or just filter all items that are SOLD. -- Cheers, Ryan "Ryan H" wrote: I agree with Sali. I think you need to have a list of all serial numbers, not start and end serial numbers. When the item is sold you can change the cell in Column 5 to "SOLD". Then you can use a filter to view all "SOLD" items. You can even use Conditional Formatting for easy identification of "SOLD" items. Use conditional formatting to highlight all rows red if Column 5 = "SOLD". Hope this helps! If so, click "YES" below. -- Cheers, Ryan "Naveed Pathan" wrote: hi every body ; the problem i have is very important for me to get the solution and i do hope that u all of my friend will help basically we sell the products that contain the serial numbers and all of our business is running on that particular serial number suppose i have keep the record of each product serial number that i sell and i will keep the record of the unsold serial number as well.let me give the example the item i purchased and then some of them sold so what stock will be in my hand then for example : purchases item Quanity Serial Start Serial End Cobra 40 56710093200 567100093239 let's suppose if i sell the serial number item quantity serial start serial End Cobra 10 56710093220 567100093229 now i want to know which serial is left in stock with me regards gul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
retrive data | Excel Discussion (Misc queries) | |||
Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
Look for and Retrive Data | Excel Worksheet Functions | |||
add figures to existing figures in excel | Excel Worksheet Functions | |||
Changing positive figures to minus figures | Excel Worksheet Functions |