Re: $$Excel-Macros$$ Urgent Help Required

Hi Deepak, Pls find attached shet with the soultion as per your requirement. Let me know if its find you helpful. Best, Bhupendra Chaudhari On 9/7/2010 10:21 AM, Deepak Pal Singh wrote: Hi Guy's, I've a worksheet containing three columns Serial No, Month and New/CarryForward. I want to get

$$Excel-Macros$$ VBA

Hello All Can anybody suggest me any course or books that will help me to learn VBA. Please help me out. Current role suggest me badly to learn VBA. Any PDF, power point or short courses will do   Thanks and Regards Shashank  --

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

Hi, This code is hiding the ASM sheet, which is then can not be un-hide by a user by menu commands unless the user goes for VBA option. This is why code syntax says veryhidden. :) Best Regards, DILHPandey On 9/7/10, Vamsi Tatipamula wrote: > Dear Dilip, > > That explains a lot. > > I didn't un

$$Excel-Macros$$ Urgent Help Required

Hi Guy's, I've a worksheet containing three columns Serial No, Month and New/CarryForward. I want to get count of New & Carry Forward on Monthly basis using an excel formula not by pivot table, I've tried to done it using COUNTIF but couldn't get success. Please Help Thanks Deepak Kumar -- ---

Re: $$Excel-Macros$$ Need Solution

Dear , Please Check the attachment. On Tue, Sep 7, 2010 at 9:19 AM, Dave Bonallack wrote: > Hi, > This seems to be a straight-forward job for SUMIF or SUMPRODUCT. > SUMIF is well explained in the help. > Let me know if you need more help, or if I have mis-interpreted your needs. > Regards - Dave.

Re: $$Excel-Macros$$ Need Solution

Hi, Please ignore the previous email. Find attached this sheet with right solution. Best, Bhupendra Chaudhari On 9/7/2010 9:19 AM, Dave Bonallack wrote: Hi, This seems to be a straight-forward job for SUMIF or SUMPRODUCT. SUMIF is well explained in the help. Let me know if you need more hel

Re: $$Excel-Macros$$ Need Solution

Hi, Yes using SUMIF is the right choice. Please find attached solution with using SUMIF. Please let me know how you go with this. Thanks, Bhupendra On 9/7/2010 9:19 AM, Dave Bonallack wrote: Hi, This seems to be a straight-forward job for SUMIF or SUMPRODUCT. SUMIF is well explained in the

Re: $$Excel-Macros$$ Need Solution

Hi Mohamed Idhrees. S. , Please find the attached file. On Tue, Sep 7, 2010 at 12:49 AM, Idhrees Mohamed wrote: > Dear Guys > > I have two column, job no & value. In this i need particular job no with > the total value in serial wise. Can anybody help me. (I attach sample file). > > Thanks in Adv

Re: $$Excel-Macros$$ Need Solution

see if this helps you regards ashish koul akoul.blogspot.com On Tue, Sep 7, 2010 at 12:49 AM, Idhrees Mohamed wrote: > Dear Guys > > I have two column, job no & value. In this i need particular job no with > the total value in serial wise. Can anybody help me. (I attach sample file). > > Thanks

Re: $$Excel-Macros$$ Examine data in rows and move some to columns

check the attachment see if it helps you.. Regards Ashish koul akoul.blogspot.com On Tue, Sep 7, 2010 at 4:26 AM, Bad at VBA wrote: > Hi everyone, > > I've got data that shows build information vertically in rows down a > column, but my users would prefer to see some of it going across a > r

Re: $$Excel-Macros$$ Need Solution

That's precisely what the =SUMIF() formula is for. Digit =SUMIF( and press for help to see how it's used. It's very simple. On Mon, Sep 6, 2010 at 4:19 PM, Idhrees Mohamed wrote: > Dear Guys > > I have two column, job no & value. In this i need particular job no with > the total value in serial w

RE: $$Excel-Macros$$ Need Solution

Hi, This seems to be a straight-forward job for SUMIF or SUMPRODUCT. SUMIF is well explained in the help. Let me know if you need more help, or if I have mis-interpreted your needs. Regards - Dave. Date: Mon, 6 Sep 2010 23:19:21 +0400 Subject: $$Excel-Macros$$ Need Solution From: idhrees..

$$Excel-Macros$$ Examine data in rows and move some to columns

Hi everyone, I've got data that shows build information vertically in rows down a column, but my users would prefer to see some of it going across a row. Basically, if you see the same value in Column A repeated, then each of the associated values in Column B were used to build that Column A widg

$$Excel-Macros$$ Need Solution

Dear Guys I have two column, job no & value. In this i need particular job no with the total value in serial wise. Can anybody help me. (I attach sample file). Thanks in Advance. -- Thanks & Regards, Mohamed Idhrees. S. --

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

Hi Vamsi, Sure.. below is explanation:- Requirements were to unprotect and unhide a worksheet only if a user enters correct password to do the same. What I have done I have instructed Excel to hide that side while opening (Worksheet Open Event) and given a button for a user to click if he/she wa

