CA Ramsai N (Fresher) 24 June 2013
Do you want to insert the company name (or Same Heading) in all the sheets of Work book??????
Here is the solution...
Step:: Go to View menu >> Marcos >> Record Macros
Step 2:: Give name and Short cut and click on OK
Step 3:: Create the heading (with desired font , color , backgroud etc)
Step 4 ::: Go to View menu >> Macros >> Stop recording
Step 5 ::: Select all(left click on sheet name)/ desired sheets, in which u want to insert the name
Step 6::: Use short cut (if u given before) or View>> Macros >> Run that marco....
Task Completed BOSS