$$Excel-Macros$$ Need a Help !!! To dynamically display Text based on dependent combo box selection on a Button click

End Sub I couldn't able to dynamically connect the textbox to display the message based on the selection Please be so kind in guiding me in a way to accomplish this task successfully Many thanks for your feedback in advance! Thanks & Regards Vivek Raaja.B -- Are you =EXP(E:RT

$$Excel-Macros$$ Re: Function for Data validataion

)) *Vivek* On Friday, February 27, 2015 at 9:20:29 AM UTC+5:30, Ashish_Bhalara wrote: > > Dear experts, > > I want to formula for data validation to fulfill below conditions. > > >1. Total character should be 11 degit >2. Last 7 character should be numeric >3.

$$Excel-Macros$$ Excel File recovery - Changed to 0 kb file

information and cannot be shared. Vivek -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles

$$Excel-Macros$$ manpower service

falls in this category? Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 0361-2603895,9435019908 save earth -- FORUM RULES (986+ members already BANNED for v

$$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

How to use the Vlookup function in a separate excel file, to search for file number form the client index file, where data are stored in multiple sheets. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: > I have created a file index , with separate sheets alphabetically. > >

$$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

Dear All, Please find enclosed herewith the sample file. Thanks CA Vivek Jain. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: > I have created a file index , with separate sheets alphabetically. > > > > Now I want to use the vlookup function in a new file, where

$$Excel-Macros$$ VLOOKUP FROM A RANGE OF SHEETS

I have created a file index , with separate sheets alphabetically. Now I want to use the vlookup function in a new file, wherein I would type the clients name , and it should lookup the file number from the index file. Is it possible? Thanks & Regards... CA Vivek Jain, FCA, DISA (

$$Excel-Macros$$ FORMULA FOR DATE AND TIME

/2012 10:45 Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 0361-2603895,9435019908 save earth -- FORUM RULES (986+ members already BANNED for violation)

$$Excel-Macros$$ sumif the based on cell colour

Dear Group members, I want to use sumif function to sum a particular range based on the cell colour. Is it possible. I am enclosing herewith a sample file. Please help.. Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 R

$$Excel-Macros$$ RE: ACCESS QUERY

Dear XLStime, This is exactly what I wanted. But I wanted to know the steps to prepare the report since I have to do it for 2500 dealers for 100 schemes. Thanks in advance. Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants

$$Excel-Macros$$ RE ACCESS QUERY

ards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 0361-2603895,9435019908 save earth -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate threa

$$Excel-Macros$$ RE: ACCESS QUERY

total earning is also calculated automatically in the report. Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 0361-2603895,9435019908 save earth -- FOR

$$Excel-Macros$$ Re: access query

. I hope I am clear this time. Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 0361-2603895,9435019908 save earth -- FORUM RULES (986+ members alread

$$Excel-Macros$$ RE: access query

Dear Group, Thanks for the response. But there is no total at the end for the schemes. Moreover for each dealer there will be hundreds of schemes so please let me know the steps followed to prepare the report. Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain

$$Excel-Macros$$ access query

: 10 Sch-2 Payout : 20 Total Payout : 30 Similarly for Dealer B in new page. Etc. Please guide Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-78100

$$Excel-Macros$$ IMPORT FIXED WIDTH TXT FILE TO EXCEL

From: vivek jain [mailto:vivek.j...@gmail.com] Sent: Saturday, April 03, 2010 8:04 AM To: 'excel-macros@googlegroups.com' Cc: 'excel-macros+nore...@googlegroups.com' Subject: IMPORT FIXED WIDTH TXT FILE TO EXCEL Dear Group Members, I want to import a txt file w

$$Excel-Macros$$ Unique No

Hello All... A Column in a sheet must have only unique nos... when we enter the same no again it have to give t message NO ALREADY EXIST. pls help to to find it out. Thanking you, Vivek Chandran, Ooty - TN

$$Excel-Macros$$ PDF password CRACKER

Hi There.. I have downloaded a pdf file which is PASSWORD PROTECTED. CAn anyone PLEASE help crack the password. IF YES, then pls tell me so that i can mail the pdf file to the concerned person. I would be very oblidged for the help. Thanks in advance Thanks and Regards, Vivek Agrawal Skype

$$Excel-Macros$$ Re: Urgent_ Need ranking formula

hi Here is the attached file Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Sep 9, 2009 at 9:28 AM, vinod rao wrote: > Hello Team, > > Need ranking formula.See attached, kindly help.

$$Excel-Macros$$ Re: Compare 4 columns in excel spreadsheet

Hi Hope this solves your problem... ALL THE BEST Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Sep 9, 2009 at 7:48 PM, fishbonez wrote: > > i would like to know how can i compare 2 (A & B)cols in sheet 1 to

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

oh k Thanks a lot Sathish once Again... This was again a great learning... :) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Sep 4, 2009 at 10:53 AM, Sathish Jalendran wrote: > Hi, > > > > I just tried o

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

Really?... thats great this means some temp files might be creating some problem... neways now m happy... thanks a lot... :) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Sep 4, 2009 at 12:16 AM, Daniel

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Sep 4, 2009 at 10:12 AM, Sathish Jalendran wrote: > Hi, > > > > Check this file have tried repairing it, it works for me here > > > > Regards > > Sathis

$$Excel-Macros$$ Re: Need help on formula

Hi As per what you want... my answers are in red with yellow background The best way for what you want is that sort the column and then apply the formula in red with yellow... Hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy

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

, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Aug 27, 2009 at 12:44 PM, Sanjay Singh wrote: > Hi Everybody, > > Can you please help me with the below formula > > Thanks and Regards > > Sanjay Singh > > On Tue, Aug 2

$$Excel-Macros$$ Re: excel-macros - 26 new messages in 18 topics - digest

for that you need to open the personal workbook in order to run a macro from any workbook... you need to have that workbook open i have windows 7 installed and excel 2007... so the path for personal workbook for me is the below.. C:\Users\Vivek\AppData\Roaming\Microsoft\Excel\XLSTART

$$Excel-Macros$$ Re: Combine multiple ranges using R1C1

Hi You can use the union function it takes as argument various ranges you want to combine... eg.. Dim MyRange as Range Set MyRange = union(Range("A1"),Range("A2"), ..) hope this helps Thanks and Regards, Vivek Agrawal Skype

$$Excel-Macros$$ Re: ROUNDUP

Simple and best =CEILING(9235200.23,50)/1000 hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 12:50 AM, jsa-dk wrote: > > ROUNDUP(9235200,23*2;-6)/2000 > > > On

$$Excel-Macros$$ Re: Need help on formula

hi i got the solution with out extra column hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 4:37 PM, vinod rao wrote: > This will help.Thank you > > can you put formula with

$$Excel-Macros$$ Re: Need help on formula

rows 1157, 1158, 1159 and 1160 also contain positive values. 0.34 so these would be considered 1 like wise 1162 to 1156 also contain 0.6 which are again positive hence count to ranks 5-10.. i hope you understand what i want to convey Thanks and Regards, Vivek Agrawal Skype ID

$$Excel-Macros$$ Re: Need help on formula

how come it becomes difficult to add a column and then hide that. this will not change the visual alsoas the column would be hidden i feel it would be difficult to get without using F... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving

$$Excel-Macros$$ Re: Need help on formula

Hope This Helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 3:47 PM, vinod rao wrote: > Hello Vivek, > > I could not get the right answer. I need like > > Example > >

$$Excel-Macros$$ Re: Need help on formula

The third argument of the RANK function specifies the ranking order Blank or "0" means ascending order any other positive number or "1" means the other way round Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save E

$$Excel-Macros$$ Re: Need help on formula

Hi attached is the solution to your query Hope it helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wrote: > Hello Team, > > How do i rank only positive numbers. Plz h

$$Excel-Macros$$ Re: Urgent: Need help in dashboard creation

Hi See the attached image which contains the instructions on how to change the tab order of objects on a user form. in the image "Info Survey" refers to your user form... Hope that will help Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com

$$Excel-Macros$$ Re: Urgent:: Need code to run batch script thru Excel

Hi Shell "F:\Running Apps\FTP Backup\backup.bat", 1 the above code might help but i would like to know why the code which you gave is not reliable. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24,

$$Excel-Macros$$ Re: Find the second highest no.

Hi Gaurav The LARGE function allows to find any level of value... from highest to lowest. 2 arguments required 1. the range of numbers 2. the level required for example, 1 for highest, 2 for second highest. and so on... ALL THE BEST Thanks and Regards, Vivek Agrawal Skype ID

$$Excel-Macros$$ Re: Urgent: Need help in dashboard creation

ttp://www.excel-vba.com/vba-forms-3-6-text-boxes.htm> Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 10:04 PM, bharghav r wrote: > Hi All, > > > 1> Is there any option of switching between > tex

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

then do one thing just mail the moderator. he would certainly take care of that you can mail Ashish or Ayush Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 5:13 PM, Sandeep wrote: > *F

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

when did u send them... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 5:07 PM, Sandeep wrote: > They not come the the forum. I don't know what happent to them. > > Sandeep > > --

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

have your mails been blocked?? Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 4:56 PM, vivek agrawal wrote: > Hi Sandeep > > The mails to this group have to go through moderation. > O

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

none of the mails are blocked. they are just waiting for moderation its entire upto the moderator to approve the mails... but till date none of my mails have been blocked or any body others' too for that matter. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agra

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

Hi Sandeep The mails to this group have to go through moderation. Only when the moderator approves the mail, that it gets delivered to the group for members viewing. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24

$$Excel-Macros$$ Re: Frnds

Hi Some pdfs have been uploaded to the groups FILES section. kindly go through that and if u dont find any then feel free to write back. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 2:05 PM

$$Excel-Macros$$ Re: Help with formatting and subtotal

Hi Attached is the solution to problem.. you just need to hide to column C. Hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 15, 2009 at 1:34 AM, Cesar Delanoval wrote: > > I have a simple ta

$$Excel-Macros$$ Re: insert = in every cell with nos & Blank

attached is the file... hope this is the solution required Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 8:44 PM, Manoj Kukrej wrote: > Hi > > want to insert "=" sign before each

$$Excel-Macros$$ Re: Logos Quiz !!

no info about how to fill those text boxes any idea?? Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 5:52 PM, Iqbal Shaikh wrote: > Friends > > Can u solve this

$$Excel-Macros$$ Re: Help Needed

the zip is password protected Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 5:42 PM, Iqbal Shaikh wrote: > Hi All > > > Can u help me for open the XL file which is in ZIP. > >

$$Excel-Macros$$ Re: Timevalue and Datevalue suddently doesn't work any more

thats great :0 but the excel file which you sent already contained those sells in the date and time format Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 5:16 PM, zheng yu wrote: > Hi Vi

$$Excel-Macros$$ Re: Number in Words

Hi Sachin You simply need to copy paste the code into your own workbook.. you can get access to the code by ALT + F11 Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 8, 2009 at 1:37 PM, sachin patil wrote: > Dear

$$Excel-Macros$$ Re: Code to hide workbook

One workaround can be setting "Application.screenupdating = false" just before you open it. and then set the same to TRUE when you want to make it visible. Hope it helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Ea

$$Excel-Macros$$ Re: help Needed!

query,m i doubt i am right. So please elaborate if this is not what you want Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 12:53 PM, Abdul Rehman wrote: > Hi All, > > Can anyone guide me how

$$Excel-Macros$$ Excel vba for outlook

a mail. I want to be able to change the from address. can anybody help me do so thanks Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***

want on these please specify (what you want and what you dont want..) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 8, 2009 at 4:49 PM, Chidurala, Shrinivas < shrinivas.chidur...@citi.com> wrote: >

$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***

Hi Attached is the Text File Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Aug 7, 2009 at 5:34 PM, Upendra Singh wrote: > Hi Vivek, > > > > > > Send me the macro as text file as my outlook had bloc

$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***

he all the headings. and the data should start from the second row onwards. rest - you can modify the code according to your needs. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Aug 7, 2009 at 10:34 AM, Chidurala,

$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***

save these different sheets in the same location where the file containing this module is present. you can modify the code based on your needs. Feel free to mail me if more help required. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth

$$Excel-Macros$$ Re: Urgent help requird

Hi Shivashankar cal u please clarufy in which structure or format do you require the result in Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 3, 2009 at 1:44 PM, shivashankar katageri < shankarkatag...@gmail.

$$Excel-Macros$$ Re: Code not runnig after the file is opened

, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 1, 2009 at 4:59 PM, vivek agrawal wrote: > > M sorry... The problem occurs in Line 4 not 3 (i.e. while opening the > file,.).. it was a typo > Well... It was understandable

$$Excel-Macros$$ Re: Code not runnig after the file is opened

M sorry... The problem occurs in Line 4 not 3 (i.e. while opening the file,.).. it was a typo Well... It was understandable but still no confusions... WAITING FOR REPLY Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat

$$Excel-Macros$$ Code not runnig after the file is opened

ep Into). then when the Line 3 is executed... it takes some time and then the next code automatically gets ready to get executed. HOPE I HAVE EXPLAINED MY PROBLEM WELL. Please help. Would be very grateful to you... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 Go

