This will help you!
Enjoy it!
You didn't supply info about session
Sub Unpivot()
Dim row As Long
Dim col As Long
'Where to put the unpivoted array
' Should be in another sheet but you've put it on the same ..?!.
Dim row_dest As Long
row_dest = 10
'To simplify the algo
Dim PROGRAM, ROLLNO, C
Dear Mr.Chandra Gupta
Please explain the formula as i want to use the same fomula in other file.
Regards,
Rajeev
On Thu, Nov 12, 2009 at 4:12 PM, Chandra Gupta wrote:
> Dear Raghavendra br please attached solution for your problem. I have named
> the ranges on the ex rate datasheet.
>
> Chandra
Thanks,
turns out I am using an OLAP pivot table, and as such it does not
work. Any idea how to get around this for OLAP table?
Thanks,
Luc.
On Nov 7, 10:44 am, Dilip Pandey wrote:
> Hi Luc,
>
> Two options:-
> 1) Choose complete columns in the data range for Pivot table e.g. (A1:H88
> should be
Hi
i am looking good equity portfolio tracker in excel, with trade and history
for stocks, position/intraday/futures etc
thanking u in adv for sharing
rakesh.
--
--
Some important links for excel users:
1. Excel an
Hi Paul
Thank you for the suggestion. Whenever I have to format a sheet which
requires complex formatting, I will always keep a hidden sheet which is
already formatted.
I will copy the default formatting (and also formulae) from the hidden sheet
and paste it on the target sheet using "ActiveSheet
Hi
You can keep a count of number of prints taken using VB but I don't think
you can actually restrict it because the user can print it
1) on another machine
2) Or by just changing the name of the workbook
3) Or by restoring the original copy of the workbook after the number of
prints allowed are
hmm..
Thanks. I am some familiar with vba, but this is maybe not what I am
looking for?
- The Pivots In Excel were manually created, and the data from Access
is exported ("DoCmd.TransferSpreadsheet acExport") directly into
same ws in Excel, replacing old data).
But, i will have look again,
ar
Hi Nayan,
Please find the enclosed sample tracker. You can customize as per your need.
Regards,
Deepak Rai
On Thu, Nov 12, 2009 at 7:56 PM, Nayan K Lodaya wrote:
> Hello Anyone ,
>
> Please can you send / share leave tracker file you have for your
> organisation…as I am looking for my team
Hi,
U can use =C3 & " " & TEXT(D3,"mmm-yy").
Regards,
Deepak Rai
On Thu, Nov 12, 2009 at 7:36 PM, Nayan K Lodaya wrote:
> =CONCATENATE(C3," ",TEXT(D3,"mmm-yy"))
>
> Hope this helps
>
>
>
> *From:* Prashanth Banneni [mailto:praba...@gmail.com]
> *Sent:* 12 November 2009 18:37
>
> *To:* excel-
hi arnsto ,
Well well well! Hope you're familiar with vba ...
I've got this issue and I've solved it this way enjoy it :
Public Function Report0() As Integer
Report0 = 1
On Error GoTo errorhandler
Dim db As String
Dim sql As String
Dim pt as PivotTable
db = "The database full p
Sorry for the misunderstanding Ashish. Following is teh correct formula:
=IF(EXACT(F7,VLOOKUP(F7,$A$5:$B$7,2,1))=TRUE,VLOOKUP(F7,$A$5:$B$7,2,1)," NO
EXACT MATCH")
Regards,
Andy
On Thu, Nov 12, 2009 at 3:48 PM, ashish koul wrote:
> i want to find the value of adjacent row using vlookup my answ
Hello Anyone ,
Please can you send / share leave tracker file you have for your
organisation...as I am looking for my team which consits of around 250
employees.
Regards,
Nayan K Lodaya | IBOD Inter Entity Swaps | J.P. Morgan | 9th Floor , A-wing,
Prism Towers, Malad(W), Mumbai | T: GDP : 308
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 Tutorials(Video and Text), Free add-ins downloads at
=CONCATENATE(C3," ",TEXT(D3,"mmm-yy"))
Hope this helps
From: Prashanth Banneni [mailto:praba...@gmail.com]
Sent: 12 November 2009 18:37
To: excel-macros@googlegroups.com; dilipan...@gmail.com
Subject: $$Excel-Macros$$ text and date in one cell
Hi All,
Can you help me how to get the desired outpu
Pls check the attachment for solution.
Rgds- Putta
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
>
> --
>
> ---
Try using:
=C3&" "&TEXT(D3,"mmm-yy")
Paul
From: Prashanth Banneni
To: excel-macros@googlegroups.com; dilipan...@gmail.com
Sent: Thu, November 12, 2009 8:06:57 AM
Subject: $$Excel-Macros$$ text and date in one cell
Hi All,
Can you help me how to get the desir
Having a h u g e workbook with about 20 ws, and about 50 pivots.
( Several Pivots on same worksheet.)
The datasource is placed in one sheet only, and reg. updated (exported
from Acces 2003.) replacing al the data.
Problem:
- The file steals memory, and is slow to work with..
- It seems that a lot
Hi All,
Can you help me how to get the desired output from the attached sheet.
Many thanks in advance
Best
Prashanth
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-
Dear Ashish perhaps you need this.
Chandra Gupta
On Thu, Nov 12, 2009 at 2:18 PM, ashish koul wrote:
> i want to find the value of adjacent row using vlookup my answer should
> come3 in this case but its not showing that
>
>
> On Thu, Nov 12, 2009 at 12:42 PM, Aindril De wrote:
>
>> Hi A
Sorry, it looks like I was answering another post, when your message hit my
in-box.
I selected the top email and replied... it was not intende for this problem!!!
(sorry)
Paul
From: AltBerg
To: MS EXCEL AND VBA MACROS
Sent: Wed, November 11, 2009 2:03:40 PM
Hi Excel Gurus,
Kindly need your assistance on the query -mentioned in the attachment.
Thanking you in advance.
Regards
Rags!!!
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text)
i want to find the value of adjacent row using vlookup my answer should
come3 in this case but its not showing that
On Thu, Nov 12, 2009 at 12:42 PM, Aindril De wrote:
> Hi Ashish
>
> =IF(EXACT(F7,VLOOKUP(F7,A5:B7,1,1))=TRUE,VLOOKUP(F7,A5:B7,1,1)," NO EXACT
> MATCH")
>
> Is the corrected f
Dear Friends ,
I have workbook having multiple sheet. Each Page is connected with Hyperlink
. Problem is that as soon as the file is closed , Hyperlinks disappear. It
is continuing for several time that I have edited the hyperlink and it is
disappearing .
Kindly help how to solve this prob
23 matches
Mail list logo
