sorting

  1. A

    Sorting Dates with General format and time stamp

    Hello All - I have been sent a worksheet with dates from a user in Australia. The date format is: 17/06/2016, so Day, Month, Year. And to be more specific, what I've been sent is: 17/06/2016 18:53, so D, M, Year and a time stamp. There are other dates that I need to merge and sort with these...
  2. L

    reversing the order of 2 columns

    Hi Is there any way/trick to reverse a table without using sorting? Here is my table From <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> average grade 0 f 50 c 60 b 80 a </tbody> To <colgroup><col width="64" span="2"...
  3. A

    First time creating macros for complicated sorting

    Hey, all! Just a bit of background: I work in sales at a hotel. I've been tasked with manually entering our numbers into a new system until it interfaces with the program the front desk uses to keep track of rooms. It's daunting. I'm given an extremely dense Excel file with information about...
  4. G

    Maintain cell value of referenced cell after sorting

    I have a list of values in range B6:B52; each value represents a report. In column D, I have the name of the reports going down the column referencing column B such that: D6 = B6 D57 = B7 D108 = B8 D159 = B9 .. and so on As I add values to column B, the value automatically gets referred to the...
  5. N

    I am Hoping to Find a Sort Macro

    Hello...I am a schoolteacher who wants to provide students with a chance to retake failed tests, and I want the data organized by class periods. I am requesting a macro to perform the following sort functions: Sort 1 is ascending from A2 to AT205 sorting by Column AT(Test Score) Sort 2 is...
  6. K

    Sorting Tables (ListObjects) with VBA

    Hi All. I have a sheet with a number of Tables in it that I would like to sort on a regular basis. Currently I have the following code which works, but I'm curious to know if there is a easier way with looping to sort all the tables in the sheet at once. Any suggestions? Sub Sort_Lists()...
  7. B

    Sorting Across the Down with Photos

    I'm creating a database of sorts with Excel. They want a photo page with links to a details page for each item. I'm trying to make a sheet that is 10 columns wide and then raps to the next row. The links are tied to the images so they need to be sortable in the case that a new item is added. I...
  8. D

    Sorting columns in Tables

    When creating a table, Excel turns every column in the table into a sortable column via a drop down arrow next to the column name. Is it possible to turn off this sorting ability for some of the columns in a table?
  9. T

    Index Match Match Match

    Hello!!! I am having difficultly getting a formula to work. =INDEX(OLPPricingTable,MATCH(PricingType,OLPPricingTablePricingTypes,0),MATCH(D200,OLPPricingTableChannels,0),MATCH(OLPNPRTotal,OLPPricingTableNPRLookup,1)) I need to match a column exactly, a row exactly and a column greater...
  10. kweaver

    Error opening file after sorting, saving, and closing

    I have an Excel workbook with a tab named "Master". I have a sorting button that calls this routine: Sub SortByEmpNo() Sheets("Master").Activate With ActiveSheet.Sort .SortFields.Add Key:=Range("A10"), Order:=xlAscending .SetRange Range("A10:G1013") .Header = xlYes .Apply End With End...
  11. S

    Allow sorting in a protected sheet

    Hi all, I need to allow sorting in an unlocked table within a protected sheet. I have enabled filtering, but for some reason sorting is an issue. Every time I try and sort I'm prompted with "The cell or chart you're trying to change is on a protected sheet. To make a change, protect the sheet...
  12. Z

    months from 1 to 12 in columns (in numeric format) not sorting correctly in a pivot

    Hi, I would like to show months 1 2 3 4 5....12 from column K to V in a pivot table, but the pivot is not sorting them from from 1 to 12 but keeps showing as 2 3 4 5 6 7 1 8 9 10 11 12. I can't get the 1 to go before 2 so in correct order. I've tried to drag the column to front of 2 but it...
  13. L

    Autonumber Column

    Hello, I have a Customer table that I would like the first column to autonumber to the next higher number. When sorting the table can that number remain with the Customer? What I have tried so far doesn't keep that ID with the Customer when sorting the table columns. Thank you
  14. N

    Some Doubts about Sorting

    Hello I want to clear some doubts about sorting the following code sorted perfectly Just 1. When rows of records are entered after sorting. Then want to sort it with new records it does not sort. I dont understand Why ? 2. So when do i need to sort. Any particular criteria required for...
  15. B

    pivot table sorting

    I have data by month January-June and each week is labeled week 1 through week 26. I want the weeks on the row side and months on columns, but every time I sort it the pivot table does week 1, week 10, week 11, week 2, week 21, week 3, etc... how do I have it go week 1, week 2, week 3, etc?
  16. L

    Merging rows quickly

    Hello guys, im setting up a tool and one of the steps is to merge some data together. It's a large document and my initial idea was to cycle back from last row, and check 2 cells, if they match between the 2 rows, a 3rd cell merges both row values and deletes the old one. <tbody> row nr /...
  17. F

    Sorting information in a number of sheets by the same Column Header

    Hi, I have previously been inserting RSS feeds (as an HTML table) into an excel document and running the below code to update the details and sort by the date column in all tables, when the document opened. When finished the document then saved and closed. All was working great until I...
  18. W

    Removed Records: Sorting from /xl/tables/table2.xml part (Table)

    Every third or fourth time I open this workbook I get the error "Removed Records: Sorting from /xl/tables/table2.xml part (Table)" I have no Idea what to do. Any Ideas?
  19. M

    Sorting data changes all columns

    I did a transfer using VBA. I am having trouble now filtering the data and sorting it. I used the following in VBA: Sub Copy() Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("A5") Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("D5") Sheets("Data...
  20. R

    How to find the most SEQUENTIAL occurring numbers in 1 column

    I am doing lottery odds on excel for fun. So I am doing a 5 column lottery. I am trying to figure out in Column I (Labeled 4th Ball) How to highlight the numbers that show up in a row the most frequently and to highlight them a certain color. For example, rows 20-22 all have the number 15 so...

Some videos you may like

This Week's Hot Topics

Top