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 cat
try this
=SUBSTITUTE(B3,".","-")-SUBSTITUTE(A3,".","-")
On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor
wrote:
> 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
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 th
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.
*Pleas
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 anythin
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 shee
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 sam
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 Lin
Found the solution by testing and using Excel help, thank you very though
2011/4/7 Jorge Marques
> 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 i put info it p
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 tips
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.
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$$ Exc
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 wrote:
> Why is some option buttons linked to each other and some not? I have 2
> t
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, t
check out SMF addin @ http://finance.groups.yahoo.com/group/smf_addin/
On Apr 13, 11:02 am, Deepak Rawat 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 share prices from
15 matches
Mail list logo