Re: $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tables

Thanks Rajan... Its great... On Sat, Sep 15, 2012 at 10:47 AM, Ashish Bhalara wrote: > Its very nice Addon, excellent job. > > > On Fri, Sep 14, 2012 at 7:35 PM, Rajan_Verma wrote: > >> *Its Wow **J*** >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >>

$$Excel-Macros$$

-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n

$$Excel-Macros$$ Re: Highlight Worked Cells only if the Employee has worked in both areas

Hello Prince Dubey, Your solution works. But as I mentioned in my original post the data will be in different areas of the sheet Not in A1:AK117 always...which is where your code will work. Can you please change your code so that it runs on any selected range only. Thanks for your time and help.

Re: $$Excel-Macros$$ Re: Excel Formula challenge

It workz for the given case but if more txt is der den formula wil run for milez :p I'm figuring formula dat wl work for all cases. Rgds -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Sat, 15 Sep 2012 22:38:16 To: Reply-To: excel-macros@googlegrou

RE: $$Excel-Macros$$ Re: Excel Formula challenge

Nicely done Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vabz Sent: 15 September 2012 10:04 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Excel Formula challenge Hi PFA C

$$Excel-Macros$$ Re: Excel Formula challenge

Hi PFA Cheerz.. Rgds//Vabs On Wednesday, August 8, 2012 9:33:25 PM UTC+5:30, Rajan_Verma wrote: > * * > > *Hi group,* > > * * > > *Hope you will post an excellent solution here :* > > *Let suppose you have a string like below :* > > *A|A|A|B|B|C|A|B|C|D* > > *As you can see the characters

$$Excel-Macros$$ Re: Highlight Worked Cells only if the Employee has worked in both areas

Hi Rashid, Please see the attachment, Hope this will help you. Note : For testing the solution first set any other color for the cell where the your specified criteria matched and then press the button Highlight. regards prince On Saturday, 15 September 2012 17:22:57 UTC+5:30, prkhan56 wrote:

Re: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET

Hi Go to page setup (its under print title) then.. Select Header / Footer, Then Select custom footer.. There ther is option for inserting Image.. Cheerz.. Rgds//Vabz On Saturday, September 15, 2012 9:03:48 PM UTC+5:30, sandeep chhajer wrote: > Dear sir, > > How to insert a line

RE: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET

You can Make that image and set in footer Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sandeep Chhajer Sent: 15 September 2012 9:04 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ R

RE: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET

Dear sir, How to insert a line in footer. Thank you Regards Sandeep Kumar Chhajer. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: 15 September 2012 20:31 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re:

RE: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET

Absolutely Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vabz Sent: 15 September 2012 8:27 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET H

$$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET

Hi I dont know customisation for footer, however you can create Image of data you want & Insert in footer.. Cheerz.. Rgds//Vabs On Saturday, September 15, 2012 7:27:45 PM UTC+5:30, sandeep chhajer wrote: > Dear all, > > > > I want to get box to be printed in every sheet. > > Now with “re

$$Excel-Macros$$ WANT TO GET BOX MARGIN IN EVERY SHEET

Dear all, I want to get box to be printed in every sheet. Now with "repeat rows" I can get only upper margin. I want it to be same for lower margin to enclose the whole script in a box for a page. Please help. Thank you Regards Sandeep Kumar Chhajer. -- Join official facebo

Re: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks

Do you not know the names of your files? simply add a sheet to your workbook and enter these names.   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people yo

RE: $$Excel-Macros$$ Pull out VBA code from sheet

If you are using Excel 2010 , spark lines comes with that, Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 15 September 2012 1:00 To: excel-macros@googlegroups.com Subject: $$Excel-M

$$Excel-Macros$$ Re: Highlight Worked Cells only if the Employee has worked in both areas

HI You can use conditional formating in H10 coloumn =IF(A10=A9,IF(H9="",0,IF(H10="",0,1)),IF(H10="",0,IF(H11="",0,1)))=1 & set yellow color if true.. after that you can select area to assign. Cheerz.. Rgds//Vabs On Saturday, September 15, 2012 5:22:57 PM UTC+5:30, prkhan56 wrote

Re: $$Excel-Macros$$ Excel to powerpoint

Enhanced metafile Sent on my BlackBerry® from Vodafone -Original Message- From: natu.ajin...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 15 Sep 2012 12:15:19 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel to powerpoint What format are u p

Re: $$Excel-Macros$$ Excel to powerpoint

What format are u pasting the picture as? Sent on my BlackBerry® from Vodafone -Original Message- From: joseph.cam...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 15 Sep 2012 11:59:05 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel to powerpoint

$$Excel-Macros$$ Excel to powerpoint

Hi, I am using MSOffice 2010. I create charts in excel and paste them in PowerPoint as picture, the resolution of the chart is very poor. This does not happen when I use 2007 version. Please help. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- Join official facebook page of this foru

$$Excel-Macros$$ Highlight Worked Cells only if the Employee has worked in both areas

Hello Experts, I am using Excel 2010 and have the following problem. If an employee no. is duplicate and he has worked in both Work Areas viz EC and RTG then I wish to highlight only those Worked Cells with Yellow. I have done it manually to demonstrate my requirement in yellow. As the data shown

Re: $$Excel-Macros$$ Re: Please Help to Find out the solution

Hello Vabs. Hats off bro. Both of your solution are working for me. Thank you. Cheers On Sat, Sep 15, 2012 at 4:52 PM, Vabz wrote: > HI > > You can also use this formual.. > > =OFFSET(A2,1,1,) for Company & =OFFSET(A2,1,2,) for Phone number > > After that copy & paste sepcial all data to its v

$$Excel-Macros$$ Re: Please Help to Find out the solution

HI You can also use this formual.. =OFFSET(A2,1,1,) for Company & =OFFSET(A2,1,2,) for Phone number After that copy & paste sepcial all data to its value, then filter all data. After that filer on coloumn A & selct only Blank & delete visible cell so that you will get only desired data and

$$Excel-Macros$$ Re: Please Help to Find out the solution

Hi See Sheet with formula.. Let me know if itz fyne. Cheerz.. Rgds//Vabz On Saturday, September 15, 2012 2:54:36 PM UTC+5:30, Wassi wrote: > Hello Friends, > I am new using vba excel. Please help me to find > that how we can select after Vlookup. > > In attached workbook i m trying to fi

Re: $$Excel-Macros$$ MIS REPORT FOR HR

Please search in below link http://www.citehr.com/48781-how-make-hr-mis.html On Sat, Sep 15, 2012 at 8:22 AM, kannan excel wrote: > Hi friends, > > i need mis report format for hr purpose. kly help me urgent base. > > regards > kannan v > > -- > Join official facebook page of this forum