I've come upon a problem with sorting that I don't know how to tackle... I have entries in a workbook that I want to sort by a transaction number, but each entry spans multiple rows. One "entry" might look like this, for example:
TransID PassengerName Ticket#
leg of travel: Departure Arrival
leg of travel: Departure Arrival
I need to be able to sort by TransID or PassengerName while keeping the "legs of travel" attached to the correct TransID/Ticket#.
I have over 300 rows with a username in the column A followed by 3 fields in the following columns B,C,D. I want to just sort all 300 rows alphabetically by column B,C,D.
1) Is it possible to hide all cols save D & E and also all blank rows in Col D
2) I would like to have an initial If statement saying stating that if the answer to the question in D2 is Y then don't display anything else other than the info in B2 & B3.
£) the sorting seems to have gone funny - not sure what I've done here, I'd like it sorted by phase (col A)
4) where there is a blank in the cell under a question (for example D3) - this means that the same question applies and that multiple docs should be returned (e.g for Q1 D2 docs 1 & 2 display, for qu D37 docs 36 - 39 display)
I'm running a macro to auto sort data and copy it to another page. One of the sort parameters is to only look at the data that has a blank in column 13. The code is as below:
I'm running Excel 2003 on Windows 2000. I'm working with a worksheet that is about 10,000 rows long and 25 columns wide. The first and second columns all have data in them, and the third through twenty fifth could have data. From row to row, if there is data present it will be in columns from left to right. By that I mean that if there is data in four columns of a particular row, it will always be in columns 1-4, not spread out throughout the 25 columns.
What I'm trying to do is sort the data in each row so that values ascend from left to right. Here's a very simple version of what the data looks like:
A B C D E F 1 a 6 3 2 b 5 9 2 8 3 c 6 5 2 4 d 9 5 e 3 9
When I'm done I would want the data to look like this:
A B C D E F 1 a 3 6 2 b 2 5 8 9 3 c 2 5 6 4 d 9 5 e 3 9
I've got a pivot table with about 40,000 rows. I want to be able to type a part number in cell A2, and hide all rows from row 7 down that do NOT contain that number in column A.
The idea is to show only the data for the number entered, but by typing the number rather than using the checkboxes to select it.
I need to lock consecutive rows together before sorting. e.g. A1 contains a name and A2 is blank: B1 contains data related to name in A1 - so does B2, and so on. Therefore need to lock rows 1 and 2 together, then 3 and 4 together and so on, but sorting on the data in the first cell of the group e.g. A1
I've attached the spreadsheet I want to use. As you can see there are three sets of "bootcamper name" and "time" columns
I wanted to know how I can sort by name or time if I were fill in data that started from A7 and B7 all the way down to A43 and B43 then restarts at C7 and D7 all the way down to let's sat C30 and D30
If I wanted to list all the data alphabetically ( or by time ) from A7 and B7 all the way down to C30 and D30, how can I do that?
I want to be able to download bank transactions in a csv file and have excel sort them according to rules I could define.
The csv file is organized as one transaction per row, with each row having several columns, one of which is a description that typically indicates the merchant.
I want excel to recognize a given merchant in the description cell, and then sort the associated row to be placed into a subcategory (linked to the given merchant) and then summed up.
For example, a transaction with the description "Joe's Diner" would be sorted to Restaurants subcat a transaction with the description "Dave's Supermarket" would be sorted to Groceries subcat a transaction with an unrecognized description would be sorted to Misc subcat
Currently I get a 1004 error. "Method of Range of Object _Global Failed" on "Range(Selection).Sort.SortFields.Clear"
Code: Sub sortBacklog() Dim appExcel As Excel.Application Dim myWorkbook As Excel.Workbook Dim myWorkSheet As Worksheet Set appExcel = CreateObject("Excel.Application") Set myWorkbook = appExcel.Workbooks.Open("C:Backlog.xls") Set myWorkSheet = myWorkbook.Sheets(1)
I have data being fed from an application where it's difficult to sort the rows into ascending order. So is there a way that VBA can sort them and produce a value according to the order?
For example, Column A contains 5 rows. Row 1's value is 4 Row 2's value is 1 Row 3's value is 2 Row 4's value is 3 Row 5's value is 5
If I were to sort these into ascending order, I'd get 1, 2, 3, 4, 5 in Column A. But I can't sort the rows so I need code to tell me which is the lowest number (1), which is the second lowest number (2), etc.
The purpose of the code will be to put values in Column B according to what's found in Column A. For the the lowest number, 1, the value in the cell next to it in Column B would be "a". For number 2, it would be "b", etc.
I have data input in a particular column, say Column C.
I would like to have a macro that deletes the rows where the corresponding entry in Column C are blank.
In addition, there are multiple worksheets with the same data format in the same spreadsheet, but the number of row varies. It would be great if the macro can delete the row with blank cell in that column across all worksheet.
I can view the data how I need to by conditional formatting and pivot tables but HR wants to get rid of all rows that: only have 1 accounting line per document such as Doc MI310712 in attached sample So I only want to display records if there is more than 1 accounting line for each document
My understanding of Excel is that in order to get rid of rows that a VBA macro is needed since there is no function to do it. My VBA is limited but is there a way to specify criteria in a filter to hide the rows using a formula?
I have a spreadsheet that I want to keep the blank rows that seperate the data for asthetic reasons. Can I sort just the rows with data in them and still keep the blank rows where they are?
I have a excel doc that have multiple tabs (different clients) with information (task, date due, who's responsible, and client), and I want to have a master tab that lists all tasks on any tab put in order by date. Essentially so everyone in the office can quickly see what their most pressing task's are.
I'm trying to sort by City first, then by Report #, but keeping the highlighted rows together. If I use the custom sort it will through my D2's at the bottom and not keep them with their city, report, and D1. How do I get them to stay together? I have attached my document example.
can anyone help me on how to create a formula or a macro that will automatically sort while preserving the relationships in rows without having to press any button? I have attached a sample workbook. Basically column ABCD under row 8 to 15 contains manual inputed values. While column ABCD beginning from row 24 to 26 should contains the automated sorted preserved relationship values.
I have a worksheet with columns of Unique Words and corresponding Frequency of Occurrence for several years. I would like to sort the data so the rows match up on same Unique Words across years.
I am trying to sort in rows, a large number of rows. I can do text to columns, delimit by colon, and sort individual rows. But I have spreadsheets that are 100s of rows long. Is there anyway to automate?
I have a long list of records/rows. Each record has about 22 cells (columns).
Recently the number of records/rows exceeded 1400 and I started noticing that Excel no longer can sort my records correctly. I sort them according to the first column, which is called PRIORITY. And these values go from 0-2500 and more. But very often my list looks as follows
2500 2437 2355 102 108 107 2102 169 1982 1970
And so on.
The funny thing is if I sort less than 1400 entries, it does it right. Actually, the cutoff line is somewhere between 1410 and 1425. Usually below 1410 it will work fine, above 1425 it will not, and between 1410 and 1425 it is erratic.
I have a pivot table and i am trying to display the rows in order of relevance. I have a bit of code that will sort the rows into the order I want them which I have included. My problem is that sometimes I will have rows that will not be there, If position 3 doesn't exist I would expect it to display 1,2,4,5 but instead I get an error message.
I have two rows of data that I need in one row and then sorted, it is possible that the data will be difffering lengths depending on input conditions. I also need the option to sort it either ascending or descending. The data in the two separate rows depend on other parts of the system and in turn this data will be used in another part. So I need it sorted automatically. I have tried ranking the data and then sorting it by rank but for some reason this does not appear to be working.
I am trying to write a procedure to highlight entire rows in VBA based on a entry in column A.
I have the below which works for say 1000 rows but breaksdown when I have 58,000 rows which is the usual amount of data I will have.
Below is the code I have so far. It appears when I debug it breaks on the red line with type mismatch.
Option Explicit Sub RemoveBH() Application.ScreenUpdating = False Dim intcount As Long For intcount = Cells(1, 1).CurrentRegion.Rows.Count To 1 Step -1