$$Excel-Macros$$ Re: Progress Reporter

Yes... PROGRESS BAR Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 30, 2009 at 3:26 PM, zheng yu wrote: > you mean progress bar? > > On Thu, Jul 30, 2009 at 10:45 AM, vivek agrawal > wrote: > >&

$$Excel-Macros$$ Progress Reporter

Hi ALL Can any body help me create a progress reporter or if someone has it or if someone has build on his and he is willing to share that... then PLEASE do... Your help would be greatly appreciated... thanks a lot.. Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com

$$Excel-Macros$$ Re: Escaping a foir loop

thanks for all the replies... does Excel VBA have a substitute command for "Continue" .. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 29, 2009 at 4:43 PM, Daniel wrote: > Hi. > >

$$Excel-Macros$$ Re: Escaping a foir loop

Hello Kumaran Exit For would completely exit from the for loop.. i want it to skip the code for the current loop and iterate to the next loop Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 29, 2009 at 4:45 PM

$$Excel-Macros$$ Escaping a foir loop

should not run and the next should be started... i want the line of code which i should insert in the ifendif statement its urgent can anybody please help me.. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth

$$Excel-Macros$$ Re: Password removal Tool !

Hi Shafiq Where is the file... Please attach the same Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Jul 28, 2009 at 3:59 PM, shafiq online wrote: > > Attached is password removal tool. You can you it by

