Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

About Macro

chandra shekara m (student) (64 Points)

08 July 2008

Dear all Friends

If you have any nots about MACRO, V-LOOK UP & H-LOOK UP Please send to this mail id

chandu @ scottsgarments.com

Reply
Follow
Share

5 Replies

pramodjalandra (Account Administrator) (142 Points)
Replied 10 July 2008

rollno	name	age	phone
1	raja	45	4562
2	sanju	23	4558
3	rajesh	4	5623
4	kailash	5	1224
5	krupesh	12	4251
6	pramod	78	452

Vlook up formula Apply here:-

Above data is first coloumn is rollo no. , second is Student name, third is Age and last is Phone no.

Vlook Up Apply here


Roll No.	2
Name	sanju
Age	23
Phone	4558

in the cell where type is Sanju =VLOOKUP(E14,A2:D7,2)

in the cell where type is Age =VLOOKUP(E14,A2:D7,3)

in the cell where type is Phone =VLOOKUP(E14,A2:D7,4)

Upgrade to CAclubindia Pro. Subscribe Now!

pramodjalandra (Account Administrator) (142 Points)
Replied 10 July 2008

Hello Dear,

Macro is a Good Feature of Excel Its Useful for whose peson who repeat same work daily or weekly or monthly. Its function as a Recorded Movie whose See or work more time.

Its function work :- Tools Menu>Macro>Record New Macro>Type your Macro name (Ram2008)

And Then down you type a Short Cut Key for example - CTRL+Q, CTRL+SHIFT+T etc.

then Hit Ok Button

After this Processing macro recording will be started and you look a small macro toolbar on the sheet and after you will be work and save file.

Then We play Macro :-

After you go to another sheet and this process be apply-

Tools>Macro(ALT+F8)>Run your exixting Macro means Ram2008 after this steps your macro recording will be see you.

(Pramod Kumawat)

pramodjalandra (Account Administrator) (142 Points)
Replied 10 July 2008

Hello Dear,

Macro is a Good Feature of Excel Its Useful for whose peson who repeat same work daily or weekly or monthly. Its function as a Recorded Movie whose See or work more time.

Its function work :- Tools Menu>Macro>Record New Macro>Type your Macro name (Ram2008)

And Then down you type a Short Cut Key for example - CTRL+Q, CTRL+SHIFT+T etc.

then Hit Ok Button

After this Processing macro recording will be started and you look a small macro toolbar on the sheet and after you will be work and save file.

Then We play Macro :-

After you go to another sheet and this process be apply-

Tools>Macro(ALT+F8)>Run your exixting Macro means Ram2008 after this steps your macro recording will be see you.

(Pramod Kumawat)