Dear Raj Kumar,
Pls find attached herewith.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Fri, Oct 11, 2013 at 3:48 PM, Raj Kumar rajlu...@gmail.com wrote:
Hi Guru,
We have to calculate based on id of Raj Mohan through
Dear Harisha,
The files which u have sent is in different format. kindly send proper format.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Oct 9, 2013 at 2:54 PM, Hari harisha.prabha...@gmail.com wrote:
Dear Excel
Dear Friends,
I had made a macro, then created a new customized ribbon and assigned
it with this macro. Problem is whenever i click on the ribbon to run
the task then the original file where the macro is created is opening
simulteneously. My idea is it should not open the file and only run
the
Dear Friends,
Sorry for distrubing you . The solution has been resloved now.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Sep 26, 2013 at 12:29 PM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Dear Friends,
I
Dear Friends,
i have to convert the time to given format . format is as follows.
Time Output
08:590859
17:001700
15:30 1530
17:05 so on.
13:12
00:00
08:57
17:15
08:55
17:10
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Are
this formula
=TEXT(A12,hhmm)
On Wed, Sep 25, 2013 at 12:13 PM, अनिल नारायण गवली gawlianil8...@gmail.com
wrote:
Dear Friends,
i have to convert the time to given format . format is as follows.
Time Output
08:590859
17:001700
15:30 1530
17:05 so on.
13:12
00:00
08:57
Dear Junaid,
Kindly attach the error file .
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 25, 2013 at 12:26 PM, Junaid junaid.an...@gmail.com wrote:
Hi guys,
I am working on Excel 2007 macros. My requirement is
Dear Deepak ,
But here the outtime is missing
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 1:33 PM, Deepak Singh dpk85si...@gmail.com wrote:
Try this code..
Sub test()
Application.ScreenUpdating =
Dear Deepak ,
See the Output file outitme is mentioned in the same field of Time field.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 2:26 PM, Deepak Singh dpk85si...@gmail.com wrote:
Hi Anil,
You
Dear Ashish,
See d attached workbook.
Wam Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Sep 23, 2013 at 11:48 AM, Ashish Kumar
kumar.ashish...@gmail.com wrote:
Dear Seniors,
I want total count of unique User ID's.
Dear Friends,
As i had attached two files one is the source file named Attendance
workbook and another is output .
in attendance file there are no. of sheets which contain all the
attendance data.
I want that data should convert as output file as attached with the
name output file.
Note : In
Dear Indrajit,
Kindly send it across the Slave files also so that we can test it from out side.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 3:48 AM, Indrajit $nai talk2indra...@gmail.com wrote:
Hi
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 10:01 AM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Dear Friends,
As i had attached two files one is the source file named Attendance
workbook and another is output
Dear Melimob,
Pl share a workbook with us.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 18, 2013 at 12:29 AM, Melimob melissasobrien...@gmail.com wrote:
Hi all
I am new to this group so I hope someone can
Dear Indrajit
Workbooks.Open fil,,false
Try using above code .
Pl reply
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai talk2indra...@gmail.com wrote:
Hi Experts,
I am facing
Dear Prabhu,
Pl see the attached sheet.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky prabhupin...@gmail.com wrote:
Hi Experts,
Please find the attached file, please revert
Dear Shrinivas,
u can also use =VLOOKUP(F3,A3:E13,COLUMNS(A3:E3),0)
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Sat, Sep 14, 2013 at 11:07 AM, Shrinivas Shevde
shrinivas...@gmail.com wrote:
Dear Ashish,De Premor,Ravi
Dear Prabhu,
In place of Sheet2 write
Sheets(2).range(A10).value=1000
Warm Regards,
Gawli Anil.
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 11, 2013 at 11:44 AM, De Premor d...@premor.net wrote:
Give more attention here !
Dear Ashish,
Pl share the workbook with us.
Warm Regards,
Gawli Anil.
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara
ashishbhalar...@gmail.com wrote:
Dear experts,
I have a data columnar and want
Dear Ashish,
Pl see the attached workbook.
Is it ok?
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 11, 2013 at 2:11 PM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Dear Ashish,
Pl share the workbook
Dear Prabhu,
Use this code
Sub sample()
Sheets(sheet2).Range(A10).Value = 1000
Sheets(sheet2).Activate
Sheets(sheet2).Range(A10).Select
MsgBox Task Completed
If MsgBox(Do you want to Clear the data ?, vbYesNo, Confirm) = vbYes Then
Range(A:A).ClearContents
MsgBox Data has been cleared
Else
Dear Saggi,
Pl share the file with us.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Sep 2, 2013 at 11:04 AM, shyam.utha...@gmail.com
shyam.utha...@gmail.com wrote:
Sent from my HTC
- Reply message -
Dear Prajakt Pande,
Has it has lots of rows init. It will take nearly 5 min, so have patients.
Warm Regards,
Gawli Anil.
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 3, 2013 at 10:07 AM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote
Dear Kushlesh,
You can u with countifs(criteriarange,criteria) and enter
Pl find the attached sheet
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Fri, Aug 30, 2013 at 12:04 PM, Kush Shama kushleshsha...@gmail.com wrote:
Dear Waseem,
Mostly font color should be black and cell color should be red for negative.
positive:- font color should be black and cell color should be gree.
Warm Regards,
Gawli Anil.
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Aug 22,
Dear Manok,
Find attached herewith .
Warm Regards,
Gawli Anil.
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Aug 21, 2013 at 2:30 PM, Manoj Kumar manoj.11...@gmail.com wrote:
Please help me.
I have a data like details mention below.
xxx
Dear Rajkumar,
U can use text to columns option .
click on comma checkbox and finish it.
Warm Regads,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Aug 21, 2013 at 2:42 PM, Andrew Mangozho
andrew.mango...@gmail.com wrote:
Another
Dear svenyarl,
Pls share a worksheet with us.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Aug 21, 2013 at 8:13 PM, sveny...@gmail.com wrote:
I sample of the file I receive is as follows:
25727861 GM DLT 1
Dear Shrinivas,
Pl see that u have filter the ext with the following one.
.Filters.Add Excel, *.xls; *.xlsx; *.xlsm; *.xlsb, 1
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Aug 19, 2013 at 2:24 PM, Shrinivas
Dear Ashkan,
on textbox enter event write a code
Me.txtshiptoparty.BackColor = vbGreen
after on textbox exit event write again the same code with different color.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Aug 20,
Dear Chaya,
Pl share a sample sheet with us.
Warm Regards,
Gawli Anil.
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Aug 20, 2013 at 6:00 AM, Chaya Cooper chayacoo...@gmail.com wrote:
A tutorial I'm using (to create a multi-select box)
Dear Nath,
Pl find the attached herewith.
Warm Regards,
Gawli Anil
On Wed, Aug 14, 2013 at 3:09 PM, Gopinath nath@gmail.com wrote:
Dear Shri Satendra Kumar,
Thank you for your suggestion. However, what I wanted is Running
Balance for each Bank - Datewise as well as Grand Total Balance
Dear All,
I have a range.
In that range when i select some range of numbers from other sheets and
paste it in then present range or cell by right click or by just pressing
cltr+V , then it should directly paste it as values. Is there any idea
--
Thanks Regards,
Gawli Anil Narayan
Dear Sundar,
Go to File. Excel Options and change the language fro urdu to English US.
Warm Regards,
Gawli Anil.
On Fri, Aug 2, 2013 at 4:44 PM, Sundarvelan N nsund...@gmail.com wrote:
Dear Friends,
Suddenly my excel language (font) changed from english to urdu. What is
the short cut
Dear Rakesh,
Pl find attached herewith.
Warm Regards,
Gawli Anil.
On Fri, Jul 5, 2013 at 12:02 PM, Rakesh Sharma rksharma...@gmail.comwrote:
Dear Experts
i have two queries in acess 2010 screen shot attached which have data
mention below
i just want to sum both of two queries. pl help
Dear Rekha,
Pl see the attached workbook.
Warm Regards,
Gawli Anil
On Fri, Jun 28, 2013 at 10:36 AM, rekha siri rekha.siri2...@gmail.comwrote:
Hi Experts,
Please help in this concern
i am attaching sample data spread from Column A TO H
in H Column i want to update Status as per below
Dear Souza,
Pl see the attached data is it ok?
Warm Regards,
Gawli Anil
On Fri, Jun 14, 2013 at 12:00 AM, Thiago Souza souza...@gmail.com wrote:
I need to validate an information like this**
** **
__AB_C
Name 1 w w
Name 2 w w
Name
Dear Sajid,
Pl see the attached workbook.
Warm Regards,
Gawli Anil
On Thu, Jun 13, 2013 at 10:19 PM, SAJID MEMON sajidwi...@hotmail.comwrote:
--
From: sajidwi...@hotmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Copy Data by click event
Dear Prabhakar,
See the attached workbook.
Warm Regards,
Gawli Anil
On Tue, Jun 4, 2013 at 4:49 PM, Prabhakar S H prabakar.k...@gmail.comwrote:
Hi Team,
i want to get formula to find Total value of cars with black color only.
pls help.
Rgds,
Prabhakar
--
Are you =EXP(E:RT) or
Dear amar,
Its Reference file will no more valid means its reference file is no loger
exists.
Warm Regards,
Gawli Anil
On Fri, May 31, 2013 at 3:21 PM, amar takale amartak...@gmail.com wrote:
Dear All
Can anybody tell me why Error show while excel file opening.when I open
excel file then
Dear Prabhu,
Are u pressing cltr+then selecting the cells and trying to copy the
things.?
if u selecting the cells vertically or horizontally but in straight line
then it should copy by selecting cltr key.
But if u selecting the cells randomly then it will not copy and throws the
message
Dear Deepak,
Pl elaborate more on this.
Warm Regards,
Gawli Anil.
On Thu, May 16, 2013 at 11:28 AM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi
PFA the i have to add all the balance of three bank between two dates in
Sheet2
Kindly show the way
Regards,
Deepak
--
Are you
Dear Pavansai,
Share the workbook with us.
Warm Regards,
Gawli Anil.
On Wed, May 15, 2013 at 1:57 PM, Pavan Valluru
pavansai.vall...@gmail.comwrote:
Hi There,
This is pavan. Im a Financial Modeler. I need VBA in My work. Now a days i
am getting models which will need macro to update huge
for which i need
to copy share price formula for all those companies inputted in the file
which and for the dates given. please take a look.
On Wed, May 15, 2013 at 2:04 PM, अनिल नारायण गवली gawlianil8...@gmail.com
wrote:
Dear Pavansai,
Share the workbook with us.
Warm Regards,
Gawli Anil
Dear Kaushal,
use this.
SELECT
[name]
,create_date
,modify_date
FROM
sys.tables
Warm Regards,
Gawli Anil
On Mon, May 13, 2013 at 12:36 PM, Kaushal Kumar kaushal.anal...@live.comwrote:
Dear All,
I understand its an excel forum. But just wondering if anybody has
are not splitting in the solction provided to me. Please
check.
Thanks again to all
Regards,
Chaya
The excel learner :-)
On Mon, May 13, 2013 at 3:44 PM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Dear Chaya,
Pl see the attached sheet. Is it OK? let me know?
Warm Regards,
Gawli
Dear Chaya
Pl see the attach sheet
Warm Regards,
Gawli Anil
On Fri, May 10, 2013 at 3:49 PM, Chaya chayamon...@gmail.com wrote:
Dear experts,
I want to copy and paste the same range (A2:A8) multiple times below
the next cell as per the number of copy. and in E1 i have the number
Dear Chaya,
Use this.
Sub delete()
Dim cell, Searchrange As Range
Set Searchrange = ActiveSheet.Range(A1:K100)
For Each cell In Searchrange
If cell.Value = Total Then cell.EntireRow.delete
Next cell
End Sub
On Thu, May 9, 2013 at 12:17 PM, Chaya chayamon...@gmail.com wrote:
Thanks
Dear Sajid,
Pl Elaborate more on this. didn't understood. Pl give eg. in the
attachment.
Warm Regards,
Gawli Anil
On Wed, May 8, 2013 at 6:23 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear Anil sir,
I have seen attachment file, Thanx for responce me. but it's not my
solution. My
Dear Kuldeep,
Pl find attachment.
Warm Regards,
Gawli Anil.
On Wed, May 8, 2013 at 7:37 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Experts,
I have a query, if sheet name is similar, how can create a hyperlink.
query is attached.
I want to via VBA.
Regards,
Kuldeep
--
You
Dear Manthan,
Pls Elaborate More with Eg.
Warm Regards,
Gawli Anil
On Thu, May 9, 2013 at 2:26 AM, Mathan mathan4s...@gmail.com wrote:
Hi Experts,
I'm trying to upload a file from shared folder (directory) to the internet
explorer.
Need a VBA code to do this. Could anyone help me on
Dear Nisha,
Thr r multiple sub function under subtotal function.
Like =subtotal(9,therange) will give u total sum of the range
2) =subtotal(1,therange) will give u average of the range
3) =subtotal(2,therange)will count the nonblank cell
and on..
Warm Regards,
Gawli
Gunjal.
-- Forwarded message --
From: अनिल नारायण गवली gawlianil8...@gmail.com
Date: Tue, Apr 30, 2013 at 4:29 PM
Subject: Re: $$Excel-Macros$$ Export the data from one excel file to other
To: excel-macros@googlegroups.com excel-macros@googlegroups.com,
Pravin Gunjal isk1
Dear Excel learner,
Goto formula click on define name put the ranges and click ok..
Warm Regards,
Gawli Anil
On Tue, Apr 30, 2013 at 9:34 AM, excel learner
knowledgeforex...@gmail.comwrote:
hi All,
please guide me how to declare variable to save the new worbook with
Names listed in A
Dear Sagar,
Can u specify more what u want excatly.
Warm Regards,
Gawli Anil N
On Fri, Apr 26, 2013 at 11:50 AM, sagaraher sagara...@gmail.com wrote:
Hello Anil,
You have helped me last time to create different sheets mail against
given mail-id through macro. I have one more data sheet
Dear Amit,
Pl share the workbook
Warm Regards,
Gawli Anil.
On Tue, Apr 16, 2013 at 11:30 AM, Priti_verma pritiverma1...@gmail.comwrote:
So what do you need ??
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU)
Yes, U can do it by notes.notessession.
Warm Regards,
Gawli Anil
On Wed, Apr 10, 2013 at 1:42 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Can we do the same thing using Lotus Notes
On Fri, Mar 15, 2013 at 10:58 AM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Dear Sagar
Dear Norman,
Before Protecting the entire sheet first goto review and click on allow
users to edit the ranges and then protext the sheet.
Warm Regards,
Gawli Anil
On Tue, Apr 9, 2013 at 3:32 PM, Norman West norman.p.w...@gmail.com wrote:
I am reading Excel 2007 for Dummies in an endeavor to
Dear alanthomas,
Put approximate match or exact match then the result will appear.
=vlookup(value,range,columnno,true,false) or
vlookup(value,range,columnno,1,0)
Warm Regards,
Gawli Anil
On Wed, Apr 10, 2013 at 6:43 AM, Sam Mathai Chacko samde...@gmail.comwrote:
If you want to look for
UTC+1, अनिल नारायण गवली wrote:
Dear Norman,
Before Protecting the entire sheet first goto review and click on allow
users to edit the ranges and then protext the sheet.
Warm Regards,
Gawli Anil
On Tue, Apr 9, 2013 at 3:32 PM, Norman West norman...@gmail.com wrote:
I am reading Excel
Dear Chaya,
Pl see the attached sheet it will help u .
Warm Regards,
Gawli Anil.
On Mon, Apr 8, 2013 at 10:20 AM, Chaya chayamon...@gmail.com wrote:
Dear Experts and folk,
I have been trying to extract numbers and words seperately from
the strings. Manually i did, but taking huge
Pl see the attached sheet.
Warm Regards,
Just run the macro.
Gawli Anil
On Fri, Apr 5, 2013 at 12:57 PM, Abhishek Jain abhishek@gmail.comwrote:
See this.
On Fri, Apr 5, 2013 at 12:42 PM, Chaya chayamon...@gmail.com wrote:
Thanks Abhishek Sir,
Actually, where ever the
Dear Amar,
Pl see the solution is it ok?
Warm Regards,
Gawli Anil
On Fri, Apr 5, 2013 at 5:33 PM, amar takale amartak...@gmail.com wrote:
Dear Experts
I attached Range Solution Sheet with detailed information.Pls give me
proper Guidance for Range.
Regards
Amar
--
Are you =EXP(E:RT) or
Dear Amar,
firstly remove refrence . simple copy the entire cell and paste it as
values .
Step 1) select the entire coloum (D) then press cltr+F.
write 0 and tick mark the option of mark entire cell content and press *
FindAll* button.
Step2) now, at down side u find all the finding references
Dear Kushlesh Sharma,
Pl share the sheet with us.
Warm Regards,
Gawli Anil
On Tue, Apr 2, 2013 at 10:33 PM, Kush Shama kushleshsha...@gmail.comwrote:
I am using multiple sheets in a file. I want to know how to write array
formulas(those that are combination of formulas or have a lot of
Dear Deepak,
Pl see the attached sheet. Is it OK.
Warm Regards,
Gawli Anil
On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi
Kindly find attached ,
i need a graph which change as i select the desired cell.
suppose if i want to see sales then when i wil select
and index formula by
editing your chart without using Macro.
Please confirm the same whether it is correct or not .
Regard,
Prafull Jadhav.
On Wed, Apr 3, 2013 at 10:08 AM, अनिल नारायण गवली gawlianil8...@gmail.com
wrote:
Dear Deepak,
Pl see the attached sheet. Is it OK.
Warm Regards
Dear All,
Any Progress.Pls ...Help.
Warm Regards,
Gawli Anil
On Sat, Mar 30, 2013 at 2:58 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Friends,
From the attached sheets i want the smallest amt soldtocode lookup with
material code
for eg:- now the material code
On Tue, Apr 2, 2013 at 12:28 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hi ,
http://gautamg.wordpress.com/2013/03/30/creating-a-speedometer-in-excel/?goback=%2Egde_82527_member_227695807
On Tue, Apr 2, 2013 at 12:27 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
You can try
Dear Pravin,
u can use it from Group option. Select the sheet by clicking the sheet
name by pressing shift buton goto last sheetname it automatically select
all the sheets and now u can edit the very first sheet simultaneously the
other sheets will be updating. like a carbon copy.
Warm
Thanks friendsfor your efforts.
i used this function.
=INDEX($C$6:$F$20,MATCH(MIN(IF(I8=$E$6:$E$20,$F$6:$F$20)),IF(I8=$E$6:$E$20,$F$6:$F$20),0),1)
with CSE. and it works ...
Warm Regards,
Gawli Anil
On Fri, Mar 29, 2013 at 10:38 AM, Prince prince141...@gmail.com wrote:
sry for
Dear Praful,
It will come with min and if condition.
See the attached sheet.
Warm Regards,
Gawli Anil
On Thu, Mar 28, 2013 at 11:18 AM, prafull jadhav
prafulltjad...@gmail.comwrote:
Dear Prince,
find the same.
Regards,
Prafull Jadhav.
On Thu, Mar 28, 2013 at 9:19 AM, Prince
) it shows false,false,false,true,true.
false means not matched and true means match. in place of false it takes 0
. like 0,0,0,0,0,matched values .
afterwards min(0,0,0,0,07,12) it takes 0 and display .
Regardas,
Prafull.
On Thu, Mar 28, 2013 at 11:34 AM, अनिल नारायण गवली
gawlianil8
Dear Sundarvelan ,
first select the coloum of A then press cltr+f in find place put 9 then
click on find All button. .
Then it will show u how many records found then select all the reference
sheets . By selecting all the reference sheets it will select all the cells
then click on close button.
PM UTC+5:30, अनिल नारायण गवली wrote:
Dear Friends,
I want a small help which is attached.
I want the shiptocode of the smallest amt
--
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Thanks Regards,
Gawli Anil Narayan
Software
Dear SantoshKumar.Subudhi,
Pl see the attach sheet.
Warm Regards,
Gawli Anil.
On Mon, Mar 25, 2013 at 11:35 AM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hello Prafull,
Thank you for your early reply.
The solution provided by you contains only two criteria's ,it does't
Dear Kannan,
Pl find attached herewith.
Wam Regards,
Gawli Anil
On Thu, Mar 21, 2013 at 11:59 AM, kannan excel kannan.ex...@gmail.comwrote:
Hi friends,
Anybody have India's State and Region List with Alpha Code??
for example:
*STATE* *REGION* *CODE* ANDHRA PRADESH KADAPA KAD ANDHRA
Dear Thampan,
Pl find herewith.
Warm Regards,
Gawli Anil
On Thu, Mar 21, 2013 at 12:16 PM, Midhun Thampan
midhun.tham...@gmail.comwrote:
hi all;
i want to create the bubble chart of the following data.
not able to create as all the data is not reflecting.
also the x axis should display
validation and
have to select the mail id in ExcelOutlook sheet.
On 3/19/13, अनिल नारायण गवली gawlianil8...@gmail.com wrote:
Dear Schreiner,
Pl find attached herewith.
Warm Regards,
Gawli Anil.
On Mon, Mar 18, 2013 at 11:59 PM, Paul Schreiner
schreiner_p...@att.netwrote:
so, do you
Dear Anil,
Whr is the data or report ?pl share the base sheet.
Warm Regards,
Gawli Anil
On Mon, Mar 18, 2013 at 6:38 PM, Anil B ank.bira...@gmail.com wrote:
Hi Experts,
find attached the excel sheet
I need ur help to pull up the report by just one click on button with the
help of
Dear Ronmcfarlane,
you should use
=COUNTIFS($B$2:$B$6,H2,$C$2:$C$6,H2)
Because inverted commas excel thinks it is a comment only to display..
Warm Regards,
Gawli Anil
On Tue, Mar 19, 2013 at 9:39 AM, Shuzbut ronmcfarl...@gmail.com wrote:
I have the following formula
Dear Dhaval,
Your file in which u have mentioned some data is in text format. so direct
deoing sum formula will not work. firstly u should convert that text to
value by using following formula.
=value(a1) it gives u a value then do sum function .
It will work
Warm Regards,
Gawli Anil
On
Dear Pravin,
Pl see the enclosed sheet .
Warm Regards,
Gawli Anil
On Tue, Mar 19, 2013 at 10:06 AM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Friends,
Is it possible to make freeze for unique row column at a time for many
sheets?
Hope to get the solution.
Thank you,
Regards
Dear Sagar,
From which mail u want to send the file ? from gmail,yahoo, or from
outlook???
Warm Regards,
Gawli Anil
On Thu, Mar 14, 2013 at 3:29 PM, sagaraher sagara...@gmail.com wrote:
Hello,
I am looking for Macro for filter data send it to respective user
through mail, pl find
Dear Viney,
GoodReally appreciate your first post . that good.Keep it up...
Pls do helping to our forums
Warm Regards.
Gawli Anil
On Thu, Mar 14, 2013 at 4:54 PM, Viney vineyme...@gmail.com wrote:
Hi Shiva,
this is my first post to the group...
try this macro
Sub
Dear Prabhakar,
Ur formular is right just goto formula tab and click on show formula.
I think u have clicked on show formula that's why it shows only the formula.
Once angain click on show formula and see the changes.
Warm Regards,
Gawli Anil
On Wed, Mar 13, 2013 at 3:27 PM, Prabhakar S H
Dear David,
Pl share your file .
Warm Regards,
Gawli Anil
On Thu, Mar 14, 2013 at 5:49 AM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
Using Validation or Combobox.
You upload the File to handle for convenience.
2013/3/14 David Grugeon da...@grugeon.com.au
Use a pivot table. If you
Dear SalesRecruiter,
What we do wit this???
Kindly mention the problem with sharing a sample data.
Warm Regards,
Gawli Anil.
On Tue, Mar 12, 2013 at 7:13 PM, rajan verma rajanverma1...@gmail.comwrote:
what to do with this??
On Tue, Mar 12, 2013 at 7:36 AM,
Dear Karthikeyansankaran,
Goto sheet view code their select worksheet from dropwdown.
Write the code .
ActiveCell.Interior.ColorIndex = 36
Warm Regards,
Gawli Anil
On Sun, Mar 10, 2013 at 5:53 PM, karthikeyan sankaran
karthikeyansankar...@gmail.com wrote:
Hi,
How to highlight ActiveCell
Dear Amar,
Now it automatically select the row.
Pl see the attachment.
IS it OK?
Warm Regards,
Gawli Anil.
On Mon, Mar 11, 2013 at 1:55 PM, amar takale amartak...@gmail.com wrote:
Dear Anil
Can you solved my issue?
On Thu, Mar 7, 2013 at 4:33 PM, amar takale amartak...@gmail.com wrote:
Dear Rahim
Pl specify your problem little bit more.
Warm Regards,
Gawli Anil
On Mon, Mar 11, 2013 at 11:29 PM, Rahim Sharieff
rahim.shari...@gmail.comwrote:
Hi,
Please find the attached workbook.
1. There are two tabs Test 1 and Test 2
2. The Header row is in row 5 and the data starts
Dear Manjunath,
Pl elaborate some more.. didn't understood
Warm Regards,
Gawli Anil
On Fri, Mar 8, 2013 at 7:13 PM, Manjunath Narayanappa
manjunath.narayana...@aon.co.uk wrote:
Anil,
Can I use same for existing sheet.
Example : I have an data in 2nd row followed by 8 columns
Dear Rakesh,
Pl find attached herewith FYI.
Warm Regards,
Gawli Anil
On Fri, Mar 8, 2013 at 3:53 PM, Rakesh Sharma rksharma...@gmail.com wrote:
can we arrange rearrange spellings in Excel column.
like i want to arrange my name
hsekar to rakesh
--
*
Dear Manjunath,
Enclosed herewith the required file and check is it ok??
Warm Regards,
Gawli Anil
On Fri, Mar 8, 2013 at 4:32 PM, Manjunath Narayanappa
manjunath.narayana...@aon.co.uk wrote:
Dear Experts,
I have spreadsheet, in which I will be updating the data i want same
pls share the data
On Wed, Mar 6, 2013 at 2:45 PM, xlstime xlst...@gmail.com wrote:
please share required field
.
Enjoy
Team XLS
On Wed, Mar 6, 2013 at 2:09 PM, kannan excel kannan.ex...@gmail.comwrote:
hi friends i want courier management data format in
'=Sheet3()' but not working
Am I wrong in calling that function
On Wednesday, March 6, 2013 4:23:02 PM UTC+5:30, अनिल नारायण गवली wrote:
Dear Anu,
Sorry for wrong file. here is the file.
Warm Regards,
Gawli Anil.
On Wed, Mar 6, 2013 at 4:18 PM, अनिल नारायण गवली gawlia...@gmail.comwrote
Dear Pravin,
Pl share the workbook .
Warm Regards,
Gawli Anil
On Tue, Mar 5, 2013 at 6:56 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hello Friends,
Pl note, I am using the following VB code to gather the data from
different sheets. Once it was worked fine. But now whenever I am trying
pls give some more query ...
Warm Regards,
Gawli Anil
On Mon, Mar 4, 2013 at 11:50 AM, amar takale amartak...@gmail.com wrote:
Dear Experts Team
I have small query in excel,i give detail information in Attached sheet
Pls sloved my query
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
pls see the attached sheet is it ok?
Warm Regards,
Gawli Anil
On Mon, Mar 4, 2013 at 12:24 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
pls give some more query ...
Warm Regards,
Gawli Anil
On Mon, Mar 4, 2013 at 11:50 AM, amar takale amartak...@gmail.com wrote:
Dear Experts Team
Dear Amir,
Pl find enclosed herewith .
Warm Regards,
Gawli Anil
On Wed, Feb 27, 2013 at 1:43 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Hi Group,
I need the Macro, when I run, it insert the blank rows but ask me by
message box How many when I give number e.g. 15, macro insert the
1 - 100 of 233 matches
Mail list logo