Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

Hi Ankur, Thanks for the books. Can you give me some tips about how i can learn this programming quickly? Regards, Chethan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Web query return with no data....

http://www.crisil.com/credit-ratings-risk-assessment/outstanding-ratings-list.jsp?qry=S this is the link from where i want to import the data On Jan 31, 11:14 pm, Dilip Pandey wrote: > Dear Saurabh, > > Just a little explanation on this:- > If you have a database, suppose MS Access Database havi

Re: $$Excel-Macros$$ Web query return with no data....

http://www.crisil.com/credit-ratings-risk-assessment/outstanding-ratings-list.jsp?qry=S this is the link from where i want to import the data On Jan 31, 7:34 pm, mahesh parab wrote: > Hi > > Can you send link of website & the data which want to import. > > On 1/30/10, saurabhn wrote: > > > > >

$$Excel-Macros$$ Copy and Paste calles after RefreshAll not working

I have two sheets, sheet1 and sheet2. Sheet1 is a report template, Sheet2 has some cell references at the top to the SQL queries in the bottom. Here's what I have in my vba code. Step 1 - Application.RefreshAll Step 2 - Copy referenced cell values on Sheet2 Step 3 - Paste on Sheet1 My problem:

RE: $$Excel-Macros$$ Grouping and average price calculation

Because you selected the entire columns as your source data instead of ending at the bottom row of your source data. From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of San Pat Sent: Sunday, January 31, 2010 3:23 AM To: ayush jain; excel-macros Subject: Re:

Re: $$Excel-Macros$$ counting number of people who are on shift

Hi Sabby, You can accomplish this taks with some nested Excel functions. Please provide a test scenario in a spreadsheet for the group to help you better. Try including all / most of the complex scenarios to get them covered in the soution. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hon

Re: $$Excel-Macros$$ Web query return with no data....

Dear Saurabh, Just a little explanation on this:- If you have a database, suppose MS Access Database having sales details of Mon to Fri and you used to query this database from a query (may be Microsoft Query or SQL etc) and someday you quered this database for Sat or Sun data, then you might get

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

Dear Ankur, Would you mind uploading those books in the "Files" section of the group. This will help lots of users. Connect to manager / admin of the group for necessary help and support. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com d

Re: $$Excel-Macros$$ Copy Excel Data from sheet and fill in already opened internetexplorer and submit and repeat for 10 similar postings

Dear Alok, I am wondering if jitbit is something similar to workspace macro. Can you explain little bit about it? Thanks for your time. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 1/3

Re: $$Excel-Macros$$ Help!!!!!!!!!!!!!

Dear Gopi, I am little confused per below points:- 1) Do you want if a user enters the data which is there in Column B, in any of their respective locations , then to print the keywords as given by you in column C. For example, if a user enters any of the following in Cell B3 to B7, then print

Re: $$Excel-Macros$$ Pivot table output to pdf with multiple page fields

Dear TheoMa, one suggestion here:- Install Adobe Acrobat professional and then you can convert the each page output as PDF in a single click. Let me know if other information is required on this line. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan

Re: $$Excel-Macros$$ Auto Replace Hyperlink

Dear Sandip, Attached is the customised solution as per your requirement(s). Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 1/31/10, San Pat wrote: > > Hi Friends, > > I have a excel file

Re: $$Excel-Macros$$ Auto Filter using Macro or Formula

Dear Sandip, Please share your file. If the size is huge, kindly zip it before sending. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 1/31/10, San Pat wrote: > > Hi Dilip, > > T

Re: $$Excel-Macros$$ Web query return with no data....

Hi Can you send link of website & the data which want to import. On 1/30/10, saurabhn wrote: > > While importing data from 1 site > got msg like dis > > > This Web query returned no data. To modify the query, click OK, click > the name of the external data range in the name box on the formula >

$$Excel-Macros$$ counting number of people who are on shift

Hello all I have 20 people all working different hours, i can work out what one person is working on shift using C5 07:30 D5 15:30 then having a range going down B46 07:30 all the way to B77 23:00 using =(IF(AND($C$5<=$B46,$D$5>=$B46),1,0)) This works for one person how can i make this simple a

$$Excel-Macros$$ Auto Replace Hyperlink

Hi Friends, I have a excel file. Which has several URLs, user can select it using the pull down list (Cell C2). I have linked the website link to cells (B4:B10) but I dont know how to auto replace the *[RESEARCHSYMBOL]

Re: $$Excel-Macros$$ Auto Filter using Macro or Formula

Hi Dilip, Thanks for your help. But when I tried to use pivot table for my original file, it is not working. Because of its limitation. Regards, Sandip On Sat, Jan 30, 2010 at 11:09 AM, Dilip Pandey wrote: > Dear Sandip, > > The format which you desire can be obtained by a simple pivot table

Re: $$Excel-Macros$$ Condition macro - please solve

Dear TAIgo, Attached workbook has the scenario mentioned by you alongwith the required macro. Let me know in case of any query. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/25/10, TAlgo

Re: $$Excel-Macros$$ Single Cell Text Manipulation

Hi Steve, In order to get those results in rows, copy them-> Paste Special -> Transpose and all the results would be pasted in rows. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/25/10, ne