filtering data

I have a large workbook and the data within in needs to be filtered, I have datestamps in column A, these then need to be checked over all of coulmn A to see if there are any duplicates, if there are that duplicate then needs to be check against a value in column D, coulmn D contains a value...

Hi, I have two sets of data, one is a column with a certain set of numbers, lets say 11111 33333 55555 Then, i have a second set of data, that is partially made up of this first set of numbers. Each number is matched up with another column. it looks like this: 11111 abc 22222 def 33333 ghi...

I have a report that I generate weekly. Our users (about 15 or 16) go into the report and add accounting details. Over the last few months, data has been damaged by users dragging their data down and sometimes over the data entered by other users. I would like to create an AutoOpen macro that...

Hi All, i am trying to find a a function that can filter a column of supplier codes (the column will have the supplier code in it between 1-??? times) then return it on a new sheet just once along with the supplier description (adjacent cell) eg: the source sheet <tbody> <tbody> 20935...

Hello everyone, I am new to this forum and have a few questions. For a school assignment I have to make an automated report in word using VBA and excel but I have a problem filtering the data. The file exists of 3 sheets: - control (date selection and button to generate word report) - data...

Hello all, I have the code below which captures information inputted onto a user form and pastes it into a spreadsheet which is locked. I have a need to be able to still keep the spreadsheet locked but to allow the use of the autofilter function. I have searched Google but so far have been...

Hello all, I have two spreadsheets, one containing user IDs ("Report1") and one containing every information we have about the user with that ID "MASTER_Detail_18.07.2018". I have created a VBA macro that takes a specific ID ( hardcoded) and uses it as a filter in the...

In the table below the first column is my data, the second and third are what I want. Any ideas how to do this would be really appreciated.:biggrin: Basically I want to find consecutive blocks of 4 or more numbers within the #N/As and copy these. I then want to use TRIMMEAN on each block to trim...

I am using VB to delete rows meeting certain criteria - however, if the criteria is NOT met, I'm receiving a Run-time 1004 - No cells were found. The code below will result in a match on Criteria 1, but there is no match on Criteria 2 (often, that is...). In the event that this occurs, I would...

Hello ~ I need some help with the following! I need to use a Radio Button in sheet1 to filter a list in excel in sheet2 and then output the results in sheet1. The options for the radio button will filter on sheet2 column B. So a user will select one of the three options (which is "Type")...

Good morning. I’m creating a document name for users: Standort-Gebäude-Geschoss-Planart-SPA1-SPA2-Variant.DGN Each parameter of the document name is in extra cell of the "Dokument Name" sheet. Paramters „Planart“, „SPA1“ and „SPA2“ are chosen in a table of the "Planart, SPA1 and SPA2" sheet...

Hi - I'm not very experienced with excel and this is my first post but I have the need for the following. I have two columns I am trying to get information from. The first column contains an error type like LFR, RTR etc and the other column contains an order number. I have about twenty...

I have been looking around online and have not been able to find what I need. As you can see below I have a list set up of different capitalization rate percentage ranges. (Note: the "xx" max/min should be actual rates - I set up this table before I had any of the rates) I would like to set up...

Hello, I am sure this sort of question has likely been asked before, but i cannot seem to find the exact response I need... I have a spreadsheet with two main columns:- * Column #1 contains a string, with varying string content: /xxx/yyy/here_is_the_text...

Hi. I've been reading a lot of this forum recently and have found some brilliant advice. I hve hot a stumbling block in a project I'm working on. I'm completely self taugh when it comes to VBA so please fogive my ignorance. I am working with Excel 2007 and have been trying to use a list of...

Hi, Sometimes when I am at work, I will work in a shared file that then becomes locked for one reason or another. If I were to have that file already filtered by multiple criteria, is there a way then to re-open that same shared file (identical data), and then easily apply all the same filters...

I'm creating a log of all the old reports submitted by the company so others can go through and review them based on what the projects entailed, based on several categories. I want to filter by the technology used, which is fine, except some projects used multiple technologies. I want that...

Hello, I am trying to filter a column of text, and unsure how to or if this is possible. Each Cell contains 1 sentence, with roughly ~3000 cells in the column. I have a list of words I want to use as keywords for filtering the column of text. I would ideally like to use a text file, so I can...

Hi. I have a table of data something like: Taxon Species Index No. individuals taxon1 species1 35.63 15 taxon2 species2 28.22 7 taxon3 species3 25.94 species4 28.52 6 species5 21.35 species6 26.64 18 taxon4 species7 22.94...

Hi I am currently trying to produce a spreadsheet for an entry system to sort out swimmers in a gala by events they have entered. Currently I have the main entry sheet which I receive back from each swimming club, with the details entered, Columns F to J are y / n answer if Y is selected the...