$$Excel-Macros$$ Re: Can any one resolve this?????

End Sub == Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Jul 28, 2009 at 5:48 AM, hemant shah wrote: > Hi All, > > I have recently join the group and i have one query on ex

$$Excel-Macros$$ Re: Segregation of data on a button click in excel

Pinky... can u please attach the file..so that the solution can be worked out in that itself Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Jul 27, 2009 at 4:18 PM, Pinky Sangani wrote: > > HI > i need this ASAP

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

Hi Dhananjay. Have you been able to download the file Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Jul 27, 2009 at 7:25 PM, Dhananjay Pinjan wrote: > Hello Mr. Vivek Agrawal, > > I cannot able to view

$$Excel-Macros$$ Re: High : TOP URGENT

Hi Dilip Thanks for the reply... will look forward to your help whenever required and thanks for the compliments... :-) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sun, Jul 26, 2009 at 1:39 PM, Dilip Pandey wrote

$$Excel-Macros$$ Re: High : TOP URGENT

Dear Dilip Can you please assist how did u crack the password protected file Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 8:44 PM, Dilip Pandey wrote: > Hi Abdul, > > Attached xls has been &qu

$$Excel-Macros$$ Re: High : TOP URGENT

hi Abdul... You can copy paste the sheet date to some other sheet in some another workbook Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 6:17 PM, Abdul Hakim Khan wrote: > Dear All, > Please h

