$$Excel-Macros$$ Re: Thanks a lot

2009-08-29 Thread Dilip Pandey
You are welcome Vidyut. And just want to say that your name is really good Electrifying. ha ha..!!! Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/29/09, vidyut more vidyutm...@gmail.com wrote:

$$Excel-Macros$$ Re: help with Vloopup function

2009-08-29 Thread vijay Kumar
Try this range(a1)= worksheetfunction.vlookup(range(b1).value,workbooks(File name.xls).worksheets(Sheetname).Range(Select table),2,0) On Thu, Aug 27, 2009 at 12:44 PM, Sanjay Singh sanjaysingh294...@gmail.comwrote: Hi Everybody, Can you please help me with the below formula Thanks and

$$Excel-Macros$$ Re: Hi My All Friends Urgent

2009-08-29 Thread amresh kumar
Thanks On Fri, Aug 28, 2009 at 6:54 PM, Aindril De aind...@gmail.com wrote: Hi Amresh, This can be achieved doing the following steps: 1) Select the entire sheet. 2) Right Click on the selected area and select Format Cells. 3) In the format cells dialog box choose the Protection Tab. 4)

$$Excel-Macros$$ Sample of VBA application for office 2007.

2009-08-29 Thread Abdul Hakim Khan
Dear All, Could any body provide us real application or example of VBA in excel 2007 and word 2007. For all office 2007 component. Rgds, Aligahk06 -- - A calm sea does not make a skilled sailor. Wishing you and all your loved ones greatest of times ahead! Aspiring 2 c u happy! Abdul

$$Excel-Macros$$ trace formula text manual feeding

2009-08-29 Thread Manoj Kukrej
Hi Dilip , In range , I want to find the cell with manual entry I use GoTOo , but if cell having manual entry was not able to trace Regards Manoj From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dilip Pandey Sent: Saturday, August 29, 2009 1:22 PM To:

$$Excel-Macros$$ link cell-unlinked cell-double link cell

2009-08-29 Thread Manoj Kukrej
Hi I want to know( or colour it) the cell link-not link- double link cell As I am having the huge-1000 rows , I can do manual using trace precedent-fomula auditing Can You help me to give easy trick regards Manoj This e-mail contains PRIVILEGED AND

$$Excel-Macros$$ help plz

2009-08-29 Thread ashish koul
hi i want to apply vlookup formula to gind the age of person in the attached sheet in sheet 1 for example i want to find the age of rajesh and i don't know whther it is in sheet 2,or 3 or 4 .. have to search aal the sheets and give me the result thanks ashish

$$Excel-Macros$$ Re: help plz

2009-08-29 Thread Ramkrishna Padhi
Hi Ashish, Please find the attached solution. Thanks Regards, Ramkrishna T. Padhi On 8/29/09, ashish koul koul.ash...@gmail.com wrote: hi i want to apply vlookup formula to gind the age of person in the attached sheet in sheet 1 for example i want to find the age of rajesh and i don't

$$Excel-Macros$$ Re: help plz

2009-08-29 Thread Sandeep
Hi Ashish find the attached solution Regards Sandeep - Original Message - From: ashish koul To: excel-macros@googlegroups.com Sent: Saturday, August 29, 2009 8:38 PM Subject: $$Excel-Macros$$ help plz hi i want to apply vlookup formula to gind the age of person in the