Dear Sir
i want to add specific number to date with refer to product name
example in worksheet name ( sheet1 there is column B which contain product name and in the same worksheet there is coulmn J which contain
manufacturing date then i would like to calculate expir date automatic
by adding shelf life time for each product which i put this data in worksheet name ( Refer) in column
N ( product name ) and O ( shelf life time)
how can make this
thanks for all
If you intended to upload a sample workbook, I think you forgot to add it. If you did not intend that, I suggest you do
Sounds like you just need to use VLOOKUP() to ID the product and shelf life, then simply add that to the date?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
here attached file
I *think* this is what you need...
=DATE(YEAR(I2)+VLOOKUP($A2,Refer!$N$2:$O$14,2,0),MONTH(I2),DAY(I2))
If not, please explain what your answer should be, and how you get that
Dear FDibbins
thanks for your help
its work good now
i would like to know how can automatic create new excel file when some data enter in specific cell
for example
when i enter some data in cell L2 they will automatic create file with name (this name consist from cell B2 and G2 (product name and batch No.)
regards
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks