Just elaborate your query and if possible please attach the sheet.
Regards,
Anoop
On Fri, Nov 9, 2012 at 11:55 PM, Best Of Luck wrote:
> Hi,
>
> I was using the code below to import data into a Excel 2010 workbook with
> only one sheet. I now have multiple sheets and I wont this macro to only
Sheyn, Please elaborate your query.
Regards,
Anoop
On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee wrote:
> Dear MS Excel Group,
> Can we get percentile values from a pivot table.
> Best Regards,
> Sheyn
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
Before importing data use the following function
=clean(your expression)
On Fri, Nov 9, 2012 at 5:39 PM, Mangesh Vimay wrote:
> but how?
>
> Can you help me please.
>
> On 11/9/12, Anoop K Sharma wrote:
> > Use Clean function
> >
> >
> >
> > On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay
> > wr
Thanks a lot sir for shairing such a great thing...but can u please guide
us that how would i make this types of presentation...?
Regards,
@Suman
Send on the move with Galexy y.
On Nov 8, 2012 5:12 PM, "NOORAIN ANSARI" wrote:
> Dear Group,
>
> Please find attached template and double click on it
Congratulations Rajan
On Wed, Nov 7, 2012 at 6:17 PM, Karan Singh wrote:
> Congrats dude!!
>
>
>
> Karan Singh
>
>
>
>
> On Tue, Nov 6, 2012 at 5:51 PM, neeraj chauhan > wrote:
>
>> congratulation Rajan sir.
>>
>>
>>
>> On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori wrote:
>>
>>> Congrats Raj
Hi Paul,
Apologies for replying late, was stuck in between an important work.
Yes I googled the same, what I understood from Microsoft people and the
website, is that problem of organizational chart does exist in excel 2003 and
same has been rectified in excel 2007 or later versions.
Now, sinc
Dear Ashish,
Thanks for the below code.
But I need to get output as shown in the attached sheet & code should list
all narrow cells in that workbook.
Regards
Prashant
On Sun, Nov 11, 2012 at 12:40 PM, ashish koul wrote:
>
> Sub sample1()
> Dim wk As Worksheet
> Dim cl As Range
> Set wk = Act
Sub sample1()
Dim wk As Worksheet
Dim cl As Range
Set wk = ActiveSheet
For Each cl In wk.UsedRange.Columns
If IsNumeric(cl.Cells(2, 1).Value) And Left(cl.Cells(2, 1).Text, 1) =
"#" Then
MsgBox cl.Address(0, 0)
End If
Next
End Sub
On Sun, Nov 11, 2012 at 1:23 PM, Prashant Pawl
