$$Excel-Macros$$ Save pivot table as web page - formatted

2009-10-14 Thread LeonardoSP
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

$$Excel-Macros$$ VBA to Merge Rows

2009-10-14 Thread James
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

$$Excel-Macros$$ How to match numbers from 2 columns with minimal formulas

2009-10-14 Thread Mark Livingstone
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

$$Excel-Macros$$ Excel 2007 Run-time error '6': Overflow on Selection.Columns.Count

2009-10-14 Thread fitman
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 &

$$Excel-Macros$$ VBA code to paste a set of cells from excel to outlook email

2009-10-14 Thread Abhijat
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 --~-

$$Excel-Macros$$ Re: Please send me Urgent

2009-10-14 Thread Aindril De
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

Re: Fw: $$Excel-Macros$$ PUZZLE Use functions only!!!!SOLUTION!!!!

2009-10-14 Thread Prashant Bhawar
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

$$Excel-Macros$$ Re: xls.

2009-10-14 Thread Amitabh Bose
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

$$Excel-Macros$$ Please send me Urgent

2009-10-14 Thread amresh kumar
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

$$Excel-Macros$$ Re: Plz help in this problem (excel)

2009-10-14 Thread Abdul Rasheed
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

$$Excel-Macros$$ Re: unprotecting pdf files

2009-10-14 Thread Anil Saxena
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. >> >> >> > > > > --~

$$Excel-Macros$$ xls.

2009-10-14 Thread Anil Saxena
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

$$Excel-Macros$$ Re: unprotecting pdf files

2009-10-14 Thread Bhairav Chhaya
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. > > > > --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Name Matching In Excel

2009-10-14 Thread Umesh Dev
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 >