Hi
I would like to use the 'File-Open' command in Excel to bring in a pdf
file and have it finish up in .xls format. Is there an add-in to do this
automatically or a vba way to have it converted. Most of the on-line
require the conversion to excel to be done before and creates its own
workbook
Dear Sam & Don Guillett
Thanks for more supports , i learn and understand that commands .
Thanks with
Mothilal.J
On Sat, Nov 12, 2011 at 10:20 PM, Sam Mathai Chacko wrote:
> If you give a name to those cells, for example InputCell, then you could
> clear contents for that range by simply
>
>
Pivot table can give you a summarized result. Would be easier to use, and
quicker than VBA, and it can also accommodate data automatically if the
source is assigned using a dynamic range.
Anyway, a simple example of a pivot for your data is attached.
Regards,
Sam Mathai Chacko
On Sat, Nov 12, 2
A simple macro to clear the ranges
Range("D6:D25,F6:G25,J6:P25,T6:W25,Z6:Z25").ClearContents
Don Guillett
SalesAid Software
dguille...@gmail.com
From: jmothilal
Sent: Saturday, November 12, 2011 9:04 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ SUM Reg.
Dear Excel membe
=SUMIF(D2:D21,"STOCK",G2:G21)
=SUMIF(D2:D21,"SALES",G2:G21)
On Sat, Nov 12, 2011 at 4:43 PM, Sam Mathai Chacko wrote:
> Here's a link
>
>
> http://windowssecrets.com/forums/showthread.php/109039-sumproduct-explained-with-double-unary-operator-%282003%29
>
> Do a search for Unary operators with
Hi guys ,
i would like you to asked one question
On one workbook i have lots of object like table charts, pivots etc
what all i want that on run time my macro go into each sheet and identify
the object if its drowning object we should create new workbook for all
drowning object if chart then ne
I triedbut that did not worked..
Master.. can u all please help..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Kiran Kancherla
Sent: 10 November 2011 23:37
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to recover ppt file saved
Here's a link
http://windowssecrets.com/forums/showthread.php/109039-sumproduct-explained-with-double-unary-operator-%282003%29
Do a search for Unary operators with Sumproduct, and you'll get quite a few
examples
Regards,
Sam
On Sat, Nov 12, 2011 at 4:41 PM, Sam Mathai Chacko wrote:
> -- or +
-- or ++ or a multiplication / division by 1, or a power by 1 etc are all
working as unary operators. So for example, a boolean value TRUE/FALSE can
be converted to either 1 or 0 respectively by using unary operators. And
since two minuses makes a positive, it is the same as multiplying with 1 or
d
Hi vijay,
there is no need to attc. file. because as you know that I have 10 branches
in other stations and i have to check e-mail, of their details, if i not
found their mail than i have to call them.
so i want to that i open my file and press a key and all 10 reports marge
in my file as sheet an
Hi anil,
I am not getting. can you attach a sample file .?
Thank you
On Sat, Nov 12, 2011 at 2:06 PM, anil kumar wrote:
> Hi experts,
>
> I have a queary I have 10 branches in differents citys. and I gate report
> daily in excel about their daily work. so I want to know that is it
> possib
Hi experts,
I have a queary I have 10 branches in differents citys. and I gate report
daily in excel about their daily work. so I want to know that is it
possible that every staff make their reports and in one time i will gate
all reports in one file. If it is possible plz help me.
Thanks
Anil
---
anil kumar wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-ed00186c8a-2c9d1a2514-jUDbAQxFqhloVHQgXkh0spN44cU
You'll nee
---
anil kumar wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-ed00186c8a-9a18705217-KDNPrlJxRbc1K4HvUzHAJzozFCI
You'll nee
14 matches
Mail list logo