Re: $$Excel-Macros$$ Formula reqd

thanks a lot for ur help.. With Regards, Akshay Banglore +919916512599 On Tue, Mar 29, 2011 at 10:35 AM, mrinal saha mris...@gmail.com wrote: Hope, this serves the purpose. See attachment regards, Mrinal On Mon, Mar 28, 2011 at 11:35 PM, Akshay akshaya.mal...@gmail.com wrote:

$$Excel-Macros$$ Re: Rolling 4 Quarter Cummulative Revenue

Dear Akash, Pls attach the sample file. So we can help you better. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ Chart formatting

Hi Expert, I wanted the help in charts with VB programming... I wanted to format the waterfall chart with some repeated steps.. I have given the Normal charts and formatted chart for your examples and also given the steps need to perform... Please give me the VBA code for this. Regards,

$$Excel-Macros$$ Auto Refresh data in excel

Hi Expert, Some of my excel sheet has linked with Internet which requires live auto updation, by default I can do 1 min refresh... Could you help me with any VB code where I can do it on live basis and at background excel update the data. Thanks Regards, Anil Bhange IP - 512320 --

$$Excel-Macros$$ multi- excel requrired

Hi Expert, I have two pc with lan connection. I want to type in excel file that text should display in second pc when i press enter key. If it's possible then give me tips.. Thanks Regards, Sajid Memon -- -- Some

$$Excel-Macros$$ how can i add this groups

Dear Member, Can you tell me how can i add this groups of excel and VBA macros can you tell me Regards Manoj -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ for the membership

Dear I want to join your groups so plz suggest me how its possible on this mail id. Regards Manoj -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ How to send mail with excel

Can any one help me? I looking for code to send an email from excel to the number of users, few in TO and some are on CC. I also need to add the below table in the body of the mail looks like the below example _ Hi,

$$Excel-Macros$$ Calculating An Average Score from Multiple Tabs

I have like tabs from different departments and need to summarize an average score by day. But if there were no scores in a particular day, I get #DIV/0!. Please help with the formula that eliminates it. I tries an IFERROR in front of the AVERAGE but got a blank cell. Thank you. John --

Re: $$Excel-Macros$$ Calculating An Average Score from Multiple Tabs

Hi John, change the formula to IFERROR(AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'!B10),) Regards Umesh On Tue, Mar 29, 2011 at 8:22 PM, John A. Smith johnasmit...@gmail.comwrote: I have like tabs from different departments and need to summarize an average score by day. But if there were no

Re: $$Excel-Macros$$ multi- excel requrired

Hi Sajid, Share the workbook and after typing and pressing enter press Cntrl+S to get reflected in both the workbooks. *How to Share A Workbook?* Microsoft Office Excel 2003 and earlier versions of Excel 1. On the *Tools* menu, click *Share Workbook*, and then click the * Editing* tab.

$$Excel-Macros$$ Re: Calculating An Average Score from Multiple Tabs

Try this =IF(ISERROR(AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'! B10)),,AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'!B10)) On Mar 29, 7:52 pm, John A. Smith johnasmit...@gmail.com wrote: I have like tabs from different departments and need to summarize an average score by day.  But if there were

Re: $$Excel-Macros$$ Calculating An Average Score from Multiple Tabs

Thank you very much. It works great. One other question please; I have a column with all formula's and I am looking for the smallest number in it by using =MIN(range). I get 0 (zero) because the formula is =IF(DY9=GONE,,D9). DY9 is an automatic status column that shows GONE if a ship date is

$$Excel-Macros$$ Need formula to determine if combination is valid

Hi all.  Attached is a workbook that contains 2 sheets.  The first is the list that the 2nd sheet will refer to.  I'd like a formula in col C on sheet 2 that looks up each combination and determines if the combination is valid.  Does anyone have any ideas? Thanks. Nadine --

Re: $$Excel-Macros$$ Chart formatting

select the chart and run the macro hope it solves your problem Sub frtchart() Dim x As Chart Set x = ActiveChart x.ChartArea.Format.Line.Visible = msoFalse x.PlotArea.Format.Line.Visible = msoFalse x.Axes(xlValue, xlPrimary).HasMajorGridlines = False x.Axes(xlValue,

Re: $$Excel-Macros$$ Need formula to determine if combination is valid

try this see if it helps IF(VLOOKUP(A2,Sheet1!A:B,2,0)=Sheet2!B2,Valid,Not Valid) On Wed, Mar 30, 2011 at 4:16 AM, None n8dine4ma...@yahoo.com wrote: Hi all. Attached is a workbook that contains 2 sheets. The first is the list that the 2nd sheet will refer to. I'd like a formula in col C

Re: $$Excel-Macros$$ How to send mail with excel

try this addin see if it helps http://www.rondebruin.nl/mail/add-in.htm On Tue, Mar 29, 2011 at 8:02 PM, shariq khan shariqcoo...@gmail.com wrote: Can any one help me? I looking for code to send an email from excel to the number of users, few in TO and some are on CC. I also need

Re: $$Excel-Macros$$ How to send mail with excel

Try these links http://www.rondebruin.nl/mail/folder3/mail4.htm http://www.rondebruin.nl/mail/add-in.htm On Tue, Mar 29, 2011 at 8:02 PM, shariq khan shariqcoo...@gmail.comwrote: Can any one help me? I looking for code to send an email from excel to the number of users, few in TO and

$$Excel-Macros$$ Useful Link ( Excel, Access, Word, Powerpoint ) VBA

Hi all To learn advance access, excel ,word, powerpoint, outlook VBA coding , open the weblink given below http://www.mvps.org/links.html#VisualBasic -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My