Pivot can work for you...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?g
I am trying to duplicate the sort feature used in this tutorial:
http://www.contextures.com/xlSort02.html
The description of the first part of the code suggests that the code
creates the invisible rectangles, but I couldn't get it to do this. (I
had the create the rectangles manually, ahead of ti
Hello, I have the following data in sheet1.
State County
NY Kings
NY Kings
NY Queens
NY Kings
NY Bronx
NJ Essex
NJ Bergen
NJ Essex
In sheet 2, I need to bring in all unique county for the state. So
for NY, I need to bring in Kings, Queens, and Bronx. Fo
Hi Aindril
Much appreciated for that. I as just wondering if there was a way to
tell Excel to open the file this way without having to do that. Like
it does for csv files.
Mat
--
--
Some important links for excel us
Dear Sudhir,
Write =SpellNumber(cell) and press Enter
I am sure u will get result
On Mon, Aug 9, 2010 at 11:37 AM, NOORAIN ANSARI wrote:
> Dear Experts,
>
> I need to convert Numeric Value in charaters..Is it possible through excel
> or Macro.
>
> Example...
>
> 25302- *Twenty Five thousand thr
Dear Umesh,
I will suggest u to line Access and Excel,Data>Import>New Query>Access or
Home >Access etc I hope this will help you
Regards
Ramkesh
9990260398
On Sat, Aug 7, 2010 at 8:46 PM, Umesh Matkar wrote:
> **Dear All,
>
> I need your help
>
> I have some Mobile nos in 'a' colmn ..and that
Dear Friends,
Need your help..could you please help me..
-Umesh
On Sat, Aug 7, 2010 at 8:46 PM, Umesh Matkar wrote:
> **Dear All,
>
> I need your help
>
> I have some Mobile nos in 'a' colmn ..and that mobile no related other
> information is availble in MS-Access table (data volume is 6lac)
>
My friend Prathap,
Yes, there is. I did it in the Sample I am returning to you, but I would
strongly recommend other simpler ways to do it.
The point is that up to Excel-07, microsoft has not implemented any default
functions that deals with cells background colors (if I am wrong, somebody
tells
Hey Rolf,
You can use the following Code.
Public Sub SaveWorksheetsAsCsv()
Dim WS As Excel.Worksheet
Dim SaveToDirectory As String
Dim CurrentWorkbook As String
Dim CurrentFormat As Long
CurrentWorkbook = ThisWorkbook.FullName
CurrentFormat = ThisWorkbook.FileFormat
' Store current details f
Hi Mat,
Open the file in Excel. You will find all the information in Column A.
Select Column A and then Use Text To Columns Feature in Excel.
Choose the Delimited option. And the the Next Screen you will have a place
to type a customized delimiter.
Type the Pipe symbol in that and click finish if
You're welcome.
Dave.
Date: Mon, 9 Aug 2010 05:31:11 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Need to remove Alt + Enter
To: excel-macros@googlegroups.com
Thanks so much. I used the clean function and it worked perfectly. This was a
great help!
From: Da
Thanks so much. I used the clean function and it worked perfectly. This was a
great help!
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Sat, August 7, 2010 10:14:21 PM
Subject: RE: $$Excel-Macros$$ Need to remove Alt + Enter
Hi Nadine,
Hi Imad,
Can you add the formula into the macro so that the calculation occurs
in the order you desire ?
I think that should address the issue.
Hope it helps.
Alpesh
On Aug 8, 1:37 am, IMAD KAYED wrote:
> ACTUALLY NO BODY REPLY ABOUT MY PROBLEM I THINK YOU DIDN'T RECIEVE THE POST
> SO THAT I A
1. Start Microsoft Excel.
2. Press ALT+F11 to start the Visual Basic Editor.
3. On the *Insert* menu, click *Module*.
4. Type the following code into the module sheet.
Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
Dim Dollars, Cents, Temp
Di
14 matches
Mail list logo