$$Excel-Macros$$ Re: File needed in pdf

Hi Dave Please find the pdf file at http://groups.google.com/group/excel-macros/files?&sort=date Save the first listed file in the link above Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 5:2

$$Excel-Macros$$ Re: QUERY ON EXCEL

Hi The query is not very clear can u please explain what you want Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 5:43 PM, big smile wrote: > Respected friends, > > I am new this group. >

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

the file can be opened only through a TORRENT application such as bitlord. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 4:52 PM, DEBASHIS BANERJEE wrote: > if Save target is clicked .. file

$$Excel-Macros$$ Re: Code to remove cache after running pivot table

Hi Ravi... I am not easy with pivots but guess the following link might be helpful http://www.brainbell.com/tutorials/Excel_VBA/Size_Of_A_Finished_Pivot_Table.html Hope it Helps Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul

$$Excel-Macros$$ Re: Removing leading Zeros

hi manoj this would remove all the zeros from inbetween... he wants to remove only the trailing zeros... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 4:14 PM, Manoj S Negi < manojsnegi.uttr

$$Excel-Macros$$ Re: Removing leading Zeros

, Position, 1) Do While vChar = "0" Position = Position + 1 vChar = Mid(vCells.Value, Position, 1) Loop vCells.Value = Mid(vCells.Value, Position, Len(vCells.Value)) Next End Sub = Hope it works Regards, Vivek Agrawal Skype ID - vivek

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

Hi Kunal I dont have the specified book. See if could search in on internet... torrents might be available Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 3:37 PM, kunal wrote: > > Hi, Vivek, >

Re: Fwd: $$Excel-Macros$$ Need earliest record based in unique identifier

Hi Attached is the module that does your work... Hope it suffices.. Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Jul 24, 2009 at 11:22 PM, Lee wrote: > > Here is the link to the file. > > www.progressivetel.

