Excel Discussion (Misc queries) | Forum profile

Oops.my mistake...try this version Sub SplitSheet() Dim ws1 As Worksheet, ws2 As Worksheet, lngCol As Long, lngLastCol As Long Set ws1 = ActiveSheet lngLastCol = ws1.Cells.Find(What:="*", _ SearchDirection:=xlPrevious, SearchOrder:=xlByColumns).Column For lngCol = lngLastCol To 2 Step -1 Set ws2 = Worksheets.Add(After:=ws1) ws1.Columns(1).Copy ws2.Columns(1) ws1.Columns(lngCol).Copy ws2.Columns(2) Next End Sub If this post...

See reply to your first post. Gord Dibben MS Excel MVP On Tue, 24 Nov 2009 10:19:05 -0800,

Are you sure that you converted the contents of the cell to text? How did you do it? Or did you merely change the format of the DISPLAY to text (which has no effect on the cell contents)? What does =ISTEXT(A2) say (& for other rows)? If they really are all text but they don't sort correctly, perhaps you have stray spaces or other non-printing characters? Does =LEN(A2) [and correspondingly for other rows] show the length you...

This suggestion has lots of assumptions--if your data varies from those assumptions, you'll want to share a more detailed description of the data layout. I'm assuming that column A contains those labels. Column B contains the data to use. There are always 6 labels per entry--and they're always in the same order. If all that's true, then put this in C1: =INDEX($B:$B,(6*(ROW()-1))+(COLUMN()-2)) And drag across to column H...

Hide them lizfox wrote: > I'm a new user on 2003 excel. How do i change the amount of cells. I need > ten down only

Try using the SUMIF function. ...........A..........B 1.....Bev.........5 2.....Pro..........3 3.....Bev.........2 4.....Sp...........3 5.....Bev.........2 =SUMIF(A1:A5,"Bev",B1:B5) -- Biff Microsoft Excel MVP "Amanda Fekety" > wrote in message ... > Hi, not sure how to present my question briefly.... > > I've created an inventory sheet for our restaurants with the following...

Gary, Changes to Excel's macro security level do not take place immediately. After you make a change, you have to close Excel and then reopen it for the change you made to take effect. "Gary" wrote: > I guess my next question is how do i re-enable macros so this one will run? > > "JLatham" wrote: > > > The reason the cells still contained information was, as...

As the result is based on average marks..the below formula will work for the example/scenario mentioned... =IF(E2="Pass",RANK(F2,F$2:F$6,0),"N/A") If this post helps click Yes --------------- Jacob Skaria "Narendra Boga" wrote: > Hi All, > > I have a trouble with Rank() function. I have written normal rank function > based on "Average" column...

If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software

Goto Insert - Name - Define. Select your range of cells with your list, and give it a name (MyRange). Click Add, Ok out. On your other worksheet, goto Data - Validation - List Input the following: =MyRange Ok out. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "da" wrote: > Hi > How can I create a drop down list which is on a separate worksheet but in > the...