1. lockarde

    Sort range based on value

    Good morning all, I have an issue with a spreadsheet I use to track job details. Ideally, these details are supposed to be entered as they come in, but sometimes people wait, and suddenly there are details from several days or even weeks past. Is there a way to sort all of these details by...
  2. V

    Scheduling Sheet

    Anyone able to provide some quick help? I have a worksheet I am working with to schedule fabrication. I need two macros to format the sheet and a background process. Macro 1: Button Labeled "Fab Start"; sorts by Column I "Planned Start" oldest to newest creates...
  3. S

    Command action button

    i need a command action button to sort a table called table1 based on column ”No. Date” from Z to A. it’s important to note that my table increases everyday so the range must not be limited to a certain limit
  4. V

    Sorting Poducts VBA Running Slow

    Hello All, Thanks for the Education you are providing. I have been using the below code (originally created by Hiker95 in here) for the last 4 years now but now it is getting very slow to sort products, This is used to sort products entered randomly for each order with different products...
  5. 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...
  6. 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"...
  7. 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...
  8. 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...
  9. 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...
  10. 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()...
  11. 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...
  12. 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?
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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
  18. 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...
  19. 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?
  20. 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 /...

Some videos you may like

This Week's Hot Topics