Re: $$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-03 Thread Pramod Singh
Hi Bill PFA... On Wed, Sep 3, 2014 at 10:55 AM, Mr_Bill egge...@gmail.com wrote: I appreciate the effort but that doesnt work correctly. On Tuesday, September 2, 2014 8:52:50 PM UTC-7, pramodb35 wrote: Hi Bill Please find the

RE: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation

2014-09-03 Thread Nitin Balodi
Hi Vaibhav, Thanks for the idea. It works. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Mon, 1 Sep 2014 20:27:03 +0530 Subject: Re: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation To: excel-macros@googlegroups.com Hi check this, if you change

Re: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation

2014-09-03 Thread Vaibhav Joshi
Great!! Cheers! On Wed, Sep 3, 2014 at 12:01 PM, Nitin Balodi nitinbal...@live.com wrote: Hi Vaibhav, Thanks for the idea. It works. Regards. Yours Sincerely, *Nitin Balodi* -- From: v...@vabs.in Date: Mon, 1 Sep 2014 20:27:03 +0530 Subject: Re:

Re: $$Excel-Macros$$ gogmap

2014-09-03 Thread Aditya Aditya
Sir, thank you for replying to my email, i already checked this i need my visited places movement on my ppt ( msw course field training) ex: i visited first mumbai than dehli than banglore than bidar etc G H columns contains lat long data other columns are work details which i collected in

Re: $$Excel-Macros$$ Filter

2014-09-03 Thread daya p
sir, not accurate pls with combo box some changed bcoz if any 1 change data in sheet its not correct so i hide that data only want 2 show form is i select india than next combo (state) show all state names than i select 1 state name than it it show its capital with 4 th combo data Country

Re: $$Excel-Macros$$ gogmap

2014-09-03 Thread daya p
Sir, try this one http://www.earthpoint.us/ExcelToKml.aspx On 3 September 2014 13:14, Aditya Aditya adityagalaxy1...@gmail.com wrote: Sir, thank you for replying to my email, i already checked this i need my visited places movement on my ppt ( msw course field training) ex: i visited

Re: $$Excel-Macros$$ Auto filter issue

2014-09-03 Thread Sunil Kumar Yadav
Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when

$$Excel-Macros$$ Web query

2014-09-03 Thread Παναγιώτης Σκούρτης
hi i am new to this forum i have a litle problem to ask for solution i have this macro to search for models from this site but returns to me all the page of the product my question is there something to add in this macro to search a certain div class in this page to return me only the price or

$$Excel-Macros$$ Highlighted rows will be copy and paste in Sheet 2

2014-09-03 Thread Ashu k
Dear Sir, I have Data Table in Sheet 1, I want that, when i highlight rows in sheet 1, these highlighted rows will copy and paste in Sheet 2. Data will be pasted and over lap the data in sheet 2. Example : If I highlight row 1, 5, 8, then these rows was copy from sheet 1 and paste on sheet 2 on

Re: $$Excel-Macros$$ Filter

2014-09-03 Thread Bé Trần Văn
You attempt to 1 again. 2014-09-03 14:57 GMT+07:00 daya p princedaya2...@gmail.com: sir, not accurate pls with combo box some changed bcoz if any 1 change data in sheet its not correct so i hide that data only want 2 show form is i select india than next combo (state) show all state

Re: $$Excel-Macros$$X Copy sand paste dynamic data range

2014-09-03 Thread C.G.Kumar
Thanks for response. All solution provided is considering outlook as default mail client. But my need is diiferent innfollwing way; 1. IBM lotus is my default email. 2. Need to paste filtered data (8 column and many row) as part of email. This will be in addition of body of the message. In

Re: $$Excel-Macros$$ Highlighted rows will be copy and paste in Sheet 2

2014-09-03 Thread Ashish Kumar
Hi Ashu, PFA, Regards Ashish -- 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, like

$$Excel-Macros$$ Assign already open workbooks name to variables using wildcard

2014-09-03 Thread Nitin Balodi
Hi Experts, I require your help in another problem. I have n excel files already opened but want to assign file name to variables like File1 = ForecastLastUpdated_*.xls* File2 = ForecastLastUpdated_ReferenceInformation*.xls* Highlighted in red are file name pattern and will be using these