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:
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,
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
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
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
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/
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
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
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
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
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
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
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
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
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
15 matches
Mail list logo