![]() |
#1
|
|||
|
|||
![]()
Hey all,
Im always amazed at the ability of humans to find solutions for problems and their ability to improve everything. Im looking for something like that here too. I am a complete beginner when it comes to excel but it fascinates me with the things it can achieve. currently i am working for a company that among other things sells food and stuff with an expiry date. So far the way the company handles this is by having an excel sheet with the list of the products and a possible expiry date that i have to manually search per product. every month i get a new list that i have to check over again from scratch. I wanted to make it a bit more interactive and progress a bit things by changing the sheet slightly... ok maybe not slightly... ill go Frankenstein on it. Ok so heres what im thinking: Ill have one excel page that includes column 1: product number (easy to search the product by that in store) column 2: product name and description column 3: number of days close to current day (using the TODAY() function Column 4-10 possible expiery dates (yes some products have maaaany expiery dates like Coka~Cola can have 3+ different per month) After I complete the expiry dates on the columns 4+ i would like to create a space on another page, if possible, that shows all the dates that are 20 days or closer to today. (or at least the 20 closest expiery dates from the columns 4-10 of the first page) Think thats possible? Also any ideas of how to make it better are welcome ![]() Thank you for taking the time to read through! ![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jackie | Excel Programming | 13 | 05-24-2015 02:36 PM |
![]() |
splinter09 | Excel | 3 | 12-10-2014 06:09 AM |
Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
How to fetch data from one sheet to another with complete details and date wise as well | harisjawed86 | Excel Programming | 1 | 08-05-2014 09:10 PM |
Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |