Re: $$Excel-Macros$$ copy data without opening file

hi hanumant you may find this to be useful http://spreadsheetpage.com/index.php...a_closed_file/ [image: Reply With Quote] Have A Nice Time &

Re: $$Excel-Macros$$ count unique values

*hi * all of these are array formulas The following formulas will return the number of distinct items in the range B2:B11. . The following formula is the longest but most flexible. It will properly count a list that contains a mix of numbers, text strings, and blank cells. =SUM(IF(FREQUENCY(IF

RE: $$Excel-Macros$$ Request for instruction

See the below web site .. http://www.exceluser.com/explore/sumproduct_12.htm From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Tuesday, July 05, 2011 11:18 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Request for instru

Re: $$Excel-Macros$$ Request for instruction

*hi sant ram plz check links below for sumproduct http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ for array formulas http://www.cpearson.com/excel/ArrayFormulas.aspx for substitute http://www.excelitems.com/2010/05/substitute-function.html *Have A Nice Time & Enjoy Life Regards:

Re: $$Excel-Macros$$ need required for data validation value query

*hi rajan thnks for such nice helps ... due to size & sensitive data in file i cant upload them cant be there any vba codes for auto change in data validation list one by one , and the result which came ,get pasted in other sheets.this is what i needed... i just want results get pasted in

Re: $$Excel-Macros$$ count unique values

Nice explanation Haseeb (HTH).. !! Regards, DILIPandey On Tue, Jul 5, 2011 at 12:34 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello AIren, > > Consider B1:B6 we have these values; > > B1=1 > B2=1 > B3=Blank > B4=A > B5=Blank > B6=Blank > > =SUMPRODUCT((B1:B6<>"")/**COUNTIF(B1:B

Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

Hey Ashish, Congrats!, You deserve it On Tue, Jul 5, 2011 at 3:47 AM, bpascal123 wrote: > Ayush, > I wish you well. > Congrats to Ashish! > Pascal > > -- > -- > Some important links for excel users: > 1. Follow us

$$Excel-Macros$$ Job

Recruiter Email: gunjan.chaphe...@careernet.co.in Experience required for the Job: 2 - 6 years Job Location: Bengaluru/Bangalore Dear Candidate, We came across your profile on one of the job portal and found it interesting and prospective for one of our key clients. In further to this, we wou

$$Excel-Macros$$ Job

Recruiter - Email – sunit...@synovaindia.com Experience required for the Job: 4 - 6 years Job Location: Noida Dear Candidate, Hi Urgent requirement for “VB/VBA†with Synova Innovative Technologies Pvt. Ltd for one of our CMML5 Client, for Noida. Skill - “VB/VBA†Location - Noida Educ

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

Hi! siti Vi I tried to download the example workbook but no file found could you send me the file if you can please??? Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

Well, I haven't tried but looks like it's exactly what I want Thanks Million -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Jo

Re: $$Excel-Macros$$ workbook location on status bar

thanx, Venkat solution is most practical for 2007 since it works on all workbooks that work and don't work with vba code. I guess the vba code for this is for Excel 2003? Pascal -- -- Some important links for excel

$$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

Ayush, I wish you well. Congrats to Ashish! Pascal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://

$$Excel-Macros$$ JOB MS Excel Expert (Macro / VBA)

MS Excel Expert (Macro / VBA) 2 Opening(s) Shanti Consultants * * Summary *Experience:* 3 - 6 Years *Location:* Delhi, Delhi/NCR, Noida *Compensation:* Rupees 3,00,000 - 6,00,000 *Education:* UG - B.Sc - Computers,BCA - Computers PG - PG Diploma - Computers *Industry Type:* Oil an

$$Excel-Macros$$ copy data without opening file

Hi friends, is there any way where we can copy data from closed workbook "A" and paste it into workbook "B" which is open? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and link

Re: $$Excel-Macros$$ count unique values

Hello AIren, Consider B1:B6 we have these values; B1=1 B2=1 B3=Blank B4=A B5=Blank B6=Blank =SUMPRODUCT((B1:B6<>"")/COUNTIF(B1:B6,B1:B6&"")) Firstly take (B1:B6<>"") This will check B2:B30 is blank or not, If it is blank will give FALSE, if not will give TRUE. So will get like this {TR

Re: $$Excel-Macros$$ XBRL in Excel

this was exactly what i'm thinking of building. anyone wants to work together on this time-sensitive project then email me at mehul.muk...@gmail.com regards ... mehul On Mon, Jul 4, 2011 at 6:21 PM, tikku wrote: > Dear All, > > Did anybody build a XBRL Creator in Excel to create a Instance > Do

$$Excel-Macros$$ Request for instruction

Hey, please provide the SUMPRODUCT , SUBSTITUTE and ARRAY formula's how to use and instruction -- Regards, Santy C -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ count unique values

Hey, try my attachment i think my formula is very simple so please try Regards, Santy C On Mon, Jul 4, 2011 at 10:13 PM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello, > > If you want to count the unique numbres in a range, use this with just > Enter, *

Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

Hey Boss, Congratulation. On Sun, Jul 3, 2011 at 8:15 PM, ashish koul wrote: > Thank You All.. > > On Sat, Jul 2, 2011 at 10:37 AM, Brajesh Kumar Porwal < > brajeshkumarpor...@gmail.com> wrote: > >> *Congratulations Ashish keep it up

RE: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

Congratulations Ashish, you deserve it. Best regards, Ahmed galal Mohamed Procurement Engineer Head Office : SQUARE Engineering Firm Tel :(202) 2402 8846 Fax :(202) 2405 0476 Mobile :(010) 9 62 60 61 Website : http://www.square.com.eg 31 Lebanon St. Mohandsen, Giza, Egyp

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

Congratulations Ashish...!! you Rock :) Regards, DILIPandey On 7/4/11, Ayush Jain wrote: >> >> Hello Everyone, >> >> Ashish Koul has been selected as 'Most Helpful Member' for the month of >> June'11 >> He has posted 53 posts in June 2011 and helped many people through his >> expertise. He ha

Re: $$Excel-Macros$$ count unique values

Hi Airen, This is the beauty of SumProduct function. Below is the explanation:- If you evaluate the formula in parts, you will get following look: =SUMPRODUCT(({TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;T

$$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

> > Hello Everyone, > > Ashish Koul has been selected as 'Most Helpful Member' for the month of > June'11 > He has posted 53 posts in June 2011 and helped many people through his > expertise. He has been consistent contributor to this excel forum and > achieved this recognition from last seven mon

RE: $$Excel-Macros$$ How Can I Clear Content & Autofill

Excellent ashish, it's work nowthanks a lot Best regards, Ahmed galal Mohamed Procurement Engineer Head Office : SQUARE Engineering Firm Tel :(202) 2402 8846 Fax :(202) 2405 0476 Mobile :(010) 9 62 60 61 Website : http://www.square.com.eg 31 Lebanon St. Mohandsen, Giza,

Re: $$Excel-Macros$$ count unique values

Hello, If you want to count the unique numbres in a range, use this with just Enter, *doesn't require* Control+Shift+Enter. =SUM(SIGN(FREQUENCY(A:A,A:A))) HTH Haseeb -- -- Some important links for excel users:

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

Hi Ashish, Many many congrats... With best wishesh, Seraj Alam On Mon, Jul 4, 2011 at 9:40 PM, Hari wrote: > Thanks for getting the award. Even though, i am very new to this group, > I proudly wishes to keep this spirit high always, > Have a nice day > > with best wishes, > > > Regards, >

Re: $$Excel-Macros$$ How Can I Clear Content & Autofill

try this code- Private Sub Worksheet_Change(ByVal Target As Range) Dim cell As Range Dim abc As Range If Target.Column = 19 Then Set abc = Range("s" & Target.Row & ":s" & Target.Row + Target.Rows.Count) For Each cell In abc Select Case cell.Value Case "A" cell.EntireRow.Interior.Color = RGB(192

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

can you share the workbooks On Mon, Jul 4, 2011 at 9:44 PM, Jorge Marques wrote: > Mmm i checked the range, and everything is ok, even if i open the pivot > workbook and choose the source range again, it gives the same error when i > do refresh data :(, gives #NAME, and also on the list formulas

RE: $$Excel-Macros$$ How Can I Clear Content & Autofill

I'll explain what the problem:-try to pull + for cell to auto fill code like "A" into 3 cells down it will return error, also if u select more than one cell including codes and delete selection contents it returns error also. Date: Mon, 4 Jul 2011 21:27:49 +0530 Subject: Re: $$Excel-Macros$$ H

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

Mmm i checked the range, and everything is ok, even if i open the pivot workbook and choose the source range again, it gives the same error when i do refresh data :(, gives #NAME, and also on the list formulas appears #NAME. 2011/7/4 ashish koul > have you changed name of a name range used in th

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

Thanks for getting the award. Even though, i am very new to this group, I proudly wishes to keep this spirit high always, Have a nice day with best wishes, Regards, Hari On 1 July 2011 21:25, Ayush wrote: > Dear Group, > I am extremely happy to share a good news with you. One of our dearest >

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

Hi Anshul, As per the latest scenario provided by you, attached solution may help you. Let me know if this works :) Regards, DILIPandey On 7/4/11, Anshul Gupta wrote: > Hi All > > No boss this is also not working see i show you what excatly i want > > 202.718 > 198.724 > 200.178 > 202.867 > 195

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

have you changed name of a name range used in the formula On Mon, Jul 4, 2011 at 9:23 PM, Jorge Marques wrote: > Hi guys, i have a pivot table that is feeded through another workbook, > then i calculate the rest of the pivot with the option "Calculated fields" > but i have a problem, each time i

RE: $$Excel-Macros$$ need required for data validation value query

You should attached all Sheets so that I can Link Main Sheet with each other. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Monday, July 04, 2011 2:06 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ How Can I Clear Content & Autofill

try this see if it helps Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 19 And Target.Count = 1 Then Select Case Target.Value Case "A" Target.EntireRow.Interior.Color = RGB(192, 192, 192) Case "B" Target.EntireRow.Interior.Color = RGB(0, 0, 255) Case "C" Target.EntireRo

$$Excel-Macros$$ Help what the hell is wrong with my pivot table?

Hi guys, i have a pivot table that is feeded through another workbook, then i calculate the rest of the pivot with the option "Calculated fields" but i have a problem, each time i open the 2 workbooks and make refresh, my calculated fields disappear leaving "#NAME" in the cells, and i have to do th

RE: $$Excel-Macros$$ need required for data validation value query

Hi ankur Attachment Not Found.. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Monday, July 04, 2011 11:53 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ need required for data validation value quer

RE: $$Excel-Macros$$ Excel VBA for BOM

What help do you need in this macro?? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rash Sent: Monday, July 04, 2011 10:25 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel VBA for BOM Hi, With some more detailed explanation:

Re: $$Excel-Macros$$ Recovery plz

Hi just install the software and just open that software and click Remove Password...Before that you have to open Locked VBA Book.. -- *Best Regards,* *Venkat* * * On Mon, Jul 4, 2011 at 6:32 PM, Chandra Shekar wrote: > How to use this software? > > Thanks, > > Chandra Shekar B > > On Fri, D

RE: $$Excel-Macros$$ Sumif across multiple worksheets

Dilip, I apologize…… after recalculating my sheets I see that it worked J. Thank you to everyone else..for your insights. Appreciate it! Sunnie From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: Monday, July 04, 2011 3:27 AM To: excel-macros@googlegroups.com Cc: sunni..

$$Excel-Macros$$ How Can I Clear Content & Autofill

Hi allI choose a specific Column Such as X Column and when one cell change it's return a value in another cell in another column.now i need to make Auto-fill or Clear Content to act on all row content, plz see the attachment Best regards, Ahmed galal Mohamed Procurement Engineer Hea

Re: $$Excel-Macros$$ count unique values

try it... =sum(1/countif(B2:B30,B2:B30)) and press ctrl+shift+Enter -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Mon, Jul 4, 2011 at 3:47 PM, airen wrote: > Hi, > i want to count unique values in a selection. I got this form

Re: $$Excel-Macros$$ Regarding LME and Commodoties Updation

can you share the link On Mon, Jul 4, 2011 at 12:52 PM, L.K. Modi wrote: > Dear Members, > > with reference to the above dear member i want a excel sheet. Earlier i > have downloaded a sheet that updates automatically bse and nse prices. > Similary is there any way by which when i would run macr

Re: $$Excel-Macros$$ count unique values

try this link http://www.exceltip.com/st/Counting_Unique_Numeric_Values_or_Unique_Data_in_a_List_/818.html Dave has explained it in detail On Mon, Jul 4, 2011 at 6:15 PM, Venkatesan c wrote: > Hi, > > Attach Some data ..and send will try.. > > > *Best Regards,* > *Venkat* > * > * > > > On

Re: $$Excel-Macros$$ querry 5

try this Option Base 1 Sub nemi() Dim s(5) As String Dim z As Long s(1) = "Very Good" s(2) = "Good" s(3) = "Better" s(4) = "Bad" s(5) = "Very Bad" For i = 1 To 5 On Error Resume Next Sheets(1).ShowAllData z = Sheets(1).Range("f65356").End(xlUp).Row + 1 Sheets(1).Range("$A$3:$e$" & Sheets(1).Ra

Re: $$Excel-Macros$$ Sumif across multiple worksheets

No worries Susan... you are always welcome..!! Regards, DILIPandey On 7/4/11, Susan wrote: > Dilip, > > I apologize…… after recalculating my sheets I see that it worked J. > > > > Thank you to everyone else..for your insights. > > > > Appreciate it! > > > > Sunnie > > > > > > > > From: Dilip Pa

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

Hi All No boss this is also not working see i show you what excatly i want 202.718 198.724 200.178 202.867 195.514 Total 1000.000 this is i want that random unique numbers between 195.001 to 203.999 which always gives a total of 1000.000 after every total of 5 numbers Help me guysss

Re: $$Excel-Macros$$ Recovery plz

How to use this software? Thanks, Chandra Shekar B On Fri, Dec 24, 2010 at 11:56 AM, Venkat wrote: > Dear Saijt, > > Find below Link&Download Software &Install,It may Help you... > > http://www.excel-tool.com/vbarecovery.html > > *Best Regards,* > ** > *Venkat CV* > > On Thu, Dec 23, 2010 at 1

$$Excel-Macros$$ XBRL in Excel

Dear All, Did anybody build a XBRL Creator in Excel to create a Instance Documents for MCA filings. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/

Re: $$Excel-Macros$$ count unique values

Hi, Attach Some data ..and send will try.. *Best Regards,* *Venkat* * * On Mon, Jul 4, 2011 at 3:47 PM, airen wrote: > Hi, > i want to count unique values in a selection. I got this formula on > net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont > know how it works. So pl

$$Excel-Macros$$ XBRL in Excel

Dear All, Did anybody build a XBRL Creator in Excel to create a Instance Documents for MCA filings. - Tarun Masani -- Virus Warning: Although our firm has taken reasonable precautions to ensure no viruses are present in this email, the firm cannot accept responsibility for any loss or damage ar

Re: $$Excel-Macros$$ querry 5

hi Nemi Gandhi use this formula in cell F4 of your table and than sort it by column F shortest to largestyou will table as per your need *=IF(E4="Very Good",1,IF(E4="Good",2,IF(E4="Better",3,IF(E4="Bad",4,5* Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'

$$Excel-Macros$$ querry 5

Formula needed please. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http:/

$$Excel-Macros$$ count unique values

Hi, i want to count unique values in a selection. I got this formula on net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont know how it works. So please help me understand this formula. -- -- Some impor

Re: $$Excel-Macros$$ Sumif across multiple worksheets

Hi Susan, The result calculated is 2 which is correct as only two rows, mentioned below, are having the results (i.e., 1) as per your criteria :- row # 5 of sheet1 row #16 of sheet 2 Now, some of our group members have also provided more power packed formulas, using which you can get your query

$$Excel-Macros$$ Regarding LME and Commodoties Updation

Dear Members, with reference to the above dear member i want a excel sheet. Earlier i have downloaded a sheet that updates automatically bse and nse prices. Similary is there any way by which when i would run macro the LME prices and Commodities Prices update automatically. May be its a challengin

Re: $$Excel-Macros$$ need required for data validation value query

Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Mon, Jul 4, 2011 at 12:08 PM, ankur wrote: > file attachedagain forget to attach file > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Diff

Re: $$Excel-Macros$$ Protect : Charts, Shapes & Data

Hi, Please can u expalin in steps how to do this. Thanks! On Tue, Jun 28, 2011 at 9:08 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > Thanks its working fine. Please can u explain in steps how to do this. > > On Mon, Jun 27, 2011 at 6:59 PM, Sam Mathai Chacko > wrote: > >

Re: $$Excel-Macros$$ Excel Pop-ups

Thanks all, it worked. Regards On Sun, Jul 3, 2011 at 11:54 PM, STDEV(i) wrote: > please try: > = > Sub ExpiryWarning() > Dim dTable As Range, t As String >Dim R As Long, N As Long, *I As Date* > >Set dTable = Cells(1).CurrentRegion >N = dTable.Rows.Count > >For R = 2