$$Excel-Macros$$ Top ten distributor

Dear experts, I have SAP sales data, how to get top 10 distributor frm that huge data. One distributor billed many times. Is there any mechanism?? Thanks in advance Kalyan -- -- Some important links for excel users

$$Excel-Macros$$ VBA is disabled in a Shared Workbook in Excel 2010

Hi there. I have a shared work book which contains VBA. We have always run it in 2003. Recently, we leapfrogged 2007 and went to 2010. It seems that in shared mode, the VBA is disabled. When I remove shared mode, the VBA comes alive again. Is there a setting to correct this behaviour or is this

$$Excel-Macros$$ Macro for Mail check

Hello All , First request and bit urgent. Request : When I send a mail , Outlook should search list of words which are stored in backend. If found , it gives me popup with list of words which are identified in Mail , once I confirm than mail is sent to recipient. Macro should not only search i

Re: $$Excel-Macros$$ macro or similar

Hey, Dont post vague queries and clog our mail box, BE specific and attach a sample file... Please read the mail sent by Paul regarding Good Group Etiquettes.. Thanks Vinod On Mon, Aug 16, 2010 at 3:47 AM, caffe Trieste wrote: > How i cam make some macro for using example 60 days one e

$$Excel-Macros$$ Combine NETWORKDAYS and IF functions

I currently use an IF formula (see below) to track total time to resolve an issue. Sometimes, the issues are placed in a Pending status so there is a need to use the IF function. I need the current formula below to use NETWORKDAYS to calculate issues between 7AM and 6PM Monday-Friday. Please help

$$Excel-Macros$$ Fwd: Urgent Requirement: Excel VBA with Mini Tab

Hi, Reply to Mr. Lalit Sharma (lalit.sha...@xentaqsys.com) for all information. Will be better if you send your resume. Thanks & Regards Sandeep -- Forwarded message -- From: Lalit Sharma Date: Mon, Aug 16, 2010 at 11:41 AM Subject: Urgent Requirement: Excel VBA with Mini Tab T

Re: Fwd: $$Excel-Macros$$ help required

I've made a couple of modifications. This actually should work for both files. Please note that I created a new variable: Col_Data also changed the range that is replaced to: Columns("B:C").Select '== Please keep in mind that many of the members of grou

RE: $$Excel-Macros$$ Help needed in changing this code

Hi Alex, Have a look at the attached. I have assumed by the syntax of your original code that you are useing XL2007, so I've used that too. One sheet does what you want by macro, while the second sheet does it with coditional formatting. The second sheet has the advantage of being active, in

Re: $$Excel-Macros$$ Fwd: Require A Macro To Compile Data From Different Files

If you check in the archives for this group, there are several previous examples of doing PART of what you ask. However,  your question is missing WAY too much for us to be very helpful. What version of Excel are you using? Do you know anything about VBA programming? what does your data look lik

Re: REMINDER !! $$Excel-Macros$$ Problem in Macro

It could be because you're not following good group etiquette? #1) your title should describe your problem. Otherwise all of the "problem in macro", "help required", "urgent please help" questions all look the same. I get over 100 emails a day, if 20 of them say "Problem in Macro", I assume that

$$Excel-Macros$$ macro or similar

How i cam make some macro for using example 60 days one excel page? thank you -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join o

RE: $$Excel-Macros$$ Re: Help needed in changing this code

Absolutely perfect mate :P may thanks Alex cargill -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Kishan Reddy, K Sent: 16 August 2010 08:13 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Help needed in changing this c

Re: $$Excel-Macros$$ Re: How to open WK1 formated file with Excel 2007

I think what you're saying is that he should find a machine that still has Excel2003 and open all of his WK1 files and save them as XLS... If he needs help writing a macro to find all of his WK1 files, open them and save them as WKS, he should let us know. Paul

$$Excel-Macros$$ Re: How to open WK1 formated file with Excel 2007

Just save it as (using save as) excel file. Then you can open it in Excel 2007. Regards, Kishan Reddy, K On Aug 13, 1:48 pm, harris a wrote: > Hello, > > I am not able to open lotus formatted files (with extension WK1) using > Excel 2007. However, I am able to open it with Excel 2003. Please >

$$Excel-Macros$$ Re: Help needed in changing this code

Just Try this code. Dim CELL As Variant Range("B2:B105").Select For Each CELL In Selection If IsEmpty(CELL) Then With CELL.Offset(0, -1).Interior .ColorIndex = 3 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With Else With C

$$Excel-Macros$$ Fwd: Require A Macro To Compile Data From Different Files

Hey Noone is interested to solve this query..!! :-( -- Forwarded message -- From: Deepak Pal Singh Date: Tue, Aug 10, 2010 at 2:18 PM Subject: Require A Macro To Compile Data From Different Files To: excel-macros@googlegroups.com Hi All, I'm looking your help to develop a code