Hey everybody,
I'm hoping for some help with the following. I have an Excel file that
has about 20 sheets and nearly every single one contains a pivot table
that pulls data from an external Access database. The pivot tables
then feed reports that are on the same page as each pivot table is.
In my
Hello to all! I'm new in the group
I've got trouble with enveloping of polylines defined point to point.
Example:
Polyline A
x y
0,0 0,0
5,0 0,7
12,00,7
16,01,5
25,01,5
30,00,7
40,00,7
50,00,4
60,00,3
Polyline B
x y
0,7 0,3
0,8 0,5
1,0
Thanks, worked like a charm. I fiddled a bit with the code to make it
do all sheets in one go.
The example was a great help.
Joost
--
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks a
*Hope this helps*
[image:
?ui=2&view=att&th=126281972feb624d&attid=0.1&disp=attd&realattid=ii_126281972feb624d&zw]
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Wed, Jan 13, 2010 at 5:40 PM, Sir Digby Chicken Ceasar <
petercros...@googlemail.com> wrote:
> Hi
>
> Sorry for of
Hi
Sorry for off topic as this has nothingto do with VBA or MACROS.
Please could someone tell me how to change the source data range on a
pivot table in excel 2007?
I've set up a pivot table which sources data from a list but I've now
added more to the list and don't want to have to re-make the
hi rahul
be specific to your question
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Jan 13, 2010 at 5:02 PM, Dilip Pandey wrote:
> Dear Rahul,
>
> Please explain what column or what data you want to v-lookup,
Thanks Dilip!!! :-)
On Wed, Jan 13, 2010 at 5:08 PM, Dilip Pandey wrote:
> Good One..!! :)
>
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On Wed, Jan 13, 2010 at 11:44 A
Dear Mahesh,
Please find attached soluation
Thanks
Sachin Shukla
On 1/13/10, Mahesh wrote:
>
> Dear Friends,
>
> I need your help,
>
> I have to prepare the monthly Reports in which the heading contains the
> name of last month.
>
> For Example:-
>
> 1. If I am preparing report in Ja
Hello Friends,
Can i get a help for said query?. Thanks in advance.
On Wed, Jan 13, 2010 at 1:18 PM, vinod rao wrote:
> Hi Ankur,
>
> This dont work because i have 25 thousands of lines items one below another
> and it takes long time to refresh page.
> So better have vba programmed for getting
OK.. "assuming" that the columns with the Data are: A, B, C, etc...
You can use:
Option Explicit
Sub xlate()
Dim cnt_students, cnt_rows, newRow, R, C
Dim DataSheet, RepSheet
DataSheet = "Sheet1"
RepSheet = "Sheet2"
cnt_students =
Application.WorksheetFunction.CountA(Sheets(Da
Good One..!! :)
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Jan 13, 2010 at 11:44 AM, kvc praveen kumar wrote:
> Hello Allen,
>
> I guess the excel from which you are getting thadates
Ankur, You are welcome..!!
Let me know if you face any difficulty.
Thanks & Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Jan 13, 2010 at 3:57 PM, ankur wrote:
> Thanks Dilip Sir
>
> n
Thanks Ankur,
Explanation of Offset function:-
=OFFSET(Sheet1!$F$1,0,0,COUNTA(Sheet1!$F:$F),COUNTA(Sheet1!$1:$1))
In the above formula, last two COUNTAs are increasing the range downwards
and toward right. So ultimately the range is increasing from F1 to left,
till row 1 has data and to down, ti
Dear bas001,
You are welcome..!!
Let me know if you face any challenge in implementing the same in your
solution.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Jan 13, 2010 at 1:00 AM,
hi mahesh
this will help u
="For the month of "&" "&TEXT(EOMONTH(TODAY(),-1),"mmm,")
On 1/13/10, ankur wrote:
> hi mahesh
>
> Sorry for geting your question wrongly, my answer will get only present
> month.
>
> On 1/13/10, ankur wrote:
>> hi mahesh
>> write this formula in your coloum head
hi maulik desai
plz check this addin
i will break all excel protection
On 1/13/10, Mahesh Kumar wrote:
> Send your excel file
> regards
> Mahesh
>
> On Jan 10, 3:32 pm, maulik desai wrote:
>> Hi,
>>
>> Can any one provide me the password breaker or macros or any tool which
>> can
>> break t
hi mahesh
Sorry for geting your question wrongly, my answer will get only present month.
On 1/13/10, ankur wrote:
> hi mahesh
> write this formula in your coloum heading
>
> ="For the month of "&" "&TEXT(TODAY(),"mmm,")
>
> for any more clarification , u can mail me
>
> On 1/13/10, Mahesh w
17 matches
Mail list logo
