Re: $$Excel-Macros$$ Saving Photos from webpage

Hi Chilexcel, Apologies for delay in response. As suggested by you, I have tried the steps. It require manual interaction of click and download the photos. Experts @ Please create something to make this activity automatic as I have a huge data to download. Thanks & Regards, Kiran On Sun, Ju

Re: $$Excel-Macros$$ Introduce Yourself !!

Dear All, My self Nagendra M and 28 years old. am basically from Andhra Pradesh.Working in Bangalore as a Finance Analyst fast 7years. I like very much Excel and this group as well...Thanks you so much knowledge sharing and helping other's Thanks&Regards Nagendra.M "Beautiful photos are develope

$$Excel-Macros$$ Excel Finacial Dash Boards

Hello Pankaj, To get more financial Dashboards and templates visit www.exinfm.com. Regards, P.VIJAY KUMAR -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem

Re: $$Excel-Macros$$ Upgraded to windows 7 - question on personal.xlsb workbook

Really, it doesn't matter what folder you put it in, as long as excel is CONFIGURED to open the files in that folder. Find out what folder Excel has in the setting "open all files in this folder:" Then put Personal.xlsb in that folder. I have mine on a shared network folder so that it is availa

Re: $$Excel-Macros$$ Need your help !!!

Thanks Noorain Bhai, On Tue, Jun 19, 2012 at 9:08 PM, NOORAIN ANSARI wrote: > see attached sheet > > > On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI > wrote: > >> Dear Mangesh, >> >> Please try it.. >> >> =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0) >> with ctrl+Shif

$$Excel-Macros$$ Upgraded to windows 7 - question on personal.xlsb workbook

We have users in my area that are being upgraded from XP to Windows 7 with Office 2007 software. I want to take the macros written for that user, and place the workbook (personal.xlsb) in the folder where they will start automatically like the old system did. I tried putting it in the followin

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

Thanks You both Really they are great. We should share more sample Dashboards in Excel Regards Pankaj Michael On Tue, Jun 19, 2012 at 8:37 PM, Mangesh Vimay wrote: > Thanks Noorain for sharing such nice examples..!!! > > > > On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI > wrote: > >> PFA >>

Re: $$Excel-Macros$$ Re: How to creat digital watch in excel

Rajan only commented the work I've done 1 .- move the cursor and enter hours 2 .- hours Clickleft button entry 3 .- add ins stopwatch to determine differences 4 .- formulated to test differences Atte Chilexcel 2012/6/19 Suman > Thanks a lot rajan jee..! > > -- > > > > > > > > > > *Su

Re: $$Excel-Macros$$ Re: How to creat digital watch in excel

Thanks a lot rajan jee..! -- *Suman Kumar* On Tue, Jun 19, 2012 at 4:21 PM, Rajan_Verma wrote: > Hi > > In workbook code module Paste this : > > > Private Sub Workbook_BeforeClose(Cancel As Boolean) > StopIt > End Sub > > Private Sub Workbook_Open() >GetStart > End Sub > > i

RE: $$Excel-Macros$$ Re: How to creat digital watch in excel

nice Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ChilExcel Sent: 19 June 2012 9:09 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: How to creat digital watch i

Re: $$Excel-Macros$$ How to creat digital watch in excel

Tkanks a lot Noorain ji,will u please explain how its working? Regards, @Suman Send on the move with Galexy y. On Jun 19, 2012 3:49 PM, "Suman" wrote: > Hi, > every one..! > i'm trying to write a macro to create a digital watch in excel please > guide me.. > > Regards, > @Suman > Send on the mov

Re: $$Excel-Macros$$ Re: How to creat digital watch in excel

Rajan .. I created an add ins to add to the clock its purpose is to determine the timecode breaks talk about its usefulness example Stat End time difference 21:49:23,66 21:49:28,61 00:00:04,95 Chilexcel 2012/6/19 Rajan_Verma :

Re: $$Excel-Macros$$ Need your help !!!

see attached sheet On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI wrote: > Dear Mangesh, > > Please try it.. > > =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0) > with ctrl+Shift+enter > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacrowor

Re: $$Excel-Macros$$ Need your help !!!

Dear Mangesh, Please try it.. =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0) with ctrl+Shift+enter -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay wrote: > Hi Friends, In above

$$Excel-Macros$$ Need your help !!!

Hi Friends, In above example, if we input the name like ABC then it should display it's apropriate values in the table from the above list. Please find the attached sheet. How can we find the solution by using Vlookup() function? . Thanks -- With regards, MaNgEsH -- FORUM RULES (986+ members

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

Thanks Noorain for sharing such nice examples..!!! On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI wrote: > PFA > > > On Tue, Jun 19, 2012 at 6:49 PM, Mangesh Vimay wrote: > >> Many many thanks for this >> >> >> >> >> On Tue, Jun 19, 2012 at 6:39 PM, CoRe wrote: >> >>> Hello Pankaj, >>> >>

RE: $$Excel-Macros$$ Please help : Use of Criteria & Rule1-2

Hi Suyog, I have used the name ranges in the sheet. If function starts with logical reason, to view the name ranges press CTRL+F3 So I have defined each logic a diffrent name like criteria 2 ,criteria3 like that Hope I have cleared you doubt, if you still have any queries please feel free to co

$$Excel-Macros$$ Please help : Use of Criteria & Rule1-2

Hello Expert, I've studied Attendance register made by Santosh. I have not understood how excel is using criteria2, criteria3 etc & Rule 1 & 2. I've tried to find same in excel function list to read help but I've not found. Please advice or share syntax. Please share good book for excel 2007 fo

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

Many many thanks for this On Tue, Jun 19, 2012 at 6:39 PM, CoRe wrote: > Hello Pankaj, > > As far as i know chandoo has greate dashboard templates for free , > > Attached you can find out a few chandoo dashboards , maybe they skipped > your eyes. > > > > > > > On Monday, June 18, 2012 8:3

$$Excel-Macros$$ Re: How to creat digital watch in excel

Hi In workbook code module Paste this : Private Sub Workbook_BeforeClose(Cancel As Boolean) StopIt End Sub Private Sub Workbook_Open() GetStart End Sub in Standart Module paste this: Sub GetStart() Range("A1").Value = Format(Now, "HH:MM:SS") Application.OnTime Now + Tim

$$Excel-Macros$$ Test

-- Thanks & Regards Seraj Alam *+91 989 130 1776* -- FORUM RULES (986+ 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 not get quick attention or may not

$$Excel-Macros$$ How to creat digital watch in excel

Hi, every one..! i'm trying to write a macro to create a digital watch in excel please guide me.. Regards, @Suman Send on the move with Galexy y. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Nee

Re: $$Excel-Macros$$ share Dashboard Examples/Templates

Hello Noorain, That ain't a tutorial , but thanks for sharing On Monday, June 18, 2012 8:47:45 PM UTC+3, NOORAIN ANSARI wrote: > Dear Pankaj, > > Please find attached Dashboard Tutorials, > Hope it will help to you. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www