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
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
copy
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
neerajchauhan...@gmail.comwrote:
Dear Experts,
** **
Kindly see the attached sheet.
--
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
neerajchauhan...@gmail.comwrote:
Dear Experts,
** **
Kindly see the attached sheet.
--
FORUM RULES (986+ members already
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 noorain.ans...@gmail.comwrote:
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,
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 p.dhamsa...@gmail.com 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
hi Noorain,
can you help me on this
Regards
chandru
On Fri, Feb 10, 2012 at 2:24 PM, chandra sekaran duraichan...@gmail.comwrote:
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
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
*ThanksRegards*
* *
*
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 veerub...@gmail.com wrote:
Dear Group
How to find Highest no with colour How its possible ,any
formula..
--
Normal data:
A B
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 p.dhamsa...@gmail.com wrote:
DO u need Highest
m waiting
From: Lakshman Prasad lakshman...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Cc: excelexpertsc...@yahoogroups.com excelexpertsc...@yahoogroups.com
Sent: Friday, 10 February 2012 3:01 PM
Subject: $$Excel-Macros$$ formula
Divide from lac =165221/10 (1.65221)
From: Ashish Bhalara ashishbhalar...@gmail.com
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
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 veerub...@gmail.com wrote:
Sorry . i need Column
Normal data:
A B
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 veerub...@gmail.com 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
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 noorain.ans...@gmail.comwrote:
Dear Veeru,
Use it
=A$2=MAX($A$2:$F$2)
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 lakshman...@yahoo.comwrote:
Divide from lac =165221/10 (1.65221)**
*From:* Ashish Bhalara ashishbhalar...@gmail.com
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 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
--
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 to
@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 dguille...@gmail.com
I don’t have 2000 but would think you would have to develop in 2000 and
hope the later versions can
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)
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 dguille...@gmail.com wrote:
Why not let excel do the heavy lifting using subtotals. See attached in
SalesAidSoftware module
Don Guillett
SalesAid
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
Hi Group,
Could anyone please share some tutorials for the Seriesand 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,
Urgent,
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.
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
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
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 dguille...@gmail.com
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
you are the greatest from the greatest :)
thanks
Pawel
From: dguillett1 dguille...@gmail.com
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
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
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
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
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$$
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+
Thanx David
From: David Grugeon grug...@gmail.com
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
Hi ,,
Please share your workbook.Thanks
On Sat, Feb 11, 2012 at 2:15 AM, Mayank mayanksupadh...@gmail.com 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
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
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
*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 vijayajith...@gmail.comwrote:
Hi
Question asked in interview
i have nearly 30 pivot tablein 30 sheets i need to enter
thanks Mate
From: dguillett1 dguille...@gmail.com
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:
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 talk2mar...@gmail.com wrote:
*If source data is same for all pivots, refresh anyone of the pivot.
other
46 matches
Mail list logo