Re: $$Excel-Macros$$ Help needed - Extract data by customer name

lupinski wrote: > Hi Mate, > > See attachement I've done it in two ways. First by PIVOT TABLE, second by > function. Try if it helps. > > Regards, > Pawel > > > ---------- > *From:* San Pat > *To:* excel-macros > *Sent:* Sat, March 5,

Re: $$Excel-Macros$$ Help needed - Extract data by customer name

e already there, it automatically inserts the new costumer in sheet2 > with same criterias? > > 2011/3/5 San Pat > > Hi Friends, >> >> I have row data in the sheet1, which contains multiple data entries for >> the same customer. >> >> I am trying to extr

$$Excel-Macros$$ Help needed - Extract data by customer name

Hi Friends, I have row data in the sheet1, which contains multiple data entries for the same customer. I am trying to extract each customer data in separate sheet (Extract_Data) and at the same time calculating the average price & sum of the total quantity shipped to the particular customer. Whe

Re: $$Excel-Macros$$ Macro DataMatchError

akesh kumar wrote: > *Here it is,* > * > * > *But wondering how did you manage to write such a huge code ?? My reply > has got a little error I didn't look at your code. Had it changed with > xlpart to xlwhole, it would have been all IS OK. * > > > On Tue, Feb

Re: $$Excel-Macros$$ Macro DataMatchError

> On Tue, Feb 22, 2011 at 9:05 AM, San Pat wrote: > >> Hi >> >> I have a macro with a command button "ClosePosition" in the Sheet >> "OpenPosition" to close my OpenPosition. See the attached file. >> >> It is working fine when I enter

Re: $$Excel-Macros$$ Help needed to extract data by MM/Year

Thanks this is what I was looking for! On Fri, Feb 18, 2011 at 11:36 PM, ashish koul wrote: > > see if it helps > > On Sat, Feb 19, 2011 at 11:13 AM, San Pat wrote: > >> Hi Group, >> >> I need a urgent help to extract data by given MM/Year from a raw data. &g

$$Excel-Macros$$ Help needed to extract data by MM/Year

Hi Group, I need a urgent help to extract data by given MM/Year from a raw data. Basically, I am looking for a macro which will extract data from the raw data for a given MM/Year. See the attached reference sheet. Regards, --

Re: $$Excel-Macros$$ Load image from the url

erForm1.Show > > > End Sub > > > On Tue, Feb 15, 2011 at 11:55 AM, San Pat wrote: > >> How I can load a image from a url using the LoadPicture function in >> userform. >> >> Regards, >> >> -- >> >> ---

$$Excel-Macros$$ Load image from the url

How I can load a image from a url using the LoadPicture function in userform. Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

$$Excel-Macros$$ Display a Comment Picture/Image in user form

Hi All, I am using a excel add-in (SMF-Add In) which can generate a text and/or an image using a *RCHCreateComment function*. I want to use this function and display this image in excel user form. Please provide some suggestion for this. Regards, San -- ---

$$Excel-Macros$$ Extract text from parentheses

Hi All, I am trying to extract a texts from the* parentheses. I have attached the sample file. I want to extract texts from the **parentheses from column A to Column G. Please advice how I can achieve this. Regards, Sandip* -- --

Re: $$Excel-Macros$$ Macro to sort data in Ascending/Descending order

e. Feel free to ask further for any query. > > Regards > Sandeep Kumar > > > > On Wed, Jan 26, 2011 at 10:41 PM, San Pat wrote: > >> Hi Ashish, >> >> Thanks for your help. >> >> Is there any way I can make it cell specific, assign this macro to

Re: $$Excel-Macros$$ Macro to sort data in Ascending/Descending order

f ActiveCell.Column <= 6 Then > Sheets(1).Range("a1:f" & Range("a1").End(xlDown).Row).Sort > key1:=Sheets(1).Range(x & "1"), order1:=xlDescending, Header:=xlYes > > > End If > End Sub > > > > > On Wed, Jan 26, 2011 at 7:52 AM,

$$Excel-Macros$$ Macro to sort data in Ascending/Descending order

Hi All, I am working on a excel with data in many columns. I want to add two macro button on each heading to sort data, one for Ascending sort +and second for Descending sort. Is it possible with macro. I have attached the sample sheet. Please advice if it possible. Regards, San --

$$Excel-Macros$$ How to add Icon sets

Hi Group, I am trying to add icon sets in excel 2007. I want to add a up arrow in the cell for the value >0, down arrow for the value <0 and horizontal line (neutral) for value =0. I tried to implement the above by using the standard formula but could not do it. Please advise how it can be done

$$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$$ Grouping and average price calculation

PM, ayush jain wrote: > Here you go ![?] > > > On Mon, Jan 25, 2010 at 9:41 AM, San Pat wrote: > >> Hi Ayush, >> >> Thanks for your quick response. >> >> I think you forgot to attach the file. >> >> >> >> On Sun, Jan 24, 2010

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

uot;Pivot").PivotTables("PivotTable1").RefreshTable > End Sub > > > Attached is the file with a macro. The pivot will be refresh when > sheet1(Pivot) is selected. > > Please keep group in loop in all your communications. > > Best regards, > Ayush Jain &g

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

better to use a pivot tables than a macro to group the >> information. >> > The pivot tables are linked to raw data and refreshed on a single click. >> > >> > I have created a pivot for you for your requirement. Have a look and let >> us >> > know if

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

Hi Friends, I am exporting stock (Gain/Loss) data from the web which has multiple buys of the same company. Please see the attached excel file (Exported data) Is there any way I can group this same company data using the macro and perform the required calculation. Please see the attached file, wh

Re: $$Excel-Macros$$ Exporting data using Pulldown List

Hi Ankur, This is what I wanted.Thanks for your help! Is it possible that I can convert your formula (B5:N23) in array formula? Regards, Sandip On Thu, Jan 21, 2010 at 11:55 PM, ankur wrote: > HI SANDIP > if you need any other clarification , plz let me know > Have A Nice Time & Enjoy Life >