$$Excel-Macros$$ Re: How to retrieve the address of a cell used in a formula

Hi Can u please attach a sample sheet... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 1:22 AM, Telenochek wrote: > > Hello everyone, > > I have a worksheet that calculates system performan

Fwd: $$Excel-Macros$$ Need earliest record based in unique identifier

Hi i would suggest you send the file so that the workaround can be figured out... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Jul 24, 2009 at 6:58 PM, Lee wrote: > > I have a bunch of test data. Column A is th

$$Excel-Macros$$ Re: PlZ Short This Pro.

Hi Anil The segregation of the full name into first and second name is based on self judgement in case of 3 word names... how would you like to separate into two names Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri

$$Excel-Macros$$ Re: Help for Data Avance Filters

ops up... enter the upper and the lower range in the appropriate boxes... DONE. :-) hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Jul 24, 2009 at 12:11 PM, Rehan Baig wrote: > I need help for usin

$$Excel-Macros$$ Re:

Hi Debashis go to this link http://groups.google.com/group/excel-macros/files?&sort=date right click on the first file and save it directly... it gets saved... i've checked it just now.. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving en

$$Excel-Macros$$ Re: Unique Data summary problem

egards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 10:48 PM, Vishvesh Chauhan < vishvesh.chau...@gmail.com> wrote: > Vivek, > > I understood the problem actually countifs is not there in excel 2003, and &g

$$Excel-Macros$$ Re: Unique Data summary problem

depends what formula you are putting... the referencing of cells need to be taken care of Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 10:16 PM, Vishvesh Chauhan < vishvesh.chau...@gmail.com>

$$Excel-Macros$$ Re: Saving Filename with variable

Hi Aman Can u please specify what kind of error you are facing which point the error comes does the file get saved.. or might be possible the file path doesnot exist. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On

$$Excel-Macros$$ Re: how to make unique key

. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 9:19 PM, Aamir Shahzad wrote: > Dear Vivek Agrawa, > > Thanks for reply. Please find attachment. In attachment two sheet available > "Main sheet

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

Hi Aamir go to this link http://groups.google.com/group/excel-macros/files?&sort=date right click on the first file and save it directly... it gets saved... i've checked it just now.. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-S

$$Excel-Macros$$ Re: Duplicate colmuns

<> 0 Then vClmn(1)(x).Interior.ColorIndex = vColor(x) vClmn(2)(x).Interior.ColorIndex = vColor(x) End If Next End Sub ==== Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul

$$Excel-Macros$$ Re: Duplicate colmuns

End If Next For x = 1 To vRows_Count If vColor(x) <> 0 Then vClmn(1)(x).Interior.ColorIndex = vColor(x) vClmn(2)(x).Interior.ColorIndex = vColor(x) End If Next End Sub = hope it does the required.. Thanks

$$Excel-Macros$$ Re: Duplicate colmuns

ok ok now i got the query,.., will try to get a solution soon... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 12:51 PM, Mahesh wrote: > Hi vivek, > > I want that if both columns are same then i

$$Excel-Macros$$ Re: Duplicate colmuns

Hi Satish It would be really helpful of you if you could show the same in an excel sheet required is that different duplicate sets should be identified by different colors so that we can diffentiate them and find how many value are duplicated... Thanks a lot Regards, Vivek Agrawal Skype ID

$$Excel-Macros$$ Re: Duplicate colmuns

hi mahesh The requirement is still not clear... can u please explain which values u want to compare and in what manner to highlight Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 9:20 AM, Mahesh wrote

$$Excel-Macros$$ Re: Saving Filename with variable

'Define the filename vPath = "D:\extractfiles" ' Define the file path - can be changed accordingly ActiveWorkbook.SaveAs vPath & "\" & vFileName & ".xls" 'Saving the workbook. ActiveWorkbook.Close End Sub

$$Excel-Macros$$ Re: Books on MS 2007

it is working i just checked.. try saving the file from the "FILES" section of the group Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 12:17 AM, kanwaljit Singh wrote: > Hi Viv

$$Excel-Macros$$ Re: Count of Status

copy pasting would not work as the cell referencing takes place... u will need to edit the code according to the column and the row used. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 8:09 PM, Saurabh

$$Excel-Macros$$ Re: Count of Status

this includes HD too Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 8:09 PM, Saurabh wrote: > Exactly want the same.. Thanks.. > > One more query... > > 1). I m not able to use the sa

  1   2   >