dear Jayendra
Pls find Attached Excel sheet for your ref
Regards,
Anil Gawli
On Wed, Jul 25, 2012 at 10:10 AM, jayendra gaurav wrote:
Team,
How to count a cell based on color .
file is attached for your's reference.
--
J.Gaurav
Call-7838594954
--
--
FORUM RULES (986+
dear prkhan,
Share ur data with groups...
Regards,
Gawli Anil
On Wed, Jul 25, 2012 at 12:50 PM, prkhan56 wrote:
Hello,
With the present data, I cannot.
That is what I will do when I get all the Emp details in a summary sheet.
Now the Emp names are in columns.
I wish to have their details
Dear Noorian,
Thanks for the precious information..
Regards,
Gawli Anil
On Wed, Jul 25, 2012 at 5:36 PM, NOORAIN ANSARI wrote:
FYI
-- Forwarded message --
From: ExcelUser k...@exceluser.com
Date: Wed, Jul 25, 2012 at 5:30 PM
Subject: Office 2013 + YOY Reporting + 5
Dear Tony,
U can use without macro
Just select the range and press ctl+G of press F5 function key .
Then click to blank cell and use Alt+E+D select the row and delete it
Regards,
Gawli anil
On Thu, Jul 26, 2012 at 8:42 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Tony,
Please
Drag the cursor when the cursor become + sign and drag.
Regards,
Gawli Anil
On Wed, Jul 25, 2012 at 11:49 PM, kumar.ashish861 kumar.ashish...@gmail.com
wrote:
Dear Balbir,
First u have to select a cell copy it (what you want to paste), then
select a range, including the copied cell
take it to the right side corner dude...
Regards
Gawli Anil
On Thu, Jul 26, 2012 at 10:49 AM, balbirkumar . balbirku...@sify.comwrote:
Thanks for support . But my problem is the cursor does not become + sign
to drag. Please suggest.
On 26 July 2012 10:32, अनिल नारायण गवली gawlianil8
pls share the data with us
Regards
Gawli Anil
On Fri, Jul 27, 2012 at 11:55 AM, David Grugeon da...@grugeon.com.auwrote:
Yes I would use Vlookups. The issue is to get the formulas to use the
different sourcebooks. Probably your best bet is to cut and paste all the
lines from the 10 source
Dear Bhat.
Pls find Attached Sheet FYI
Regards,
Gawli Anil
On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S wrote:
Dear Experts,
Good Morning.
I have a case where in Data is built in with Text (1 2 Digits, Eg: 1
Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I
required
Pls find attached sheet FYI
Regards,
Gawli Anil
On Fri, Jul 27, 2012 at 12:47 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear JP,
Please use..
*=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT(48:58))),)*
On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S wrote:
Dear Experts,
Good
Is it can run on winxp sp3 or not?
Regards,
Gawli Anil
On Tue, Jul 31, 2012 at 4:15 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Joshep,
Please see screen shot...
On Tue, Jul 31, 2012 at 10:16 AM, joseph camill
joseph.cam...@gmail.comwrote:
Hi Noorain,
Please help me
pl share us with some files..
Regards,
Gawli Anil.
On Wed, Aug 1, 2012 at 2:36 PM, ARUN(°•¤a®µn¤•°™) wrote:
Dear Members,
Need a macro for converting one subtotal part into diffrent sheets from a
workbook.
10x regards
Arun
--
FORUM RULES (986+ members already BANNED for violation)
pl share a data with groups.
Regards,
Gawli Anil
On Fri, Aug 3, 2012 at 11:52 AM, सुनिता पौडेल tosune...@gmail.com wrote:
Dear all,
Is there any possibility to create a small table where data can be put to
clarify the reason of the amount of one certain cell instead of inserting a
comment
congrats noorian ansari:)
Regards,
Gawli Anil
On Sat, Aug 4, 2012 at 10:38 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Congratulations Noorain Sir.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.:
I didn't understand your remaining 50% query.
Exactly what u want and how?
Pl elaborate it...
Regards,
Gawli Anil
On Mon, Aug 6, 2012 at 2:25 PM, Lokesh Loki wrote:
Hi All,
It's urgent anybody please resolve my query. I hope all of you understand
my concern.
Regards
Lokesh.M
On Mon,
Dear Amar
Your formula is right
if you want only the highlighted color then on filter field click on filter
by color . it is easily available there
Thanks Regards,
Gawli anil
On Tue, Aug 21, 2012 at 3:20 PM, amar takale amartak...@gmail.com wrote:
Hi Amresh
I used excel 2003 So I cant
Dear Amar,
Pls find attached sheet enclosed.
Regards,
Gawli Anil
On Wed, Aug 22, 2012 at 11:49 AM, amar takale amartak...@gmail.com wrote:
Hi all Experts,
How to all worksheets protect to unprotect at one time,Is there any VBA
code to unprotect sheet at one time.
--
Join official
, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Dear Amar,
Pls find attached sheet enclosed.
Regards,
Gawli Anil
On Wed, Aug 22, 2012 at 11:49 AM, amar takale amartak...@gmail.comwrote:
Hi all Experts,
How to all worksheets protect to unprotect at one time,Is there any VBA
code
Gr8 work rajan .:)
Regards,
Gawli Anil
On Wed, Aug 22, 2012 at 9:34 PM, Hilary Lomotey resp...@gmail.com wrote:
i love the chart, nice work bro
On Wed, Aug 22, 2012 at 3:35 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Sir,
It's really good.
Regards,
Kuldeep Singh
On
To post to this group, send email to excel-macros@googlegroups.com.
Regards,
Gawli Anil
On Wed, Aug 22, 2012 at 8:10 PM, Anil Jangra eraniljangr...@gmail.comwrote:
Hi,
I want to joing this group and would like to recieve emails from this
group.
I am working with AonHewitt as Data Analyst.
Deat Amar
U have to select all the required cells at one time and then foto formula
bar and then press Cltr+Enter.
Hope it should work . reply me when done.
Regards,
Gawli Anil
On Fri, Aug 24, 2012 at 11:12 AM, amar takale wrote:
Hi All
I found Data validation sheet in group,It is ok if
Dear Amar,
The file u had given to us is corrupted. kindly send again.
Regards,
Gawli Anil
On Fri, Aug 24, 2012 at 10:51 AM, amar takale wrote:
Can anybody solve my problem
Pls suggest me foe formula
-- Forwarded message --
From: amar takale amartak...@gmail.com
Date:
Dear Pravesh,
Enclosed herewith your query solu
Regards,
Gawli Anil
On Thu, Aug 30, 2012 at 10:26 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Dear Preavesh,
04 solutions of you. for any query please see attachment.
=LOOKUP(H3,$C$3:$D$9)
=VLOOKUP(H3:H6,$C$3:$D$9,2,0)
Dear Sriram
Attached is the Eg of Vlookup furmulae
Thanks Regards,
Gawli Anil
On Fri, Aug 31, 2012 at 12:26 PM, pankaj sangotra psangotr...@gmail.comwrote:
Hi Sriram,
Vlookup is used to pick values from tables for lookup values...
For more details use techonthenet.com.. This is an
It would be grt to our group..
KIU.
Thanks Regards,
Gawli Anil
On Fri, Aug 31, 2012 at 1:24 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Noorain,
Isna(vlookup)
On Fri, Aug 31, 2012 at 1:16 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Group,
If any have more example
try =NETWORKDAYS formula
Thanks Regards,
Gawli Anil
On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello,
I need a formula for dates which excludes Saturday, Sunday Holidays(in
sheet2). Could you please help with the formulas.
Thanks in advance.
try =NETWORKDAYS formula
Thanks Regards,
Gawli Anil
On Fri, Aug 31, 2012 at 1:41 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
try =NETWORKDAYS formula
Thanks Regards,
Gawli Anil
On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello,
I need
Dear noorian,
Congrats Dear..:)
Thanks Regards,
Gawli Anil
On Mon, Sep 3, 2012 at 10:20 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Congrats Noorain Sir.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
Phone.:
the max size for attachind a file is 25 mb.
your are getting a error message but what message is showing over there how
we know.
mention error description .
On Mon, Sep 3, 2012 at 3:28 PM, L.K. Modi ca.mod...@gmail.com wrote:
Dear all
as i m uploading file containing size of 25 mb at gmail
go to this site and see
http://support.google.com/mail/bin/answer.py?hl=enanswer=8770
U must be using .exe file for attaching . just confirm.
On Mon, Sep 3, 2012 at 3:33 PM, Kuldeep Singh naukrikuld...@gmail.com
wrote:
Hi,
Gmail is not supported file size 25 MB. This facility only yahoo
how can we understand what file u r attaching dude...
just elaborate and explain...
On Mon, Sep 3, 2012 at 3:40 PM, L.K. Modi ca.mod...@gmail.com wrote:
sir
thats a long song dedicated to someone. is this possible with yahoo mail.
On Mon, Sep 3, 2012 at 3:33 PM, Kuldeep Singh
Dear Pravesh,
See i have changed the dropdown working .
pls do the color , as i'm busy with other work.
On Fri, Sep 7, 2012 at 9:48 AM, PRAVESH KUMAR wrote:
HI Team,
please help me to solve this queston it's very urgent.
solve asap.
--
Thanks Regards
Pravesh Kumar
--
Join
Anil Narayan Gawli
Mb:-09769855615
gawli_anil8...@yahoo.co.in
gawlianil8...@gmail.com
On Mon, Sep 10, 2012 at 1:40 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Hi All,
** **
First of all thanks to all experts who helping to the world with their
expertise knowledge and
Try this attachment
On Wed, Sep 12, 2012 at 2:28 PM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Masters,
In the attached file there are six working sheets in it.
The concerned person will send a mail of this file to his down level for
their working/use.
*Sheet 1 *is made for the
whr is the attachment??
On Fri, Sep 14, 2012 at 10:26 AM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Please help me understand, how this works?
** **
Best Regards,
Amit
** **
*From:* Prince Dubey [mailto:prince141...@gmail.com]
*Sent:* 13 September 2012 23:16
Dear Simon,
Pl share us a sample workbook.
Regards
Gawli Anil
On Sat, Sep 15, 2012 at 10:12 AM, ashish koul koul.ash...@gmail.com wrote:
try this
VLOOKUP(A2,B:C,2,0)
remove extra spaces from the columns
Regards
Ashish
On Sat, Sep 15, 2012 at 12:51 AM, SimonCoder mreed1...@gmail.com
pl use =SUMPRODUCT((B3:B85=H8)*(C3:C85=I8)*(D3:D85=J8)*(E3:E85))
Regards
Gawli Anil
On Tue, Sep 25, 2012 at 9:58 AM, Vabz v...@vabs.in wrote:
Hi
For more understanding on sumproduct with real life examples please refer
following link:
Link
from deep of my heart Congrats dear.Good luck for your future...
Regards,
Gawli Anil
On Wed, Oct 3, 2012 at 6:25 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Thanks to all.*
* *
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:*
Dear Rajan,
congrats...:)
On Fri, Oct 5, 2012 at 5:46 PM, prkhan56 prkha...@gmail.com wrote:
Congrats!
On Wednesday, October 3, 2012 3:43:49 PM UTC+4, NOORAIN ANSARI wrote:
I can say only...
यूँ ही बरकरार रखो भाई अपने Expertise के छाप को.
और
Pls see the attachment it is in Sheet 1 and sheet 2 one is for gmail and
second is for yahoo.
On Mon, Oct 8, 2012 at 11:28 PM, Sam Mathai Chacko samde...@gmail.comwrote:
This is a link by Lalit Mohan, one of the members of this forum
attached
On Wed, Oct 10, 2012 at 3:19 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Pls see the attachment it is in Sheet 1 and sheet 2 one is for gmail and
second is for yahoo.
On Mon, Oct 8, 2012 at 11:28 PM, Sam Mathai Chacko samde...@gmail.comwrote:
This is a link by Lalit Mohan
--
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Dear Groups,
Pl ssubcribe me ..
Thanks Regards,
Gawli Anil
On Thu, Oct 11, 2012 at 12:24 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
--
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Thanks Regards,
Gawli Anil Narayan
congrats rajan
Regards,
Gawli Anil
On Fri, Oct 12, 2012 at 11:09 PM, Rajasekhar Praharaju
rajasekhar.prahar...@gmail.com wrote:
Congrats rajan for your threshold efforts..
On Wed, Oct 3, 2012 at 2:19 AM, Asa Rossoff a...@lovetour.info wrote:
I'm happy to see you recognized and honored for
Dear Groups and Noorian,
I want a macro that import other worksheets in a excel workbook by using
filedailogbox .
1) when filedailogbox opens i have to select the required file and
automatically all the sheets name should displayed in a box from that i
have to select one sheet and import that in
Pls somebody help me on this
On Monday, October 15, 2012 5:37:44 PM UTC+5:30, अनिल नारायण गवली wrote:
Dear Groups and Noorian,
I want a macro that import other worksheets in a excel workbook by using
filedailogbox .
1) when filedailogbox opens i have to select the required file
Dear noorian,
Pls help me awaiting for your reply
On Mon, Oct 15, 2012 at 5:37 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Groups and Noorian,
I want a macro that import other worksheets in a excel workbook by using
filedailogbox .
1) when filedailogbox opens i have to select
R u using Mozilla firefox then manage Addon .
Regards,
Gawli anil
On Thu, Oct 18, 2012 at 10:23 AM, Shrinivas Shevde
shrinivas...@gmail.comwrote:
**Dear Group Members,
I am using Excel 2010 .I was trying to copy paste a data from one workbook
to another workbook.
I am getting following
,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* अनिल नारायण गवली gawlianil8...@gmail.com
*To:* excel-macros@googlegroups.com
*Cc:* NOORAIN ANSARI noorain.ans
suppose there is one two excel file
one is A
second is B
in A file there is 2 fields like (Shiptocode) and (Productcode).
in B file there is 5 fields like (Shiptocode) and (Productcode)and(Type)
Type field is only two value (TRUE or FALSE) and (DP) and (RSP).
i have inserted and new field in A
Dear Manoj,
Pl find enclosed the attachment.
Regards,
On Tue, Oct 23, 2012 at 11:18 AM, Manoj Kumar manoj.11...@gmail.com wrote:
Dear Expert,
I have data witch has Text and Number i want to do saperate text and
number in next collume.
man25oj kuma112r ro444ha25n 25s26on7
Regard
kindly share a sample file with groups,,
Regards,
Gawli Anil
On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Dear All,
** **
I have an excel file for which, there is Incentive worked out based on 2-3
parameters for the same Technician.
** **
Pl Share a sample sheet with us
On Thu, Oct 25, 2012 at 9:52 AM, David Grugeon da...@grugeon.com.au wrote:
It seems to me that sorting might be a better approach than a vlookup.
Regards
David Grugeon
On 25 October 2012 14:15, Saravanan sarva0...@gmail.com wrote:
Hi
I need this
Dear Manoj.
Pl find attached sheet.
Regards,
Gawli Anil
On Fri, Oct 26, 2012 at 2:16 PM, Vabz v...@vabs.in wrote:
PFA
Cheers//Vabs
On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote:
Dear Expert,
Please help me to get the currect ans with attached file..
Regard
Pl find attached sheet for you info.
Excuse typo errors...
Regards,
Gawli Anil
On Wed, Oct 31, 2012 at 11:55 AM, Neeraj neerajchauhan...@gmail.com wrote:
Dear Experts,
** **
Kindly find the attached sheet and resolve the problem….
--
Join official facebook page of this forum @
Yes Dear,
Just goto Run type %appdata%
in that goto Microsoft- Excel
there u'll find the old data .
Regards,
Anil Gawli
On Wed, Oct 31, 2012 at 7:39 PM, Paul Schreiner schreiner_p...@att.netwrote:
There are many possibilities, but most depend on your computer system.
Do you (or someone else)
Dear Amar,
open excel sheet
press Alt+f11
insert a module
copy following code
Sub UnHideAllSheets()
For Each c In Sheets
c.Visible = True
Next c
End Sub
and run the macro
On Thu, Nov 1, 2012 at 10:17 AM, amar takale amartak...@gmail.com wrote:
Hi All Champs,
Can anybody tell me how
.
On Thu, Nov 1, 2012 at 10:09 AM, अनिल नारायण गवली gawlianil8...@gmail.com
wrote:
Yes Dear,
Just goto Run type %appdata%
in that goto Microsoft- Excel
there u'll find the old data .
Regards,
Anil Gawli
On Wed, Oct 31, 2012 at 7:39 PM, Paul Schreiner
schreiner_p...@att.netwrote
pls share that sheet with us
On Fri, Nov 2, 2012 at 2:21 PM, Pravin Gunjal isk1...@gmail.com wrote:
*Still waiting for the reply. Thanks.
*
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Thu, Nov 1, 2012 at 12:12 PM
Subject: $$Excel-Macros$$ Fwd: VBA
Pls find Attached
FYI
Regards,
Gawli Anil.
On Mon, Nov 5, 2012 at 11:52 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Dear Group,
I need the macro when I run, it convert the number into comma style plus
decrease decimal to zero.
e.g. 12345678.00 convert to 12,345,678
Aamir Shahzad
...@gmail.com
wrote:
Hi,
Use this shortkut key = alt+H+K
On Mon, Nov 5, 2012 at 12:02 PM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Pls find Attached
FYI
Regards,
Gawli Anil.
On Mon, Nov 5, 2012 at 11:52 AM, Aamir Shahzad aamirshahza...@gmail.com
wrote:
Dear Group,
I need
Dear Rajan,
Congrats Dear..keep going...
Cheers.
Regards
Gawli Anil
On Tue, Nov 6, 2012 at 9:58 AM, v...@vabs.in wrote:
**
Congratulations ... Great going!!!
Sent on my BlackBerry® from Vodafone
--
*From: * Ayush Jain jainayus...@gmail.com
*Sender: *
*To:* excel-macros@googlegroups.com excel-macros@googlegroups.com
*Sent:* Tuesday, 6 November 2012 12:11 PM
*Subject:* Re: $$Excel-Macros$$ inquiry
Dear Anil,
thank you very much
Its wonder full man
and were did you hide the picture
*Delin.F*
अनिल नारायण गवली
Dear Amol ,
Pl share a sheet with group.
Thanks Regards,
Gawli Anil
On Fri, Nov 9, 2012 at 12:07 PM, Amol Jadhav asja...@gmail.com wrote:
Hello Experts,
I need your expert advice.
I created a tool using VBA form and OWC 10.0. I am exporting chart which
is on chartspace component(OWC
Dear Sajid,
first see that from different pc can you access manually to that folder
then see the details (the address) and confirm.
Regards,
Gawli Anil
On Tue, Nov 13, 2012 at 2:50 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
I have shared it but it not open from other PC except main
Dear Prince,
Pl share a sample workbook with us.
Regards,
Gawli Anil
On Tue, Nov 20, 2012 at 8:42 AM, Prince prince141...@gmail.com wrote:
Hi Paul,
These numbers of columns in my array.and i wanted to assign this columns
after transposing or after making it rows to a range.
regards
dear Rakesh,
Pl specify you query to understand better.Or share a sample workbook with us
Regards,
Gawli Anil
On Wed, Nov 21, 2012 at 11:47 AM, Prince prince141...@gmail.com wrote:
Hi Rakesh,
Do you want to split data of a cell into multiple cell or somthing else ???
Regards
Prince.
Dear teow,
can u share a workbook with us??
Regards,
Gawli Anil
On Wed, Nov 21, 2012 at 4:34 PM, Teow teow...@gmail.com wrote:
when i use C:\test\[WSO_Record.xls]Record, the script can run propriety,
but if change to network pathThisWorkbook.Path
\[WSO_Record.xls]Record, i will get
Dear Yogi,
first u have to set the page,custom setting then as u go to another
workbook in the page setup u can user the last custom setting which u had
set before.
Regards,
Gawli Anil
On Thu, Nov 22, 2012 at 12:35 PM, yogiyogi123 yogiyogi...@gmail.com wrote:
Hi all..
i have a
pls share the workbook with us
On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
i need the formula for text enetered in sheet with red color
On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara
ashishbhalar...@gmail.com wrote:
Dear expert,
I have a data in
Pls find attched sheet for you reference.
Regards,
Gawli Anil
On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
i need the formula for text enetered in sheet with red color
On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara
ashishbhalar...@gmail.com wrote:
colour.
-- Forwarded message --
From: अनिल नारायण गवली gawlianil8...@gmail.com
Date: Fri, Nov 30, 2012 at 12:26 PM
Subject: Re: $$Excel-Macros$$ Re: Formula need to calculate sum on
conditional base
To: excel-macros@googlegroups.com, Ashish Bhalara
ashishbhalar...@gmail.com
congrats dear.
Regards,
Gawli Anil
On Tue, Dec 4, 2012 at 12:00 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Heartly Congrats Paul :)
On Monday, 3 December 2012 23:58:06 UTC+5:30, Ayush Jain wrote:
Dear members,
Paul Schreiner has been selected as 'Most Helpful Member' for the month
Dear excellerner,
Use $ sign to make constant row or column .
for eg
if u select A1 A10 then write $A$1 $A$10.
first $ is for column and second $ is for row.
you can use only one $ for only one column like $A1 or you can use only one
row like a$1 .
Regards,
Gawli
On Mon, Dec 10, 2012 at 12:31
Dear Neeraj,
Pl find attached.
Regards,
Gawli
On Wed, Dec 12, 2012 at 12:28 PM, neeraj chauhan neerajchauhan...@gmail.com
wrote:
Dear Experts,
kindly find the attached sheet. i want to make the conditional format, but
how to make. revert me
--
Join official Facebook page of this forum @
pls provid the sample data.
Regards,
Gawli Anil
On Thu, Dec 13, 2012 at 12:10 PM, SHAIL GROUPS shail.gro...@gmail.comwrote:
Respected sir,
i want to use pivort table in multi sheet of excel
2007
--
*[image: i love you]*
**
**[image: -][image: -][image:
Dear Sanjay,
U cannot give same name to two sheets. And while inserting the default name
will be Sheet and the number .
II'm guessing that u want the name while inserting a blank sheet . a name
which is defined by U and not the excel program.
If i'm guessing right then logic is
*Sub
Congrats to my friends.
Regards,
Gawli Anil
On Mon, Dec 17, 2012 at 7:37 AM, SHREYAS GUPTA shreyasvgu...@gmail.comwrote:
Sir,
If the above link is not working please use this link-
http://www.vertex42.com/Files/download/exclusive.php?file=yearly_event_calendar.xlsx
Regards
Shreyas Gupta
Wish U a Very Merry Christmas to all my forums friends.
Regards,
Gawli Anil
On Wed, Dec 26, 2012 at 9:59 AM, Satendra kumar
satendrakuma...@gmail.comwrote:
Merry Christmas
On Tue, Dec 25, 2012 at 11:25 AM, Dhaval Shah todhavals...@gmail.comwrote:
Merry Christmas
--
Thanks Regards
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 prince141...@gmail.com wrote:
Hi Rajesh,
There is no data in the sheet.
:(
regards
Prince
On Wednesday, December 26, 2012 5:28:24 PM
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
tharwani.ro...@gmail.comwrote:
Hie Experts ,
PFA of Daily Consumer daily sales i need urgent help from your side
..in report sheet i have put formulas in
hey Noorian code is working f9.
Regards,
Gawli Anil
On Fri, Dec 28, 2012 at 2:48 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Dear Noorain Sir and Group,
Still waiting for recification of the query.
Aamir Shahzad
-- Forwarded message --
From: Aamir Shahzad
Dear Noorian,
Wish U a very happy birthday:) Mag God bless u.
Thanks,
Gawli Anil
On Wed, Jan 2, 2013 at 8:37 AM, Prince prince141...@gmail.com wrote:
Happay b. day Noorain Bhai. May god bless you lots of happiness ahead.
Regards
Prince
On Wednesday, January
On Wed, Jan 2, 2013 at 9:47 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote:
Dear Noorian,
Wish U a very happy birthday:) Mag God bless u.
Thanks,
Gawli Anil
--
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Join
Dear Manoj,
If u want to remove only white space then use Substitute like given below.
=SUBSTITUTE(A1, ,)
Regards,
Gawli Anil
On Wed, Jan 2, 2013 at 12:15 PM, Prince prince141...@gmail.com wrote:
Hi Francis,
This formula cut the string from first charactor up the number of numeric
value
Hi Hilary,
As u r insered too-much formula it will hang the pc, because if u change
any cells value of simply edit that cell the processor calculate all the
fomula cell and hangsup.
simple way is to copy the formula values and paste it as simple values. but
from this it will not change the
Dear Dhaval,
Hide the formula bar which is availabale in options tab of workbook.
Thanks Regards,
Gawli Anil
On Fri, Jan 4, 2013 at 2:46 PM, Dhaval Shah todhavals...@gmail.com wrote:
Dear friends
i am lookking for solution 4 Lock work sheet if i am lock work sheet then
i m not able to
PFA..
On Wed, Jan 9, 2013 at 1:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hope the attached file can help you better.
Regards,
Anoop
Sr. Developer
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
heartly congratulations prince.
Warm Regards,
Gawli Anil
On Fri, Jan 11, 2013 at 11:04 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Congrats Prince Babu...
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
Pl provide a meaningfull subject.
Warm Regards,
Gawli Anil
On Fri, Jan 11, 2013 at 10:57 AM, joginder kumar jaihumtu...@gmail.comwrote:
HI GUROPS MEMBER ,
PLEASE HELP REGARDING THIS SHEET .
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Dear Satendrakumar,
use this =CONCATENATE(A1,B1,C1,D1)
if u want , in between.
or else share the workbook wit us.
Warm Regards,
Gawli Anil
On Fri, Jan 11, 2013 at 11:45 AM, Satendra kumar
satendrakuma...@gmail.comwrote:
Dear Expert,
Solve this query..i want automate colored range. if
Hi Chaya,
Welcome to our Groups.fell free at any time to ask regarding about
excel.
Warm Reagrds,
Gawli Anil
On Fri, Jan 11, 2013 at 3:08 PM, Prince prince141...@gmail.com wrote:
Hi Chaya,
Welcome in the group :)
Regards
Prince
On Friday, January 11, 2013 3:01:45 PM UTC+5:30,
Dear All,
actually my bro has deleted the source data. befor he has deleted i had
made a pivot table after that he deleted the souce data.
Now i want that data back . is there any solutions.
--
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Join
extract the pivot cache data from there.
Regards,
Anoop
On Mon, Jan 14, 2013 at 12:05 PM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Dear All,
actually my bro has deleted the source data. befor he has deleted i had
made a pivot table after that he deleted the souce data.
Now i want
.
If this doesn't work then there is no hope to retrieve all the data.
Good luck
On Mon, Jan 14, 2013 at 2:16 PM, अनिल नारायण गवली gawlianil8...@gmail.com
wrote:
dear ,
But it only shows that much data the field which i have clicked . I want
all the data.
Warm Regards,
Gawli Anil
On Mon
pl share a worksheet with us
On Tue, Jan 15, 2013 at 1:45 PM, vikin...@gmail.com wrote:
**
Hi prince
Will you please help me.
I have three different excel file and each excel file have three different
wrk sheet. I need to link or copy all data in one excel file from these
different wrk
pl find attached herewith.
Warm Regards,
Anil Gawli
On Tue, Jan 15, 2013 at 1:07 PM, Prince prince141...@gmail.com wrote:
Hi Prabhakar,
paste the following formula.
=SUMIFS(C2:C10,A2:A10,Fax,B2:B10,Brown)
Regards
Prince
On Tuesday, January 15, 2013 12:40:13 PM UTC+5:30, Prabhakar S
I'm ready.. dear.
Warm regards,
Gawli Anil
On Wed, Jan 16, 2013 at 12:31 AM, TJ teresa.giova...@gmail.com wrote:
I am reaching out with the hopes of networking with VBA Excel programmers
in the San Fran area.If you know of anyone looking for an opportunity to
work on a project for a
Pls find attached ,
Is it ok???/
Thanks Reagards,
Gawli Anil
On Tue, Jan 15, 2013 at 4:37 PM, Eugene Bernard eugene.bern...@gmail.comwrote:
Dear all,
Please find attached an excel workbook, having 2 sheets. In this REQT
sheet, I need to fill in the column C with the quantities available
Dear Amit,
U can use conditional format for each col in that u can use format only
rows that contain lessthanequalto and in formula write =min(range) and
format cell color to desire color.
Regards,
Gawli Anil
On Wed, Jan 16, 2013 at 1:24 PM, Amresh Maurya amreshkushw...@gmail.comwrote:
hey sorry click on From Web not From Access
sorry for inconvience caused..:(
Warm Regards,
Gawli anil
On Wed, Jan 16, 2013 at 4:06 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
first of all go to data tab
there u'll find from access
there enter the URL and import that content
1 - 100 of 233 matches
Mail list logo