Dear all,
Basically i need Other than Active cell of column should clear . some time
below code is not working and excel itself not working.
Which is highlighted code .. i need better code for this.
'***
hi Group Member
i have small doubt how to use Sumproduct Not Equal Rangelike
A B
110100
2 20 200
330 300
440 400
5 50 500
Not in range like
8 20
9 30
i used like this
=sumproduct((a1:a5>=1)*(a1:a5<=4)*(a1:a5<>a8:a9)*(B1:B5))
i got error
IES.
>
>
> On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran
> wrote:
>
>> Hi maries,
>>
>> thanks for your Reply,
>>
>> MyOutput Sheet D1 Activate then My List of Cutomer may
>> shwon seperate list box or Below D1 Cell there itself we want
On Wed, Feb 22, 2012 at 12:13 AM, chandra sekaran wrote:
> Dear Maries & SAM
>
> Lot of Thanks Providing such a wonderful coding part, i understand form
> you,
>
> Once again Thanking all
> Have a Good day for you
>
> Regards
> chandru
>
>
>
Dear Noorain, Asa
Excellent answer very clear explanation thanks
regards
chandru
On Thu, Feb 23, 2012 at 12:21 PM, Asa Rossoff wrote:
> Hi Johann,
>
> To add to Noorain's explanation:
>
> ** **
>
> Boolean (True/False) values cannot be added, multiplied, averaged, etc. by
> agg
Dear all,
i have very long code it like 250 lines during my code process how use
Prgress bar untill my code end sub the progress bar will run,
Thanks Regards
chandru
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pl
thanks Noorain, its helpful for excel users lke me ,
On Thu, Feb 23, 2012 at 8:17 PM, xlstime wrote:
> very useful
>
> On Wed, Feb 22, 2012 at 11:08 PM, NOORAIN ANSARI > wrote:
>
>> Dear Group,
>>
>> I have shared a Custom Format example sheet, i got it from below link
>>
>> http://spreadshe
>
>> On Tue, Feb 21, 2012 at 10:11 PM, Sam Mathai Chacko
>> wrote:
>>
>>> Boss, if you type L, all the customers starting with L is listed in the
>>> table below. Then why do you need a separate list in D1?
>>>
>>>
>>> On Tue, Feb
tput!$D$1,ROW(INDIRECT(("1:"&ROWS(Data!$E$3:$E$82,""),ROW()-ROW(MyOutput!A$4))),"")
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Tue, Feb 21, 2012 at 8:17 PM, chandra sekaran
> wrote:
>
>> hi exell famly
>>
>> can any
hi exell famly
can any one give my logic code if possible, please...
chandru
On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran wrote:
> Dear Maries ,
>
> First of i would thanks for valuable effort , but what i expected like
> this only if Activate D1 Cell then Imm
Tue, Feb 21, 2012 at 10:05 AM, chandra sekaran
> wrote:
>
>> Dear all
>>
>> Any one advice to me Best Power Point Template for my presentation with
>> animation company realted
>>
>> Regards
>> chandru
>>
>>
>>
>> --
>>
Dear all
Any one advice to me Best Power Point Template for my presentation with
animation company realted
Regards
chandru
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Prob
> Hi,
>
> I got your logic. Check the attachment.
>
> Type your text in cell D1 & Enter. It will give answer.
>
> Regards,
>
> MARIES.
>
>
> On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran
> wrote:
>
>> Hi maries,
>>
>> thanks for your Rep
t;
> MARIES.
>
>
> On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran
> wrote:
>
>> Dear all
>> Here with attached List Box like Tally is this possible with excel
>> once Active List box or Cell shown under all name after enter first
>> letter tha
IF(LEN(SUBSTITUTE(UPPER(database!$A$1:$A$2500),UPPER(Sheet2!$E$3),""))
> Regards,
> Sam Mathai Chack
>
> On Thu, Feb 16, 2012 at 11:12 PM, chandra sekaran <
> duraichan...@gmail.com> wrote:
>
>> Dear Sam,
>>
>> My quey if i type cell E3 like Mohan
Hi ,
Here with attchaed file we need smal macro when i type first Letter
than shown start with first if type second letter then based on my
cretria shown all list can any one help me
Like i have name list example
Name Moahn Mohan Kumar Mohan Doss Mathan Mathan Kumar Ashok ashok
Dear all,
I am using Excel 2007 when i open a file My Macro Not run any one help
this
Private Sub Workbook_Open()
MsgBox "Hi, thanks for opening me", vbInformation, "Ozgrid.com"
End Sub
''=or
Private Sub Workbook_Open()
Call My Macro
End Sub
Regards
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
> balanc
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
Thanks Noorain Ansari ,its works fine
Regards
chandru
On Wed, Feb 8, 2012 at 11:59 AM, NOORAIN ANSARI wrote:
> Dear Chandra Sekaran,
>
> Please try it..
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Column = 8 And VBA.UCase(Target.Valu
get.Offset(0, -2).Value = "Booked"
> If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
> Then
> Target.Offset(0, 2).Value = "UnBilled"
> End If
> End If
>
> End sub
> Sent from BlackBerry® on Airtel
>
Dear all
i have wrriten this code for worksheet change module My contion is
workingbut second contion is not working any one help me
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
"BILLED" Then
Target.Of
his.
>
> So, just to show how I'd do it out of laziness
>
> Sub ClearSubTotal()
>
> On Error Resume Next
>
> ActiveSheet.UsedRange.RemoveSubtotal
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
> On Mon, Feb 6, 2012 at 11:20 PM, c
, 2012 at 2:16 PM, Maries wrote:
>
>> Hi,
>> **
>> *Try this code:*
>> **
>> Sub Macro1()
>> Cells.Select
>> Selection.RemoveSubtotal
>> End Sub
>>
>> Regards,
>>
>> MARIES.
>>
>> On Mon, Feb 6, 2012 at
HI ALL
I have write small macro , i want revmove subtotal if Active sheet
subtotal method is there
Sub Macro1()
If ActiveSheet.SubtotalMethod = True Then
Selection.RemoveSubtotal
End If
End Sub
can any one correct this code
Regards
chandru
chennai
--
FORUM RULES (986+ me
uot;i")
> .Cells(3, "e").Resize(lr - 2).SpecialCells(xlCellTypeVisible).Copy
> Cells(8, "j")
> .Cells(3, "f").Resize(lr - 2).SpecialCells(xlCellTypeVisible).Copy
> Cells(8, "k")
> .Cells(3, "h").Resize(lr - 2).SpecialCells(xlCell
sorry Krish its not working its not pickup all data from data sheet
chandru
On Sun, Feb 5, 2012 at 6:23 PM, Kris wrote:
> Hi
>
> Replace these lines
>
> Set rngRowData = rngRowData.SpecialCells(**xlCellTypeVisible)
> Set rngRowData = Intersect(rngRowData, rngRowData.Offset(1))
>
> with
>
Hi
This is code wrriten by Rajan verma, it is small issues is there when
Filter Collection journal in data sheet it will not pickup all
collection journal data in my out put sheet what is issues below code
Dim rngRowData As Range
Dim rngCell As Range
Dim wksOutPut As Workshee
Hi Sanjib
simple Vlookup forumula to solve your Query
Regards
chandru
chennai
On Fri, Feb 3, 2012 at 4:28 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> Thank you for your help
>
> ragards,
>
> sanjib
>
>
> On Fri, Feb 3, 2012 at 4:02 PM, The Viper wrote:
>
>> please find
CH(C1,$D$7:$H$7,0))
>
> See attached Sheet.
>
>
> On Fri, Feb 3, 2012 at 3:13 PM, chandra sekaran wrote:
>
>> Hi Noorin
>>
>> Excell Sheet attached
>>
>> Chandru
>>
>>
>>
>>
>> On Fri, Feb 3, 2012 at 3:02 PM, NOORAIN ANSARI
Hi Noorin
Excell Sheet attached
Chandru
On Fri, Feb 3, 2012 at 3:02 PM, NOORAIN ANSARI wrote:
> Dear Chandra,
>
> Please share sample sheet
>
> On Fri, Feb 3, 2012 at 2:37 PM, chandra sekaran
> wrote:
>
>> Dear all,
>>
>> Sheet 1 having below dat
Dear all,
Sheet 1 having below data Month wise product details sheet 2 if i
select Jan -12 then Product A selection qty will come 100what is
the formula any one help me
Jan-12 Feb-12 Mar-12 Apr-12 May-12 * * * *
* * PRODUCT A 100 * *
hi
you have excell to pdf addin if you not download from below link
http://www.microsoft.com/download/en/details.aspx?id=9943
after you run macro will work
Regards
chandru
On Thu, Feb 2, 2012 at 3:44 PM, PrIyAnKa wrote:
> Kindly help for this
>
>
> On Wed, Feb 1, 2012 at 12:59 PM, PrI
Dear all
Here is my dataitem & Make is same then first item amount X 10 %
should come same items and same make below formula need like thatany
one help
A
B
C
D
1
ITEM
MAKE
AMOUNT
FORMULA NEED
2
1XXX
XYZ
1
1000
3
1XXX
XYZ
12000
1000
4
1XXX
XYZ
8000
1000
5
Congratulation Noorain , you & *Rajan Verma, Sam, Don Guillett,
Kris,*are a player, Each & every one contribution great .
chandru
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Jan'12
> He h
Hi all
I need Formula which attached sheet any one help me
Regads
chandu
--
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
q
Dear all
Based on my Worksheets i already having pdf file which i attached and
sent respective email address i have email address each sheets K7 How
do i attached particular pdf and sent their email id
Here is code what i have wrong
Sub Send_Email_Current_Workbook()
Dim OutApp As Obj
OpenAfterPublish:= _
>
> False
>
> Next
>
> End Sub
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran
> *Sent:* Jan/Tue/2012 03:37
> *To:* excel-macros@googlegroups.com
>
Dear all
i need macro for excel to pdfi have 25 sheet each sheet convert
to pdf . PDF file name should be a Sheet name any one help me
Regards
chandru
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pl
Thanks rajan
On Tue, Jan 31, 2012 at 11:46 AM, Rajan_Verma wrote:
> Hi Chandru
>
> Please find unprotected version
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf O
tached sheet.
>
> ** **
>
> Thanks
>
> Rajan Verma
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran
> *Sent:* Jan/Tue/2012 11:09
> *To:* excel-macros@googlegroups.com
>
Dear all,
Here with attached salary data and payslip format i have data sheet
that is containing emp salary details & i have sheet Payslip . this
is containing Payslip formati need macro for this only once i will
run macro all the employee should generate this format and conver
hi Noorain
here with attached Excel sheet more informattive
Regards
chandru
On Mon, Jan 23, 2012 at 6:46 PM, NOORAIN ANSARI wrote:
> Dear Chandra,
>
> Please explain more
>
>
> On Mon, Jan 23, 2012 at 1:48 PM, chandra sekaran
> wrote:
>
>> Dear E
Dear Excel-Macro Family
I have Two sheet Like Data & Deptwise , Data Sheet Data are comes
from our ERP Software , Deptwise Sheet having Deptemnt wise expenses
consoliated
i have GL Code in my Data sheet but i donot have Deptwise sheet
this gl code automatically add to my Deptwise
d that the data came in on
> the FIRST sheet in the file in the SAME format as the destination sheet.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* chandra sekaran
> *Sent:* Sunday, January 22, 2012 8:36 AM
> *To:* excel-macros@googlegroups.co
On Sun, Jan 22, 2012 at 7:53 PM, dguillett1 wrote:
> See att
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* chandra sekaran
> *Sent:* Sunday, January 22, 2012 6:56 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macr
try this
=TEXT(TEXT(B3,"-00-00"),"DD-MM-")
chandru
On Sat, Jan 21, 2012 at 10:16 AM, xlstime wrote:
> or try this one.. for any format
>
> =TEXT(B2,"-00-00")+0
>
>
> On Sat, Jan 21, 2012 at 10:14 AM, xlstime wrote:
>
>> Hi Ashish,
>>
>> use this formula (if you date format is sa
hi noor
can you help me
Regards
chandru
On Tue, Jan 17, 2012 at 12:17 PM, chandra sekaran wrote:
> Dear all
>
> can you please help me . which i attached excell sheet having two
> sheets one SAP sheet and output we need product wise sum Qty and Value
> if you sugge
Dear all
can you please help me . which i attached excell sheet having two sheets
one SAP sheet and output we need product wise sum Qty and Value if you
suggest simple macro
Thanks
Chandru
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles.
Dear all
can any one help me its need very urgent ple
Chandru
On Thu, Jan 12, 2012 at 11:59 AM, chandra sekaran wrote:
> Dear all
>
> i need this excell automation, Sheet 1 data sheetand Out need like
> this we need macro any one help me
>
>
hi ranjan
Cash flow Report is ready
Regards
chandru
--
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
Dear rajan,
Thanks
regards
chandru
On Thu, Jan 5, 2012 at 7:43 PM, Rajan_Verma wrote:
> Hi chandru..
>
> You will get it tomorrow..
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@goog
Dear Rajan,
Cashflow Date Problem can i get sir,
Regards
chandru
--
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
qui
ks & regards,
>
> Noorain Ansari
>
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>
>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>
> ** **
>
> O
Dear all
What is different between .value and .value2 can you explain
with range ("a1:a100")
.value= .value2
end with
with range ("a1:a100")
.value= .value
end with
or
with range ("a1:a100")
.value2= .value2
end with
i do't know how do normally use which is performance best ? [ Fast
Dear Mr. Rajan,
Have you seen my Cash flow Date selection Problem
Please...
Chandru
--
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
ailto:
> excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran
> *Sent:* Jan/Wed/2012 08:09
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME
>
> ** **
>
> Dear all,
>
>
>
> do you sugguest
Dear all,
do you sugguest any other formula is there . [ MY Formula sheet attached]
Regards
durai.chandra sekaran.(Chandru)
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Pro
Dear sir,
could you plese provide soulution sir,
Regards
chandru
On Tue, Jan 3, 2012 at 8:24 PM, chandra sekaran wrote:
> Dear Rajan,
>
> if i select Month july only july data will come but all data comes
> output sheet after that i little bit change from date , To
Dear all,
Any VBA code is there ?
regards
chandru
On Mon, Jan 2, 2012 at 10:46 AM, Kris wrote:
> Hi,
>
> For Numbers,
>
> Select each column on by one. Go to Data > TextToColumns > Next > Next
> check on General > Finish.
>
> For date, check Date Instead of General and select DMY > Finish.
Dear all
Date also stored in texthow i convert to date pl advice
Regards
chandru
--
FORUM RULES (934+ 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 Advi
, sum product What i used Direct Excel formula i
used in vba code also is it correct
4 copy and past after i used calculation only data pick up this time
only take too much time after i used .value = .value
Regards
chandra Sekaran.
On Sat, Dec 31, 2011 at 6:10 PM, Rajan_Verma wrote
sir,
Sheet1 . data more than 5000 Rows and Entry Sheet is more than
7 Laksh rows data Here i can't attached that why what maxium
data sending (Less than 4.mb ) only i attached
Regards
chandra sekaran.
On Sat, Dec 31, 2011 at 5:49 PM, chandra sekaran wrote:
Dear sir,
Thanks sir, i am very much surprise , less than a second my output comes
great sir,only one query sir, if i select Month wise or base on
date selection between the date my out will come . can you give sir,
Lot of thanks
regards
chandru
--
FORUM RULES (934+ members alread
Dear sir
i have code for copy past like this
Range("d5:d10").Copy Workbooks.Add WorkSheet(1).Range("a1")
but this is not working what i have missed out
regards
chandru
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, l
>> excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran
>> *Sent:* Dec/Tue/2011 02:13
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Max Value Min Value
>>
>> ** **
>>
>>
>>
>> Dear all **
Dear all
Pleae help Max value of S.No. based Min Value based on S.no. what
is formula
S.No Amount Max Min 10 25 10 -2 -2 10 75 10 165 16520 165 20 175
175 20 90 20 65 20 50 20 27 2730 -425 -425 30 665 30 1065 1065
if S.No. 10 containing 4 values what is max v
67 matches
Mail list logo