RE: $$Excel-Macros$$ plz, help me to drive out this sort of problem!

2012-01-26 Thread Mohammed Muneer
Ya, that's what I want! Thanx, Sam (u r so nice!) Good keep it up! Regards, Muneer, CC.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Thursday, January 26, 2012 3:53 PM To:

$$Excel-Macros$$ learn from basic

2012-01-26 Thread satiqjaffar satiqjaffar
Dear Experts, I would like to learn the excel VBA from basic. Please let me know source from site. Thanks in advance Regards Satiq -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

Re: $$Excel-Macros$$ Import data

2012-01-26 Thread raghu gr
hi, how will u run macro, please elobarate with regards Raghu On Wed, Jan 25, 2012 at 10:53 AM, LearnExcel sendse...@gmail.com wrote: Hi team, i wanted to import data set from two files and consolidate the data into a master file. I need something in VBA, currently i run a marco that goes

Re: $$Excel-Macros$$ Import data

2012-01-26 Thread NOORAIN ANSARI
Dear Raghu, Please use attached sheet vba code as per your requirement. Press Alt+F11 to See Code. On Thu, Jan 26, 2012 at 7:25 PM, raghu gr balaji.bra...@gmail.com wrote: hi, how will u run macro, please elobarate with regards Raghu On Wed, Jan 25, 2012 at 10:53 AM, LearnExcel

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread Sam Mathai Chacko
Use in F3 and drag down and across =SUMPRODUCT((Data!$A$2:$A$37=$E3)*(Data!$B$2:$B$37=Total)*OFFSET(Data!$A$2:$A$37,0,MATCH(Dashboard!F$2,Data!$B$1:$L$1,0))) Regards, Sam Mathai Chacko On Thu, Jan 26, 2012 at 8:48 PM, John A. Smith johnasmit...@gmail.comwrote: Thank you for your valuable

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread NOORAIN ANSARI
Dear John, You can also use in F3... =INDEX(Data!$C$2:$C$37,MATCH(1,(Data!$A$2:$A$37=E3)*(Data!$B$2:$B$37=Total),0)) with ctrl+Shift+enter See attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread dguillett1
Put this in E3copy acrossdown =INDEX(Data!$A$1:$L$37,MATCH($E3,Data!$A:$A),MATCH(F$2,Data!$1:$1,0)) Don Guillett SalesAid Software dguille...@gmail.com From: John A. Smith Sent: Thursday, January 26, 2012 9:18 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need

Re: $$Excel-Macros$$ Import data

2012-01-26 Thread raghu gr
hi noorain, I mean how Mr.Selva wrote or record the macro to import data set from two files and consolidate the data into a master file. thank you raghu On Thu, Jan 26, 2012 at 7:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Raghu, Please use attached sheet vba code as per

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread Sourabh Salgotra
plz sir explain this formula i have confusion in this. how it can take total values from data sheet. On Thu, Jan 26, 2012 at 10:19 PM, dguillett1 dguille...@gmail.com wrote: Simpler with no CSE '=INDEX(Data!$A$1:$L$37,MATCH($E3,Data!$A:$A),MATCH(F$2,Data!$1:$1,0)) Don Guillett SalesAid

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread John A. Smith
Don, How is it picking up only the Total number? What part of the formula does that? I understand all but that... Thank you. John On Thu, Jan 26, 2012 at 11:49 AM, dguillett1 dguille...@gmail.com wrote: Simpler with no CSE

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread dguillett1
The dates are sorted so the match is looking for the LAST matching date. Look in the help index for MATCH. Don Guillett SalesAid Software dguille...@gmail.com From: John A. Smith Sent: Thursday, January 26, 2012 11:34 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread dguillett1
The dates are sorted so the match is looking for the LAST matching date. Look in the help index for MATCH. Don Guillett SalesAid Software dguille...@gmail.com From: Sourabh Salgotra Sent: Thursday, January 26, 2012 11:04 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need

$$Excel-Macros$$ Data Matrix Macro

2012-01-26 Thread Pehrson, Dave
I have developed a matrix to capture change over time from one production model to another, and now I need to upload into a software package with a format as from To Time WT-628 WT-628 0 WT-628 WT-629 15 WT-628 WT-630 45 (see attached partial example of requested output. The

$$Excel-Macros$$ Fwd: VB Script - looping of files

2012-01-26 Thread yogananda muthaiah
Dear All, Did anyone try this .. Regards Yogananda -- Forwarded message -- From: yogananda muthaiah yogananda.mutha...@gmail.com Date: Wed, Jan 25, 2012 at 10:06 PM Subject: VB Script - looping of files To: excel-macros@googlegroups.com Dear All I have 3 excel path mentioned

$$Excel-Macros$$ Re: Need help in building pivot using vba

2012-01-26 Thread rekha siri
Need pivot macro assistance.. On Wed, Jan 18, 2012 at 9:59 PM, rekha siri rekha.siri2...@gmail.comwrote: hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare