Hi Chandu,
The way you structured the Excel information on your web site is very impressive. Actually I was referred by on of my friend from Visakhapatnam. Nice to know your work on Excel. It's a one place for all Excel related problems.
Well.. I am also coming to you with a problem that is bugging me from a long time. Lets say I have 2 sheets.
Sheet 2 has all my dates and their description. Lets say in Sheet 2 Column A data is , from A1 to A10 is all date fields ( dates ranging from Jan 2011 to Dec 2011) and their description in Column B.
In Sheet 1 on Cell A1 ( or any other cell ) if I input a date field , the logic should check the dates in Sheet2 ( from Sheet2!A1 all the way to A10 ) and if it is in one of those dates I want to get it's asoociated description here in Sheet 1.
I looked at the Arrays and their implementation, but could not able to come at a solution. Any help in resolving this may be highly appreciated. If you feel that this is something it takes reasonable amount of your time please ignore my request.
The way you structured the Excel information on your web site is very impressive. Actually I was referred by on of my friend from Visakhapatnam. Nice to know your work on Excel. It's a one place for all Excel related problems.
Well.. I am also coming to you with a problem that is bugging me from a long time. Lets say I have 2 sheets.
Sheet 2 has all my dates and their description. Lets say in Sheet 2 Column A data is , from A1 to A10 is all date fields ( dates ranging from Jan 2011 to Dec 2011) and their description in Column B.
In Sheet 1 on Cell A1 ( or any other cell ) if I input a date field , the logic should check the dates in Sheet2 ( from Sheet2!A1 all the way to A10 ) and if it is in one of those dates I want to get it's asoociated description here in Sheet 1.
I looked at the Arrays and their implementation, but could not able to come at a solution. Any help in resolving this may be highly appreciated. If you feel that this is something it takes reasonable amount of your time please ignore my request.