Hi Prince ,
On Thu, Dec 27, 2012 at 10:55 AM, Prince wrote:
> Hi Rohit,
>
> Pls Check my file as i have put sumif formula in ptd & ytd & suggest me
> wht should be possible for me .
>
> I hope this may help you, Otherwise let me know.
>
> =TEXT(NOW(),"dd-mmm-")
>
> Regards
> Prince
>
>
>
Hi Rohit,
I hope this may help you, Otherwise let me know.
=TEXT(NOW(),"dd-mmm-")
Regards
Prince
On Thursday, December 27, 2012 11:58:21 AM UTC+5:30, tharwani.rohit wrote:
>
> Hie Experts ,
> PFA of Daily Consumer daily sales & i need urgent help from your side
> ..in report sheet i hav
use =Today() on that cell which u want to change automatically.
Regards,
Gawli Anil
On Thu, Dec 27, 2012 at 11:58 AM, rohit tharwani
wrote:
> Hie Experts ,
> PFA of Daily Consumer daily sales & i need urgent help from your side
> ..in report sheet i have put formulas & in PTD 15feb 2012 in th
Correct Anand,
By mistake, i have left Exit sub in Code.
You can abbreviate code by using For Next loop
Sub collatedata()
Dim i%, j%
Dim rng As Range
Dim sh As Worksheet
Set sh = Sheets.Add
sh.Move after:=Sheets(Sheets.Count)
sh.Name = "Mastersheet"
Sheets(1).Range("A1:C1").Copy sh.Cells(1, 1)
F
Hi SK,
Apply This. In Commission Cell
if (volume<99,0, if(
or(volume>=100,volume<=500),1,if(or(valume>500,Volume<=1000),1.5,"Out
Of Range")))
Regards
Prince
On Thursday, December 27, 2012 11:31:50 AM UTC+5:30, SK wrote:
>
> Dear team,
>
> I need help to build a i
Hi Rajesh,
share ur requirement with me or any sample file.
Regards
Prince
On Thursday, December 27, 2012 9:18:38 AM UTC+5:30, Anand Kumar wrote:
>
> Dear Prince,
>
> Could you please share code for splitting data into multiple sheets based
> on column.
>
> Regards,
> Anand Kumar
>
> On Thur
Dear Rajesh ,
Pl attach the right workbook . Your attached workboon contains no data.
Regards,
Gawli Anil
On Wed, Dec 26, 2012 at 9:17 PM, Prince wrote:
> Hi Rajesh,
>
> There is no data in the sheet.
> :(
>
> regards
> Prince
>
> On Wednesday, December 26, 2012 5:28:24 PM UTC+5:30, kasper wr
Dear Noorain,
In your code the statement Exit Sub comes right before End Sub. It is also
not based on any condition being tested and no Error Handling is there so
Go To is also not being used.
Could you please explain how this code is working?
Warm Regards,
Anand Kumar
On Thursday, 20 December
Dear Prince,
Could you please share code for splitting data into multiple sheets based
on column.
Regards,
Anand Kumar
On Thursday, 20 December 2012 12:39:35 UTC+5:30, Pravin Gunjal wrote:
>
> Hi Friends,
>
> I have an excel file containing almost 50 sheets in it and would like to
> gather all
Hi amar
Nice work . Thanks for sharing.
Regards,
Lalit Mohan
+919711867226
On Wednesday, 26 December 2012 20:09:53 UTC+5:30, (%Allmydreams%) wrote:
>
> Hi Guys
>
> check out this you may get some more ideas to think in different
>
> On Sat, Dec 22, 2012 at 4:38 PM, amar takale
> > wrote:
>
@ amar
Nice work with more features. Thanks for sharing this to us.
Regards,
Lalit Mohan
+919711867226
On Wednesday, 26 December 2012 20:09:53 UTC+5:30, (%Allmydreams%) wrote:
>
> Hi Guys
>
> check out this you may get some more ideas to think in different
>
> On Sat, Dec 22, 2012 at 4:38 P
change the yellow line to
Dim olApp As Object
Set olApp = CreateObject("Outlook.Application")*
or add a reference to Microsoft Outlook 9.0 Object Library from Tools -
Reference
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use co
Hi,
Happy new year and all... About your query it seems you have 2 queries, one
related to mail merge (paper) and one to email. I have been working on
these for my own needs, with more or less access to the content...
For mail merge using email, it seems there are many resources available
onl
Hi,
Happy new year and all... About your query it seems you have 2 queries, one
related to mail merge (paper) and one to email. I have been working on
these for my own needs, with more or less access to the content...
For mail merge using email, it seems there are many resources available
onli
Hi Rajesh,
There is no data in the sheet.
:(
regards
Prince
On Wednesday, December 26, 2012 5:28:24 PM UTC+5:30, kasper wrote:
>
> Hi experts,
>
> Please check the attached file.In it the first table contains daily
> purchase data, I want to get a summery report of the same in the second
> tab
Dear Guys,
Any thoughts suggestions or observations can comment on below web link
Site :
http://smurfonspreadsheets.wordpress.com/2012/11/12/2013-excel-developer-conference-london-january-2013/#comments
Regards
Yogananda Muthaiah
Ph : 973 123 7267
--
Join official Facebook page of this foru
Hi experts,
Please check the attached file.In it the first table contains daily
purchase data, I want to get a summery report of the same in the second
table format, How can use a formula with two criteria .
Regards
Rajesh
--
Join official Facebook page of this forum @
https://www.facebook.c
FORUM RULES
2) Don't post a question in the thread of another member
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: rohit tharwani
Sender: excel-macros@googlegroups.com
Date: Wed, 26 Dec 2012 15:52:18
To:
Reply-To: excel-macros@googlegroups.com
Subject:
Hi Amit,
you can add as many as sheet you required. and run this tool it will create
a sheet name "combineddata" and paste the data from all sheet into
"combineddata" sheet.
For your second Question: yes i have the solutionof splitting the data of
sheet into multiple sheet based on the column
Most welcome :)
Regards
Prince
On Wednesday, December 26, 2012 3:31:44 PM UTC+5:30, Pravin Gunjal wrote:
>
> Thanks a lot!
>
> -- Forwarded message --
> From: Prince >
> Date: Sun, Dec 23, 2012 at 11:37 AM
> Subject: $$Excel-Macros$$ Re: Combine all sheets in a single sheet
> To:
Dear Prince,
Please explain how to use this.. also do you have a solution for how to split a
sheet in different sheets based on a column.
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prince
Sent: 23 December 2012 11:38
To: excel-mac
Thanks a lot!
-- Forwarded message --
From: Prince
Date: Sun, Dec 23, 2012 at 11:37 AM
Subject: $$Excel-Macros$$ Re: Combine all sheets in a single sheet
To: excel-macros@googlegroups.com
Hi Pravin,
PFA
Regards
Prince
On Thursday, December 20, 2012 12:39:35 PM UTC+5:30, Pravi
@Prince,
Thanks for the understanding :)
On 26-12-2012 2:27 PM, Prince wrote:
Yes Dear Ms-Exl-Learner,
I also belive in correcting the things so that anything we do should
be perfect and smooth. It is best form me that guys like you are
always there who can ping me whenever i do any thing w
Yes Dear Ms-Exl-Learner,
I also belive in correcting the things so that anything we do should be
perfect and smooth. It is best form me that guys like you are always there
who can ping me whenever i do any thing wrong .
Thanks again for correcting me.
:)
Regards
Prince
On Wednesday, December
@Prince,
I am not talking about the ways or methods of getting the result, which
I never did, since that is the speciality of excel we can get the same
result in many ways.
But the previous post is not related to the method or ways of pulling
the data, It's about the *errors and wrong usage*
HI Prince
Thanks for the formula
Rajesh
On Wednesday, December 26, 2012 12:22:05 PM UTC+5:30, Prince wrote:
>
> Hi Rajesh,
>
> It may help you,.
>
> =SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1) with cse
>
> Regards
> Prince
>
> On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30
Hi Lalit
Thak you for the formula.
Rajesh
On Wednesday, December 26, 2012 11:49:40 AM UTC+5:30, Lalit Mohan Pandey
wrote:
>
> Hi Rajesh,
>
> Apply below formula instead of yours with Ctrl + Shift + Enter
>
> =SUM((MONTH($C$16:$C$380)=MONTH($B2&1))*(D$16:D$380))
>
> and the mistake is the matchi
Hi
Thank you for the formula ,it is working well,
Rajesh
On Wednesday, December 26, 2012 11:24:08 AM UTC+5:30, Ms-Exl-Learner wrote:
>
> *In C16** cell*
> =IF(ISNUMBER(B16),TEXT(B16,""),"")
> *Drag it down.*
>
> *In D2 cell*
> =SUMIF($C$16:$C$380,$B2,(D$16:D$380))
> *Drag it to right...*
>
Hi Ms-Exl-Learner,
Yes dear, you are right. There are so many ways to do the same thing. And
thanks alot for your kind information :)
Regards
Prince
On Wednesday, December 26, 2012 12:48:10 PM UTC+5:30, Ms-Exl-Learner wrote:
>
> @Prince,
>
> Why not just added another "m" in your text function
29 matches
Mail list logo
