Its OK Anish, I can understand the frustration...
I am also sorry for my hard words..
CHEERS!!
Andy
On Fri, Nov 13, 2009 at 9:09 PM, Anish Shrivastava wrote:
> Thanks Aindril for your help.
>
> N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later
> tht it wasnt a right way..
It's pretty easy to get the first part except:
Where does the "session" data come from?
Can you send me a file with more data to work with?
Otherwise, I have to spend more time creating "test" data than doing the coding!
Paul
From: Jitender
To: jainayus...@g
Hi
Use this in X5
=SUMIF($T$5:$T$717,"<="&X3,$M$5:$M$717)
And this in Y5
=SUMIF($T$5:$T$717,"<="&Y3,$M$5:$M$717) - SUMIF($T$5:$T$717,"<="&X3,$M$5:$M$717)
Then copy the Y5 formula and paste it in Z5 to AF5
Regards
Sandeep
- Original Message -
From: Shraddha Shah
To: excel-macros@
Hi,
I import a worksheet into a workbook on a regular basis. The worksheet
has some predefined Row and Column Groupings. Using code I want to
manage which rows are displayed and which are not.
Some the rows I want to hide and those I do want to display are at
different levels so a blanket rule li
Hello again!
This VBA code create 4 pivot table based on the same data cache;
This is exactly what you have asked !
>Want:
>a) vba routine to ensure that all pivots are based on the same pivot
>cache
>b) select one "mother pivot" cashe to be used by all pivots table
Regards
--
On 11/12/09, Jitender wrote:
> DEAR SIR/GURUS
>
> PLEASE SOLVE THE PUZZLE IN FILE . TRANSPOSE IS NOT A GOOD SOLUTION
>
> THANKS
> --
> Jitender
>
> --
> --
> Some important links for excel users:
> 1. Excel and VBA Tut
Thanks Aindril for your help.
N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later
tht it wasnt a right way...was kinda frustrated in office.. :(
On 11/13/09, Aindril De wrote:
>
> Dear Anish,
>
> You would need a UDF for this:
>
> Use the following code :
>
> Option Explic
Hi
Its because you have protected the workbook.
Unprotect it
Press Alt+t p w and then provide the password and then try :)
Hemant Hegde
2009/11/12 mahesh parab
> Dear All
>
> In attach sheet when i try to unhide sheet i am getting caption error.
> steps are mention on below mention link
>
>
Hi
I don't know the exact reason for this problem. But I can suggest you to use
HYPERLINK() Formula.
Using this, you can make the hyperlinks dynamic, more stable (as u say it
isn't right now) and intelligent!
It can be little difficult but its is not a rocket science. You can google
it or attach
The workbook is protected with a password.
Norman May
On Thu, Nov 12, 2009 at 11:09 AM, mahesh parab wrote:
> Dear All
>
> In attach sheet when i try to unhide sheet i am getting caption error.
> steps are mention on below mention link
>
> http://www.ehow.com/how_2132122_worksheet-another-user-
sorry.. I'm not much help there.
I've never used .XLL files, and I'm HEAVILY into VBA...
Perhaps someone else can give you the help you need.
BTW: What version of Excel are you using?
Paul
From: Hemant Hegde
To: excel-macros@googlegroups.com
Sent: Thu, Nove
yes, that's fairly simple.
But, since you didn't give us much to go on, I'll have to be pretty generic and
make lots of assumptions.
first of all, you'll need a macro (since you wrote to this group, you probably
already knew that)
I'll "assume" that the calender of events is on a sheet called "
Yes, please,
why do you need a "macro" to protect a cell?
Do you understand how to lock a cell end turn on Protection?
the manual process is:
Select all cells in a worksheet.
Select Format->Cells
On "Protection" tab, remove check from "Locked" checkbox
In Excel2007, the Protection is on the "R
Hi Anish,
See the attached file. Don't change position of 'Auto Reset', 'Counter' and
'Auto Switch' else it may not work properly.
Also it can be done easily with VBA, so if you need then ask the solution in
VBA and you will get a quick response from the group.
Regards
Sandeep
On Fri, Nov 13, 2
Debashish, Could you please elaborate the requirement. If possible with an
example workbook.
Regards,
Andy
On Fri, Nov 13, 2009 at 5:03 PM, DEBASHIS BANERJEE
wrote:
>
> Dear Friend,
>
> I need a Macro to Protect Cell of a work Sheet . Kindly help . it is
> Urgent .
>
> Thanks and regards
>
>
Hi Punit,
Thanks for you helping attempt, but tht's not wht I want. You used just
vlookup in 2 cells...I m afraid to say tht but even I know tht much of
basics (No offence). Could you please let me know wht if the occurance is 3
times. :P
Cheers!!
ANISH
On Fri, Nov 13, 2009 at 3:06 PM, punit pod
Hi Guys
I needs your help, actually I have an excel file that basically
contains date and the things to do on that date. e.g.
10/nov/09 - attend marriage
11/nov/09 - visit client
10/nov/09 - test
and so on, now I want that whatever the to dos are there in the excel
file to be done today (it may
-- Forwarded message --
From: DEBASHIS BANERJEE
Date: Nov 12, 2009 1:34 PM
Subject: $$Excel-Macros$$ Problem with Hyperlink
To: excel-macros@googlegroups.com
Dear Friends ,
I have workbook having multiple sheet. Each Page is connected with Hyperlink
. Problem is that as soon as t
Dear Friend,
I need a Macro to Protect Cell of a work Sheet . Kindly help . it is
Urgent .
Thanks and regards
Debashis.
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Fre
Hi
You can use the file attached below:
Punit
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http:/
Hi Guys
I needs your help, actually I have an excel file that basically
contains date and the things to do on that date. e.g.
10/nov/09 - attend marriage
11/nov/09 - visit client
10/nov/09 - test
and so on, now I want that whatever the to dos are there in the excel
file to be done today (it may
Hello Experts,
Once agian I am here with a new problem (Thanks for helping me earlier, on
my code).
This time I am stuck with Vlookup, actually I have a list of lot # for which
I have to find TIC # from another table but the problem is it has got
multiple occurances. Our simple vlookup picks the
hi Prashanth
Please find attached file as per your requirement.
Dhartikumar
On Thu, Nov 12, 2009 at 6:36 PM, Prashanth Banneni wrote:
> Hi All,
>
> Can you help me how to get the desired output from the attached sheet.
>
> Many thanks in advance
>
> Best
> Prashanth
>
> --
>
> -
23 matches
Mail list logo