$$Excel-Macros$$ Re: Need help in finding solution

Hello Dilip, kindly see attached. Thank you. My Question once I select from the drop down can the data pulled (Columns d & e & f )from Data sheet to sheet 2? is it possible without formulas? Data sheet should not be changed, only it should pull Also need all option to select Regards, VR On

$$Excel-Macros$$ Re: $$ TIP $$ Backing up Excel Files

Hi Ayush, could you plz let me know were can find this option in Excel 2007. Thanks, Sai On Thu, Sep 17, 2009 at 6:51 PM, Aindril De wrote: > Hats Off Ayush... > Excellent Tip... > > > Regards, > Andy > > On Thu, Sep 17, 2009 at 7:31 PM, Ayush Jain wrote: > >> ** >> Do you have important

$$Excel-Macros$$ initiate macro when mouse hovers over a shape

I have an Excel application and on my 'front end' I would like to generate a pop-up note when the user hovers over a 'shape'. (This would be similar to how a comment appears when the user hovers over a cell with the comment indicator). Is this possible? If so can you help me understand the code

$$Excel-Macros$$ Re: Date Format

Hi Kaustubh, If you have these dates in column A, then try the following formula in column B and drag it down. Thanks. =DATE(RIGHT(A1,2),MID(A1,FIND(".",A1)+1,FIND(".",A1,2)-1),LEFT(A1,FIND(".",A1)-1)) Solved workbook is also attached. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.

$$Excel-Macros$$ Re: Job Opportunities for Excel/VBA Professionals

Hi Siva, Search job portals with search strings like "MIS Executive" or "MI Reporting" or "Data Analyst" or "VBA Developer" or "Management Reporting" etc and you'll get lots of openings listed there. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmai

$$Excel-Macros$$ Re: Need help in finding solution

Hi Vinod, There is no attchment. Please re-attach. Suggestion:- Kindly try to explain your query in email body as well, so that group member can give a try then and there. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com N

$$Excel-Macros$$ Appending multiple excel files into one

Hi, I am trying to append multiple excel workbooks into. Basically to merge daily reports into a weekly one. I found the code below somewhere on internet but it is not working for me. Can someone please look and let me know how I need to change this in order to make it work ? Sub AppendData()

$$Excel-Macros$$ Error 91 - Run Time

I am trying to create a table in Access 2003 through VBA. I keep getting an error 91 where the Object variable or With Block is not set. If appears like I have all the right code to create this table but I can't get beyond the Set statement. Thanks in advance. Dim dbs As Database Dim tdf As Ta

$$Excel-Macros$$ Re: Data Validation

Hi This is interesting solution can you plz explain how u did?? Regards Ruchi On Wed, Sep 30, 2009 at 6:15 PM, Umesh Gupta 3 wrote: > please find solved  sheet > > - Original Message - > From: Aligahk06 > To: excel-macros@googlegroups.com ; dilipan...@gmail.com > Sent: 30 September, 200

$$Excel-Macros$$ Re: VBA

Start creating the Excel macro. That is the best way to learn On Wed, Sep 30, 2009 at 10:45 AM, sarfaraz ahmed wrote: > Use google to search VBA codes. there are lot of website, ebooks, forums > and help available. > Each time you have a task in head, try to VBA to resolve it once and all. > So,

$$Excel-Macros$$ Re: Class Module

Hi Jai, If you know these function without VBA, then you easily understand and use below codes: Sub vlookup() Range("d9").Formula = ("=vlookup(c9,a:b,2,0)") End Sub Sub hlookup() Range("h5").Formula = ("=hlookup(h4,1:2,2,0)") End Sub A Workbook is also attached with the required VBA code. Thank

$$Excel-Macros$$ Re: Find & Clear

At the beginning of the macro, add: On Error Resume Next then, after the .Find command, use: if (err.number > 0) then exit sub From: Tommy To: MS EXCEL AND VBA MACROS Sent: Wednesday, September 30, 2009 11:15:04 AM Subject: $$Excel-Macros$$ Find & Clear I

$$Excel-Macros$$ Re: PDF password CRACKER

send it to me vivek I will help u crack it. On 9/30/09, vivek agrawal wrote: > 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 b

$$Excel-Macros$$ Re: Data Validation

Hi, You can use reference from different sheet only if you define name for that and use name as range in validation. Regards Sandeep - Original Message - From: Dilip Pandey To: excel-macros@googlegroups.com Cc: aligah...@gmail.com Sent: Wednesday, September 30, 2009 8:40 P

$$Excel-Macros$$ Re: Date Format

Hey Abhishek, In fact when I tried later, I found that your suggetion works. When I replaced . with / it automatically gave me the date format dd/mm/. And once I got that it is very easy to convert it in mm/dd/yy. Great ! Thanks On Sep 30, 9:48 am, Abhishek Jain wrote: > Hi Kaustubh, > > Sor

$$Excel-Macros$$ Find & Clear

