Excel at Excel....!!!!!(Ask anything and everything)

Page no : 8

RAKESH (Almost CA) (2199 Points)
Replied 07 November 2008

hi wat is the use of vlook up and macros

Upgrade to CAclubindia Pro. Subscribe Now!

Khaleel A G (Senior Manager) (146 Points)
Replied 16 November 2009

Originally posted by :RAKESH
"	hi khaleel i would like to ask about the data validation . suppose i want to make a statemnt of the assessment year 1993-94 the i am not able to have that assessment year and previous year data validation . so please do help	"

Sorry i did not quite understood your querry,

Data validation is for verifying if the the data entered in a cell is of the required criteria.

eg: in a cell given for writing name, if someone types a number by mistake, then data validation will not accept it, prompting the user to correctly enter the data.

please elaborate your issue.

regards,

khaleel

Khaleel A G (Senior Manager) (146 Points)
Replied 16 November 2009

Dear friends,

I request all of you again to go through some basic excel book and then ask questions.

vlookup, pivot tables, VBA , macros, etc are vast subjects, it will simply force me to copy entire chapters from the books and paste here, which will not serve your purpose.

For you convenience i have uploaded a book on this site named :"Excel for beginners - Important Basics".

God Bless.

Khaleel