| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP!! ARRANGE MULTIPLE ROWS IN A SINGLE ROW
Hi all,
A1:data bill description amt A2:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A3: I WANT TO CHANGE A4:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A5: I WANT TO CHANGE A6:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A7: I WANT TO CHANGE A8: THIS IS THIRD ROW This is the list i get from a txt file the problem is that i cannot sort this with date/bill/amount/description what i want is to get the description in one row so that i can sort all items. YOurs, sajay |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP!! ARRANGE MULTIPLE ROWS IN A SINGLE ROW
Here is one I use to make a spilt line formula into one. I select the top
row of the 2-3 rows and execute. As written it must have a blank above and below. I have assigned to a custom button on my toolbar Sub FixLongFormulas() 'goto a remote area of ws & select 1st line x = ActiveCell.Row y = ActiveCell.Column z = ActiveCell.End(xlDown).Row For Each C In Range(Cells(x, y), Cells(z, y)) mstr = mstr & C Next Cells(x - 1, y) = mstr End Sub -- Don Guillett SalesAid Software "sajay" wrote in message ups.com... Hi all, A1:data bill description amt A2:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A3: I WANT TO CHANGE A4:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A5: I WANT TO CHANGE A6:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A7: I WANT TO CHANGE A8: THIS IS THIRD ROW This is the list i get from a txt file the problem is that i cannot sort this with date/bill/amount/description what i want is to get the description in one row so that i can sort all items. YOurs, sajay |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP!! ARRANGE MULTIPLE ROWS IN A SINGLE ROW
thanks don
I will try this and revert to you. was busy with accounts so late to check groups YOurs sajay On Nov 25, 8:12 pm, "Don Guillett" wrote: Here is one I use to make a spilt line formula into one. I select the top row of the 2-3 rows and execute. As written it must have a blank above and below. I have assigned to a custom button on my toolbar Sub FixLongFormulas() 'goto a remote area of ws & select 1st line x = ActiveCell.Row y = ActiveCell.Column z = ActiveCell.End(xlDown).Row For Each C In Range(Cells(x, y), Cells(z, y)) mstr = mstr & C Next Cells(x - 1, y) = mstr End Sub -- Don Guillett SalesAid Software "sajay" wrote in oglegroups.com... Hi all, A1:data bill description amt A2:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A3: I WANT TO CHANGE A4:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A5: I WANT TO CHANGE A6:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A7: I WANT TO CHANGE A8: THIS IS THIRD ROW This is the list i get from a txt file the problem is that i cannot sort this with date/bill/amount/description what i want is to get the description in one row so that i can sort all items. YOurs, sajay- Hide quoted text -- Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP!! ARRANGE MULTIPLE ROWS IN A SINGLE ROW
don
things are getting complex, i fear I don't understand what this code do. I think i should send you one file and the output file. Actually there are 5 fields viz DATE:BILL:DESCRIPTION:AMOUNT:AMOUNT for occurance of date I want the narration field togater (ie in one row) YOurs sajay Don Guillett wrote: try this to fill in the blanks and then sort by that. If date is col A then chnage this to add a column B chg to C and ,1 change to ,2 Sub fillinblanks() For i = 2 To Cells(Rows.Count, "B").End(xlUp).Row If Cells(i, 1) = "" Then Cells(i, 1) = Cells(i - 1, 1) Next i End Sub -- Don Guillett SalesAid Software "sajay" wrote in message s.com... thanks don I will try this and revert to you. was busy with accounts so late to check groups YOurs sajay On Nov 25, 8:12 pm, "Don Guillett" wrote: Here is one I use to make a spilt line formula into one. I select the top row of the 2-3 rows and execute. As written it must have a blank above and below. I have assigned to a custom button on my toolbar Sub FixLongFormulas() 'goto a remote area of ws & select 1st line x = ActiveCell.Row y = ActiveCell.Column z = ActiveCell.End(xlDown).Row For Each C In Range(Cells(x, y), Cells(z, y)) mstr = mstr & C Next Cells(x - 1, y) = mstr End Sub -- Don Guillett SalesAid Software "sajay" wrote in oglegroups.com... Hi all, A1:data bill description amt A2:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A3: I WANT TO CHANGE A4:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A5: I WANT TO CHANGE A6:19-04-2006 IS/100 THIS IS THE NARRATION FIELD WHICH 100.00 A7: I WANT TO CHANGE A8: THIS IS THIRD ROW This is the list i get from a txt file the problem is that i cannot sort this with date/bill/amount/description what i want is to get the description in one row so that i can sort all items. YOurs, sajay- Hide quoted text -- Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Multiple rows | Setting up and Configuration of Excel | |||
| Consolidate multiple spreadsheets into a single workbook | Excel Discussion (Misc queries) | |||
| combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
| Multiple rows converted to one row | Excel Worksheet Functions | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
Hybrid Mode
