data sort

Hello O great and smart people actually I posted a similar thread before some days, and Mr. @alansidman graciously did a great help and his code is working very well, 100% and this is the post link for the solved problem: https://www.mrexcel.com/board/threads/auto-fill-values.1133259/page-2...

i need two buttons to sort my data because some days i need my data sorted in way 1 and sometimes in way 2 so i need 2 different buttons for it way 1: its a custom sort on column M and the custom list is ( 24 H, 48 H, 3 days, 4 days, 5 days, 1 week, 2 weeks, 1 Month, 2 Months, Monthly, Yearly)...

I have looked and do not find a solution to acquire one column's data, insert it into a new sheet. Then acquire another column's data from a different sheet and enter that into the same column that the first column's data was inserted. This way the data from two columns, each from a different...

I have a spreadsheet with four sheets: 'Full Project', '1', '2', '3'. On each is a Gantt Chart with activity table, the full project sheet has the data for the full project, sheets 1-3 contain the same data for only selected periods of time (each third of the project timescale effectively). The...

Hello! I am trying to figure out a way to sort raw data into a desired format. This is the format of the raw data: <tbody> Raw Data Name Parameter Value A100 Temp 5 A100 Press 10 A100 Flow 15 B200 Temp 20 B200 Press 25 B200 Flow 30 C300 Temp 35 C300 Press 40 C300 Flow 45...

I have a tab that is pulling data from another part of the spreadsheet and leaves a "" for a blank cell. I need to sort some columns alphabetically & numerically but the "" is obviously showing as a string. Is there a way to only sort the non "" cells? Thanks for your help

Hi all, wonder if someone may be able to assist? I'm trying to sort a selection of data into groups (2 cols, 1st is P-No, 2nd is Qty) based on the first four digits of the P-No and then tally the groups Qty (so I have the total Qty for any given product group) but short of sorting the data by...

Hi I was after some assitance performing a data sort on a range that is dynamic as opposed to fixed. However the range A21:AA755 will grow over time. Does anyone have any idea? Currently i have the following code Sub Sort() ' Sort Macro Application.ScreenUpdating = False...

Hi all i have created the below Soccer table and all the data now fills in automatically from other places in the workbook as results are inputted. <TABLE style="WIDTH: 322pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=429><COLGROUP><COL style="WIDTH: 95pt...

I have a large amount of data, 97000 rows and 4 columns that I need to sort every 26 rows starting with row 26. I only need 2 columns but I'll take all four if someone knows an easy way to accomplish this task. The data is position and time and the time is in seconds from which I need the...

Good evening, I have moderate VB experience but am completely new to Excel programming. I am developing a program which I expect to be fairly simple, however, I've not a clue where to start organizing my raw data. I figure my macro to be a fairly simple one, but am stuck. My raw data will...