I am trying to find the first cell in a column containing the text "zz" and then clearing that cell and moving on to accomplish other things. When a cell is found with :zz" in it, all is well, but if there are no cells in the column that contain "zz", the macro stops running and generates an error

$$Excel-Macros$$ A Humble request to all member posting queries to this group......

Hi Upendra, Thanks for your inputs. I totally agree with your guidelines and request members to adhere the same. Dear members, Please follow the guidelines as suggested by Upendra. Any member not following this shall be banned. Let me know if you have any concerns. Best regards, Ayush Jain -

$$Excel-Macros$$ Need help in finding solution

Hi Please find attached sheet with questions Thanks in advance. Regards, Vr. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), F

$$Excel-Macros$$ Re: Data Validation

Dear Mr. Umesh, Could you please tell me step by step, So that we can know how to do it. It is very usefull for us in our job. Please explain in step, I will be very thankfull to you. Thanks & Regards, Imran Khan Project Control Engineer KBR - Kellog Brown & Root Saudi Kayan Olefins Project Al-J

$$Excel-Macros$$ Re: Token of Thanks !!!!!!

Hi Aligah Thanks for the "Token". I have just replied to this query as well with the solution. Suggestion(s):- Please mark the queries to "Group" as well so that they can also participate and help. Moreover, please do not change the subject line of the queries. Thanks. -- DILIP KUMAR PANDEY

$$Excel-Macros$$ Re: Access To Excel

Jack, You need not to install entire MS-Access to work with Access. I think MS-Access runtime should help you. Below is the link to download MS-Access Runtime. http://www.microsoft.com/downloads/details.aspx?familyid=d9ae78d9-9dc6-4b38- 9fa6-2c745a175aed

$$Excel-Macros$$ Re: Date Format

Hi Kaustubh, Do as below: 1. Select all the cells for which you want to change the format 2. Go to Data->Text to Column. 3. Select Delimited and click Next. 4. Keep "Tab" Select and make sure nothing else is selected and Press Next. 5. In the Column Data Format select the format of da

$$Excel-Macros$$ Re: Data Validation

please find solved sheet - Original Message - From: Aligahk06 To: excel-macros@googlegroups.com ; dilipan...@gmail.com Sent: 30 September, 2009 1:45 PM Subject: $$Excel-Macros$$ Data Validation Please find the attached sheet for said problem. --~--~-~--~-

$$Excel-Macros$$ Re: PDF password CRACKER

I have a Password Cracker application...may be I can give it a try..plz do send ur file.. Cheers!! ANISH On Wed, Sep 30, 2009 at 5:00 PM, vivek agrawal wrote: > Hi There.. > > I have downloaded a pdf file which is PASSWORD PROTECTED. > > CAn anyone PLEASE help crack the password. IF YES, then pl

$$Excel-Macros$$ Fwd: A Humble request to all member posting queries to this group......

Hi Upendra, Thanks for your inputs. I totally agree with your guidelines and request members to adhere the same. Dear members, Please follow the guidelines as suggested by Upendra. Any member not following this shall be banned. Let me know if you have any concerns. Best regards, Ayush Jain --

$$Excel-Macros$$ Re: parsing multi line data

Hi Bryan/Harris, I think an intelligent use of "Text - to - column" feature of MS-Excel will do the task. can you attach the sample file for the group to have a try on it. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com Ne

$$Excel-Macros$$ Re: VBA

Hi Sumanth, To learn VBA, you can either refer to google search or go through following links, which are there in the email footer of every email marked to the "Group", Same is reproduced below. Morevover, there are books uploaded in the "Files" section at the home page of the Group. =

$$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 ID

$$Excel-Macros$$ Re: VBA

Thank you Sarfaraz ! -- Regards, Jai Deo Tiwari, Rewire Information Systems Indiranagar, Bangalore - 38 Mob # 09620346991 . Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient

$$Excel-Macros$$ Data Validation

Please find the attached sheet for said problem. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at htt

$$Excel-Macros$$ Re: Class Module

Hi everyone, Please tell me how to use v-lookup and h-lookup using VBA. If possible please attach the docs of example. > > > > -- Regards, Jai Deo Tiwari, Rewire Information Systems Indiranagar, Bangalore - 38 Mob # 09620346991 . Notice: The information contained in this e-mail message

$$Excel-Macros$$ Financial Modelling / Economic Modelling using Excel/VBA

Dear all Would like to know any university/institute offering courses on Financial Modelling/Economic Modelling using Excel/VBA. Regards Sivakumar --~--~-~--~~~---~--~~ -- Some import

$$Excel-Macros$$ Job Opportunities for Excel/VBA Professionals

Dear all Would like to know the job opportunities available for excel/vba professionals in India. Kindly comment your views. Regards Sivakumar --~--~-~--~~~---~--~~ -- Some importan

$$Excel-Macros$$ Re: Getting top 50 ranks from a pivot table

Dear Tiwari, To learn VBA, you can either refer to google search or go through following links, which are there in the email footer of every email marked to the "Group", Same is reproduced below. Morevover, there are books uploaded in the "Files" section at the home page of the Group. =