Hi.
I have a pivot table that have source data from a relational database
system, and I formatted it with some background colors and font colors
different from the default format. I want to save the formatted pivot
table as a web page, with interactivity and with pivot table
functionality. The piv
I need help making a format that is exported from an application into
a more user friendly form.
Here is what I have
ID: 420300 3096
PICK: FRIO
WELL: 4239131 4258
PICK: GRETA
What I would like to have is something that looks like this:
ID: 420300 3096
Hi.
I've been trying to put together VBA code that will allow me to match
2 columns with minimal Excel formulas.
There are 2 columns. 1st column (B3 to B20) has a set of numbers. 2nd
column (C3 to C99) has another set of numbers. I need to highlight
cells in the 1st column IF the cell's content
The following code shown below is straight from the Excel 2007 msdn
web page on the Range.Count Property. When I select a range on Sheet1
and run the macro a Run-time error '6': Overflow error is generated on
the following line of code:
MsgBox "The selection contains " & Selection.Columns.Count &
Hi Group,
Can you provide me a code that copies a particular set of cells from
excel and pastes it into an outlook e-mail?
Tanks a lot.
Kind Regards,
Abhijat
Senior Associate
Equities Quantitative Research
UBS- ISC, Hyderabad
Tel: + 91 40 3051 5000
On Net: 19 533 6388
Mobile: + 91 9000899202
--~-
Hi Amresh,
Go through the link below. It has a lot of useful tips and usage of time
calculation in excel.
http://www.exceltip.com/exceltips.php?view=category&ID=111
Regards,
Andy
On Wed, Oct 14, 2009 at 6:48 PM, amresh kumar wrote:
> Hi My All Friends,
>
> i requested to you please send me exa
gr8
On Sun, Oct 11, 2009 at 7:39 PM, Sandeep wrote:
> Hello Everyone,
>
> Here is the solution of puzzle I asked on 3rd October. I used ITERATION for
> its solution.
> This may be new feature for many of members here so try to understand it.
> It is a powerfull feature.
>
> Thanks & Regards
> S
Hi Anil,
The drop downs in the spreadsheet have been made using 'Data Validation'.
In Excel 2007 this can be found under the ribbon 'Data' - click on Data
Validation' - choose "list" from the options under Allow.
The source section will contain your metadata, ie the data which you wi
Hi My All Friends,
i requested to you please send me example of time formula nin excel
Regards
Amresh
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tu
thanks a lot
On Wed, Oct 14, 2009 at 9:35 AM, vidyut more wrote:
>
>
> use mround formula for output plz find attachment
>>
>>
>> Input 120=mround,5) 121 122123 124 125 126127 128 129 130
>>
>>
>>
>> i want output in this way by using round formula
>>
>> output 120 120 120125 125 125 125125
Witch password
On Wed, Oct 14, 2009 at 3:12 PM, Bhairav Chhaya wrote:
> Hi,
> The file is asking for a password ?
>
> Regards
> Bhairav
>
> 2009/10/14 hari kumar
>
>> Hi All,
>> Can anyone unprotect the files.
>> --
>> Hari kumar
>> Our strength grows out of our weaknesses.
>>
>>
>>
>
> >
>
--~
Hi,
Please find attached file of .xls & give instruction how can i creat new
sheet like this.
Regards,
Anil Saxena
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. E
Hi,
The file is asking for a password ?
Regards
Bhairav
2009/10/14 hari kumar
> Hi All,
> Can anyone unprotect the files.
> --
> Hari kumar
> Our strength grows out of our weaknesses.
>
> >
>
--~--~-~--~~~---~--~~
Hi Dilip,
Can you explain the logic pls.
Regards
Umesh
On Tue, Oct 13, 2009 at 8:39 PM, Dilip Pandey wrote:
> Thanks Michael,
>
> The enhancement is done in the attached file as per your requirements.
> Thanks
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
>
14 matches
Mail list logo