sort & filter

Hi All Ive been a regular follower on this forum, but never posted, so please be gentle. Ill do my best to follow post etiquette. I am trying to create a method to assist my family in selecting a ski holiday resort, as we each have differing priorities and - because of the width of options...

I'm working on a template that allows me to repeatedly copy the initial worksheet (e.g. sheet 1) and have multiple worksheets in a single file. I do repetitive data entry/manipulation and a system like this is key. I have a variety of macros I use for this workbook, some assigned to buttons and...

Hello, I have been working on a project over the past 2 weeks and it just came to completion. Now that the pressure is off, I cant help but think there was a better way to manage manage this step of data I had to mine. I needed to see what attendee had watched both the Live & VOD offerings of a...

Hello everyone, I may be asking too much. I have a vertical table of data that needs to be redistributed horizontally to prep for a data set that Photoshop can read. Transpose isn't working the way I expected it would. My data shows the attendees of who participated in certain events and as...

The fact that Excel is unable to identify and correctly sort hierarchical numbering (ex. 1.1, 1.2, 1.2.1, 1.2.2, 1.3...) is an age-old problem which has been widely discussed in many fora. There are numerous workarounds, but they are often project-specific or formula-based. At the moment, I have...

I searched the previous questions but found no answer. I have a table and in that table I have some columns that I would like to lock. My users enter data from a user-form. When the form is open the sheet is unprotected, when the user exits the form I want to lock certain columns so the user...

Good morning, all! I have been stuck on this issue for days and hope someone can help. I have a table on Sheet2 [Sheet2.Range("A2:O" & LastRow)] that gets copied to a table on Sheet1 [Sheet1.Range("Table1")] through a macro. The table on Sheet 1 starts on D17 and goes to the last row in...

Good Morning, I am completely confused on how I can parse the file sort it by dates but retain only the last 6 months then remove duplicate computer names. Need a solution to open a txt file that is comma delimited with four fields. I need all duplicate Workstation removed but retain the...

Tossing this out to the Excel geniuses of the community. I need help creating a spreadsheet where I can associate an author’s statement to multiple keywords. I’ll have hundreds of individual statements with multiple keyword associations for each statement. I need to be able to search for those...

Hi! Thank you for reading this one. For an example of what I am trying to do, lets say I have a sheet that is about 200 rows long by 15 columns wide. It is one sheet with multiple bills-of-materials stacked one on top of the other. Column A has the master/parent numbers and Column B has all of...

I wanted to sort my column based on time. I have cell which automatically generate date and time base on other cell value. I have a vba code which i have paste in the sheet it works great for me but problem is it works when i click or select any cell in that particular column. I wanted to it do...

I posted prior. However, I could not get the solution I was looking for. I have a spreadsheet w/ approximately 40K lines of data. The data is formatted into 3 columns – employee name; week ending; avg. hours worked. Is there a way for me to filter this data in such a way that it omits...

Good Morning Fellow Excel Experts, Per usual - a thanks to everyone who contributes to this forum! What would the macro be to sort on column A / row 1 (Last Name, First Name), data through [column B:column Q] then find that same name in multiple worksheets (tabs) and then place that same name...

Hi I am looking for a way to have a button to be able to click once I have all of my data entered to sort all values from largest to smallest. I know it has to do with macros and assigning it to a button but could someone assist?

Hi everyone, I have a huge file about transaction that has 5 columns (Date, Product Name, Quantity, Price, Total Price), example like below: Date Product Name Quantity Price Total 2019-01-01 A 2 $100...

Need help on this issue I have with excel: Sheet 1: master copy with columns of data, A, B, C Sheet 2: summary of minimum value linked from sheet 1, but of only selected cells with no fixed order; eg MIN('sheet1' B2, 'sheet 1' B4, 'sheet 1' B5) However, when I Sort my sheet 1 data, say column...

Hi, I have a workbook with a number of different rss feeds imported into different tabs/sheets. All the feeds are different table lengths, but they all have the name of a header in common. I wonder if there is any easy way therefore of doing it all at once? At the moment, my code just goes...

Hello All, I am trying to sort some source data that comes in a formatas follows: <tbody> John 1 1 3 3 3 3 Mark 1 1 2 2 Amy...

Hey guys I am trying to convert the code below to a function, I am trying to sort the data below the code by the first set of numbers it comes to. I think this would be the formula I would want to enter, or close to it "=vsortm(a1, a:a)" This code works fine the way it is, but I need to use it...

Hi Team, I have problem in sorting pivot values and it will never get sort. I have copy and paste special then I perform the sort. Is there any option do I need to enable to sort Pivot data? I am using 2016 MS Excel. Please suggest me. Thank you