Dear Experts,
Kindly see the attached sheet.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be
Hi,
Here with attached My data file i need help for Opening balance &
Closing balance copy to My Report Sheet, OPData sheet having Opening
balance & Closing balance , My report Report sheet having opeing balance
and Closing balance which marked yelow colour & Green colour, day wise it
cop
Dear Neeraj
Try below one :
=INDEX(D$2:D$13,MATCH(I2,C$2:C$13),MATCH(H2,B$2:B$13,0))
just change the date format by right click-format-date
On Fri, Feb 10, 2012 at 2:09 PM, Neeraj Chauhan
wrote:
> Dear Experts,
>
> ** **
>
> Kindly see the attached sheet.
>
> --
> FORUM RULES (986+ me
Dear Neeraj,
Please use..
=LOOKUP(2,1/(($B$2:$B$13=H2)*($C$2:$C$13=I2)),$D$2:$D$13)
See attached sheet.
On Fri, Feb 10, 2012 at 2:09 PM, Neeraj Chauhan
wrote:
> Dear Experts,
>
> ** **
>
> Kindly see the attached sheet.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
Dear Neeraj,
You can also use..
=SUMPRODUCT(($B$2:$B$13=H2)*($C$2:$C$13=I2)*($D$2:$D$13))
On Fri, Feb 10, 2012 at 2:38 PM, NOORAIN ANSARI wrote:
> Dear Neeraj,
>
> Please use..
>
> =LOOKUP(2,1/(($B$2:$B$13=H2)*($C$2:$C$13=I2)),$D$2:$D$13)
>
> See attached sheet.
>
> On Fri, Feb 10, 2012 at 2
Press CSE
=INDEX($D$2:$D$13,MATCH(1,($B$2:$B$13=H8)*($C$2:$C$13=I8),0))
On Fri, Feb 10, 2012 at 2:38 PM, PrIyAnKa wrote:
> Dear Neeraj
>
> Try below one :
>
> =INDEX(D$2:D$13,MATCH(I2,C$2:C$13),MATCH(H2,B$2:B$13,0))
>
> just change the date format by right click-format-date
>
>
> On Fri, Feb 1
Dear Group member,
Plz see the attached file, I have a workbook (sheet1) that have some raw date,
I want to arrange as my requirement like sheet2.
Is that any VBA code or formula for this.
Regards
LAKSHMAN
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thre
hi Noorain,
can you help me on this
Regards
chandru
On Fri, Feb 10, 2012 at 2:24 PM, chandra sekaran wrote:
> Hi,
>
> Here with attached My data file i need help for Opening balance &
> Closing balance copy to My Report Sheet, OPData sheet having Opening
> balance & Closing balance , M
Dear Group
How to find Highest no with colour How its possible ,any formula..
--
Normal data:
A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 393
Req Data:-
A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386
*Thanks&Regards*
* *
* **Veerendr
DO u need Highest one among the column or row?
and how 48 comes highest in E column ,kindly let us know
On Fri, Feb 10, 2012 at 4:51 PM, Veeru TOC wrote:
>
> Dear Group
>
>
> How to find Highest no with colour How its possible ,any
> formula..
> --
>
> Normal data:
>
> A B C D E F T
Sorry . i need Column
Normal data:
A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 .
req data:-
A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386
req Dat:-
On Fri, Feb 10, 2012 at 5:01 PM, PrIyAnKa wrote:
> DO u need Highest one among the column
m waiting
From: Lakshman Prasad
To: "excel-macros@googlegroups.com"
Cc: "excelexpertsc...@yahoogroups.com"
Sent: Friday, 10 February 2012 3:01 PM
Subject: $$Excel-Macros$$ formula for this
Dear Group member,
Plz see the attached file, I have a workbook (s
-- Dear Team
In my excel sheet i have below type of data i need Highest no with
Colour , pls send VBA Code
Normal data:
A
B
C
D
E
F
Total
10
18
25
26
*48*
70
197
25
48
96
48
91
78
386
.
req data:-
A
B
C
D
E
F
Total
10
18
25
26
*48*
70
Divide from lac =165221/10 (1.65221)
From: Ashish Bhalara
To: excel-macros@googlegroups.com
Sent: Friday, 10 February 2012 5:34 PM
Subject: $$Excel-Macros$$ Transfer number in unit Rs.Lacs
Dear expert,
I require the macro to transfer the number in unit
U require by Row so go to Conditional formatting on Home tab with selecting
one row then go to TOp/Bottom Rules and click on TOp 10 items ,give value
of one and press ok
On Fri, Feb 10, 2012 at 5:07 PM, Veeru TOC wrote:
>
>
> Sorry . i need Column
>
>
> Normal data:
>
> A B C D E F Tota
Dear Veeru,
Use it
=A$2=MAX($A$2:$F$2)
=A$3=MAX($A$3:$F$3)
See attached sheet.
On Fri, Feb 10, 2012 at 5:07 PM, Veeru TOC wrote:
>
>
> Sorry . i need Column
>
>
> Normal data:
>
>A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386.
>
>
> req data:-
>
>A B C D E F To
Dear Sir,
I can't understand it,,,
in my excel sheet i have 1200 columns data there,suggest any vba code for
this highest no with colour
On Fri, Feb 10, 2012 at 5:50 PM, NOORAIN ANSARI wrote:
> Dear Veeru,
>
> Use it
> =A$2=MAX($A$2:$F$2)
> =A$3=MAX($A$3:$F$3)
>
> See attached s
The splitting of data in to columns based on fixed lengths will not work if
the name on the left has more characters than 30. So fixing the length will
cause undesired result.
You could use a few lines for the cleaning though
Columns("b:c").Replace Chr(32), " "
Columns("b:c").Replace Chr(160), ""
This does exactly what you need
http://www.ozgrid.com/forum/showthread.php?t=144212
Regards,
Sam Mathai Chacko
On Fri, Feb 10, 2012 at 5:45 PM, Lakshman Prasad wrote:
> Divide from lac =165221/10 (1.65221)**
>
>
> *From:* Ashish Bhalara
> *To:* excel-macros@googlegroups.com
> *Sent
With a formula. In the report sheet use match to find the date and then index
‘=INDEX(OPData!$A$1:$AH$8,8,MATCH(G$1,OPData!$3:$3)+2)
This finds the closing debit grand total for 5 april
Don Guillett
SalesAid Software
dguille...@gmail.com
From: chandra sekaran
Sent: Friday, February 10, 2012
I don’t have 2000 but would think you would have to develop in 2000 and hope
the later versions can use it. OR, UPGRADE.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Darwin Chan
Sent: Friday, February 10, 2012 3:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Excel version_
How is color applied, manually___ or CF
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Veeru TOC
Sent: Friday, February 10, 2012 6:13 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Highest No with Colour, Need Vba Code
-- Dear
Hello, does anyone know how to add subtotals once my code has run a
"sum" for both the Par Value and a "sumproduct" for the coupon rate?
I have a code that gathers the data i need but i can't figure out this
last part.
https://www.box.net/shared/0fknh9819pk9t8m7jxz9
Here is the file i'm trying t
@Noorain,
Let me study the chart first. Thanks a lot!
@Don,
The fact is the excel version at my workplace is 2000, i have no choice.
Thanks anyway~
2012/2/10 dguillett1
> I don’t have 2000 but would think you would have to develop in 2000 and
> hope the later versions can use it. OR, UPGRAD
Or,
‘==
Option Explicit
Sub findtotalsSAS()
Dim c As Range
Dim firstaddress As String
With Sheets("sheet1").Range("f1:f150")
Set c = .Find("LedgerTotal", LookIn:=xlValues)
If Not c Is Nothing Then
firstaddress = c.Address
Do
‘MsgBox c.Offset(, 6)
Shee
Thanks Don,
I did try that before but is it possible to get a "sumproduct" formula
under the market value?
Matt
On Feb 10, 10:09 am, "dguillett1" wrote:
> Why not let excel do the heavy lifting using subtotals. See attached in
> SalesAidSoftware module
>
> Don Guillett
> SalesAid Software
> dgu
See changes where sumproduct formula is evaluated
I am available for excel projects .
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Monizri
Sent: Friday, February 10, 2012 9:21 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Insert a row and s
Hi Group,
Could anyone please share some tutorials for the "Series"and "Justify"
features in the Fill dropdown of Excel 2010. Thanks in advance.
Rohan.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urge
Hi,
Can you please give any code or anything which will replace
Application.CalculateFull.
when i use above code this calculates all the Open workbooks whereas i want to
calculate only the Activeworkbook.
i have tried below code but its not reliable as it does not calculate EVERYTIME.
Publi
Hi,
Can somebody please tell me what is the difference between VSTO and VBA.
I have heard VBA has left short life after Office 2010 is released.
Can somebody please explain how much is the truth or what are the chances and
etc, etc
--
FORUM RULES (986+ members already BANNED for viola
try
Application.Calculation = xlManual
sheets.select
for i=1 to sheets.count
activesheet.calculate
next i
Don Guillett
SalesAid Software
dguille...@gmail.com
From: hanumant shinde
Sent: Friday, February 10, 2012 11:08 AM
To: Excel Group
Subject: $$Excel-Macros$$ Replacement for Application.
Let’s get a bit of clarification..
You want to list in delisted!b516 the codes. 3 shown now. Then you want all
hits for each of the 3 codes.
Do you want to further restrict by reference in c5:c16 or is that meaningless
like the dates in d516
Don Guillett
SalesAid Software
dguille...@gmail.com
Hi Don,
Yes, my english is not up to speed so I'll clarify.
In delisted tab I'd like to input manualy code b5:b16 - correct
then I'd like to hits for each of them - correct
C5:C16 and D5:D16 not inportant - correct
Thank you "the greatest Don" :)
Pawel
yes - you are the one
thanks again "the greatest Don"
Pawel
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Friday, February 10, 2012 7:16 PM
Subject: Re: $$Excel-Macros$$ explosion maco needed pls
If you want what I said in the 1st reply, this wi
you are the greatest from the greatest :)
thanks
Pawel
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Friday, February 10, 2012 7:34 PM
Subject: Re: $$Excel-Macros$$ explosion maco needed pls
Even better to let you make a list from what’s availab
Aw shucks.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Friday, February 10, 2012 1:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ explosion maco needed pls
you are the greatest from the greatest :)
thanks
Pawel
From: dguillett1
To:
I have two pivot tables with the same underlying data set but show
different views to the user. I need help synchronizing the 2 Pivot
tables with one report filter.
Thanks in advance for your Help !
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread title
Hello Sir,
Is it possible while we entering the date in the sheet system alert us that
the name or number or text already in the sheet but not limit the entry of
the data, if yes let me know how can we do it and is it possible to imply
the rule in few rows not in all the rows.
thanks & regards
raje
it is very useful
thank you
Thanks & Best regards
Abdel Rahman Gomaa
Night Auditor
B & G Hotels And Resorts
Calimera Habiba Beach
Marsa Alam
Email: income.habibama...@balbaagroup.com
Web Site : www.balbaagroup.com
Tel : 010-09799117
Tel : 065-3380105 - 110
Fax : 065-3380124
On 10 February 2012
Please find the attached solved sheet
Thanks,
Nayeem
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Neeraj Chauhan
Sent: Friday, February 10, 2012 1:39 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Proble
Team,
I have master file having 10 sheets.
1st sheet having summarize data (populated using formulas) of other 9
sheets and these 9 sheets contains data from 6 different files (3
files having two tabs each) and this is daily process.
Need VBA code through which I can load those files with single
Dear Excel Expert,
I am a ardent follower of this group and I have seen that some one has posted
in this forum a Add in to compare two worksheet.
May I request the expert to repost the add in again.
Thanking You,
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ membe
Thanx David
From: David Grugeon
To: excel-macros@googlegroups.com
Sent: Friday, 10 February 2012 6:28 PM
Subject: Re: $$Excel-Macros$$ formula for this
Try the attached
On 10 February 2012 21:50, Lakshman Prasad wrote:
m waiting
>
>
>
>From: Laks
Hi ,,
Please share your workbook.Thanks
On Sat, Feb 11, 2012 at 2:15 AM, Mayank wrote:
> Team,
>
> I have master file having 10 sheets.
> 1st sheet having summarize data (populated using formulas) of other 9
> sheets and these 9 sheets contains data from 6 different files (3
> files having tw
Hi
Question asked in interview
i have nearly 30 pivot tablein 30 sheets i need to enter
data in master sheetat a time i need to refresh alll the pivot table...
how to link the pivot table... Please help me.i dont have any
workbook.. question asked in intervth
Hello Mayank,
You can save an Excel Workspace that will load all your related spreadsheets
together.
Ø To create a Workspace:
1. Open all your spreadsheets
2. Arrange the windows as you like (the arrangement will be saved, too)
3. Save the Workspace:
a. in Excel 2007/2010, Go to RIBBO
*If source data is same for all pivots, refresh anyone of the pivot. other
pivots too get refreshed.*
On Sat, Feb 11, 2012 at 9:41 AM, vijayajith VA wrote:
> Hi
>
>
> Question asked in interview
>
> i have nearly 30 pivot tablein 30 sheets i need to enter
> data in master shee
thanks Mate
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Friday, February 10, 2012 8:07 PM
Subject: Re: $$Excel-Macros$$ explosion maco needed pls
Aw shucks.
Don
Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Fri
HI Maries
They told me to write a program.. to refresh all the pivot tables at a
time.
i need a code to refresh all the pivottables.
Thanks
On Sat, Feb 11, 2012 at 11:59 AM, Maries wrote:
> *If source data is same for all pivots, refresh anyone of the pivot.
> other pivots too get refreshed
49 matches
Mail list logo