Re: $$Excel-Macros$$ VBA for downloading a file

Follow this link, This can help you. http://blog.invisibledenizen.org/2008/11/vba-function-to-download-files.html On Mon, Sep 6, 2010 at 11:57 AM, kush sharma wrote: > > > is there any VBA for downloading a particular file from a website and > downloading it at a specified location?? if anyon

Re: $$Excel-Macros$$ Date series

Hi All, Really nice logics. Keep the good work. Regards, Deepak 2010/9/6 सुधीर इंगळे > Dear Kalyan > Kindly check the attach file > I think it solve your query > > Regards, > Sudhir Ingale > > > On Mon, Sep 6, 2010 at 8:47 AM, Kal xcel wrote: > >> Dear experts, >> >> I am sending a file w

$$Excel-Macros$$ VBA for downloading a file

is there any VBA for downloading a particular file from a website and downloading it at a specified location?? if anyone can just explain it through a simple example, I'd be glad. -- * Regards Kushlesh Sharma * -- * Regards Kushlesh Sharma Research Analyst Swastika Investmart Limited Email:

Re: $$Excel-Macros$$ Date series

Hi Kalyan, Please find the attached solved file. Hope this will help. Regards, Deepak On Mon, Sep 6, 2010 at 1:17 PM, Kal xcel wrote: > Dear experts, > > I am sending a file where I need to show a series of dates after giving > start date & end date. > > File is attached . > > Thanks in advance

Re: $$Excel-Macros$$ Date series

Dear Kalyan Kindly check the attach file I think it solve your query Regards, Sudhir Ingale On Mon, Sep 6, 2010 at 8:47 AM, Kal xcel wrote: > Dear experts, > > I am sending a file where I need to show a series of dates after giving > start date & end date. > > File is attached . > > Thanks in

Re: $$Excel-Macros$$ Conditional Formating

Hi Pankaj, On internet you can find lots of learning stuffs on conditional formatting with good examples. On you tube as well there are some good video's on conditional formatting. Hope this will help. Regards, Deepak On Mon, Sep 6, 2010 at 12:43 PM, C.G.Kumar wrote: > Follow the link; > > > 1.

Re: $$Excel-Macros$$ Date series

or if we want result as a number (not a date type) Array Formula =DAY(TRANSPOSE(ROW(INDIRECT(B3&":"&C3 On Mon, Sep 6, 2010 at 2:47 PM, Kal xcel wrote: > Dear experts, > > I am sending a file where I need to show a series of dates after giving > start date & end date. > > File is attached .

Re: $$Excel-Macros$$ Date series

Array Formula =TRANSPOSE(ROW(INDIRECT(B3&":"&C3))) On Mon, Sep 6, 2010 at 2:47 PM, Kal xcel wrote: > Dear experts, > > I am sending a file where I need to show a series of dates after giving > start date & end date. > > File is attached . > > Thanks in advance. > > Kalyan > > > -- ---

$$Excel-Macros$$ Date series

Dear experts, I am sending a file where I need to show a series of dates after giving start date & end date. File is attached . Thanks in advance. Kalyan -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ Conditional Formating

Follow the link; 1.http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html 2. http://www.free-training-tutorial.com/conditional-formatting.html On Mon, Sep 6, 2010 at 8:36 AM, Pankaj Kumar wrote: > Hi all, > > i am new in msexce

Re: $$Excel-Macros$$ extract only product name

ANDY, Could you please explain the use of "^^" in the formula. Thanks & Regards, C.G.Kumar On Wed, Sep 1, 2010 at 5:53 PM, Aindril De wrote: > Hi Kalyan, > > You can use the following formula in the cell B2 and then copy it down > > =LEFT(A2,LEN(A2)-(LEN(A2)-FIND("^^",SUBSTITUTE(A2," ","^^

Re: $$Excel-Macros$$ Insert work sheet and rename when insert.

The code will surely insert sheets after the last sheet in the workbook, but what if we want to insert sheets before any particular sheet ? let's say before active sheet or the fourth sheet. What should be written instead of Sheets.Add after:=Sheets(Sheets.Count) ??? On Sep 4, 12:40 pm, siti Vi w

Re: $$Excel-Macros$$ Conditional Formating

Hi Pankaj, In Excel if you go to conditional Formatting, you can find lot of options. A conditional Formatting is like this for example, If a student scores less than 30 marks he is fail and he scores more than 30 he is pass. Conditional Formatting is like either this or that. If you didnt underst

Re: $$Excel-Macros$$ Top Poster of the month :- Dave Bonallack

Hi dave, Congratulation Dave, Keep this type of mentality for ever. Thanks Kalyan On Fri, Sep 3, 2010 at 10:31 AM, Ayush wrote: > Hi Group, > > I am glad to announce that Dave Bonallack has topped in posting for > the month of Aug'10 with 67 Posts (9% of group posts). He has done it > repeti