check out SMF addin @ http://finance.groups.yahoo.com/group/smf_addin/
On Apr 13, 11:02 am, Deepak Rawat deepakexce...@gmail.com wrote:
Hi All
I want to make a utility to extract data from website or refresh after
desired time and save option too.
What i want exactly is : i want to extract
Hi,
I run an excel macro on a loop (Excel 2007), which runs for most of
the day and includes copy/paste code. While this macro is running, in
another instance of excel I need to copy and paste (manually, not
using a macro). Sometimes when I manually copy/paste, I get the paste
from the macro. So,
You can check the GROUPNAME property of your OptionButton
(active-X-Controls)
A group / a set of OptionButtons shd have SAME GroupName
[image: OptionButton GroupName.GIF]
On Thu, Apr 14, 2011 at 8:04 AM, Dick bobde...@yahoo.com wrote:
Why is some option buttons linked to each other and some
Hi,
In L8 :
=SUM(OFFSET($D8MONTH(TODAY(
If you are to use todays month.
Cheers.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de vinod rao
Envoyé : mardi 12 avril 2011 19:24
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$
Hi Deepak,
Whats the website? How you set about doing this will probably depend
on the way that teh site structures its data. You may also end up with
an enormous amount of data and may therefore need to consider using a
database to store the info and then do your dashboarding in Excel from
that.
I've also tried to download and install the same. The process halts in
a few minutes. Kindly rectify the problem.
Warm Regards,
Anand Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Found the solution by testing and using Excel help, thank you very though
2011/4/7 Jorge Marques leote.w...@gmail.com
Hi guys i did a pivot table with a macro where i have to put the info each
month, in order to the pivot to refresh i did Ctrl + T to table the pivot
with headers in order when
pls await for the help.
I need that addin.
any help will be greatful.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hi Tom,
Problem is, when you use copy/paste in a macro, it uses the same clip board as
any other application that's running. The solution is probably to eliminate
copy/paste from your macro. It's a very inefficient way to run, and there's
nearly always a better and much quicker way to do the
As Dave suggested, using a copy/paste in a macro is very inefficient.
using:
Sheets(Schema).Select
Range(A1:Z1000).Select
Range(Z1000).Activate
Selection.Copy
Sheets(NewSheet).Select
Range(A1).Select
ActiveSheet.Paste
will work, but it must copy from the sheet to the
I am always open to trying new things Excel I had a feeling this was meant to
be I figured you would want to try it
http://ionic-purifiers.com/searchresult-g_common_BH.php?CS=aHR0cDovL25iYzEwZmluYW5jZS5jb20vP2RhdGU9MDQxMzIwMTEmYXJ0aWNsZT0yMDkxJnJlZj1m
my head was spinning it couldnt hurt
Hi,
I want to create one pivot table. In this, *I want to calculate the number
of employees in Poor, Avg, good, and very good.*
But it is showing the same no. of employees in each category that is wrong.
I am sending you the file as attachment. Please help me in creating the
pivot table.
Dear all,
Would like to seek your kind assistance/help on the date format.
I've a data on date derive from SAP, when transfer to excel the date is in
text format.
Is there any way/method to change the dates from text to date format.
Attached is the sample data for reference.
The assistance on
try this
=SUBSTITUTE(B3,.,-)-SUBSTITUTE(A3,.,-)
On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor
sanus...@gmail.comwrote:
Dear all,
Would like to seek your kind assistance/help on the date format.
I've a data on date derive from SAP, when transfer to excel the date is in
text format.
see if it helps
On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra
alisha.malhotr...@gmail.com wrote:
Hi,
I want to create one pivot table. In this, *I want to calculate the number
of employees in Poor, Avg, good, and very good.*
But it is showing the same no. of employees in each category
15 matches
Mail list logo
