help - macros

I have data in columns AB&C To find duplicate rows I concatenated the 3 cells in each row in 1 cell so now column D is occupied and duplicates of column D's cells denotes the duplicate rows. I want to keep 1 copy and clear the other duplicates (not delete rows but clear rows) I have been...

Hey guys, I've been working with macros for about a week or two, and while google is my friend, I think I need to reach out for some help. When I step through the code I've posted below, it works perfectly. No errors, everything formats correctly, and I end up with the desired result for the...

Hi there! I am in need of some VBA macro magic here. I have a stream of data that represents energy usage on an hourly basis. It is in one column currently that goes Day 1 HE 1, Day 1 HE 2, etc. I would like to have a macro that takes the 24 hours and transposes it into a table that has the...

Hi there, I am running a find and search function on a column of data on a simple Macro I have created. However I seemed to be getting error 91 when it is encountering data that it cannot find. My current code is: Range("I:I").Select Columns("I:I").Select Selection.Find(What:="1"...

Hi Everyone, I'm looking for you expertise here! I have never had to do this before so I am very confused with it all. I am trying to put about 400 different workbooks (all headings and rows) into one worksheet table. I need the formation to go from being in vertical in the workbooks to...

https://imgur.com/a/tO6cmWG The issue is the range i'm filtering will vary so the established range C1:C690963 and lower in the macro A1:A690963 need to be undefined. Does that make sense. Besides i'm using the same data set input as yesterday and yesterday I was not receiving an error so maybe...

I found this How to remove all non alphanumeric characters from a string except period and space in excel? which is a UDF to remove the opposite; nonalphanumeric characters. I don't have a list of what classifies as a non-numeric. I'd want to intergrate it in a macro like shown in the top...

Hi All, I am not sure that this is the correct place to post this, but I have a VBA question. I found a set of code online to do what I desire, but I need to modify it to suit my needs. What I am doing is this: I have a set of Names and values separated in my excel sheet as "Divisions" ex...

The below macro clears cells that do not match with the D column range. The issue is my required ranges are too large for the macro to run on my computer. Sub REMOVEPIDS()Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Application.DisplayStatusBar = False...

https://imgur.com/a/OyeoFv9

The columns relevant here are BA,BB&BC although I may put this data on a separate sheet just in A, B & C The number of cells occupied and contents in BC changes. Which is why I can't press record and be happy. On Columns BA,BB&BC data filter is applied. I click the header drop down in BC and...

For example I would paste in A1: 995 950-993 *995-118 118 790-118 I want it to return on a separate sheet: 995 2 950 1 993 1 118 3 790 1 Right now I have it coming back as exactly what is pasted in the cell and cannot figure it out what so ever.:confused: Thank you for your...

https://imgur.com/a/2ejmwWa I have something copied on my clipboard and I want to select sheet 2 row F (first blank cell) and I have the pasting code ready but I can't fix the in-between despite searching forums such as this one. The first picture starts at the copy action. after copy I try to...

If recorded control shifting down on C1 VBA creates a defined cell range instead of a dynamic one Range("C1:C13"), CopyToRange:=Range("D1"), Unique:=False So I tried to insert VBA I thought would correct the issue because it works normally but got this error Wrong number of arguments or invalid...

Hello, I'm Looking for an excel Formula or VBA code to color (highlight or background fill) columns based on the count series of max frequency consecutive positive numbers. It should be left open ended for more data to be added after column P and Lower than row 5. Rows described: 1. max...

https://imgur.com/a/PiUe6Lz I want the macro to be relative because the actual data is in adjacent 2 lists so it just keeps going down. All the VBA I know just overwrites the cell or Takes the first row's formula copied as a quote and applies that to every output rather than whats inside the...

Some Background We provide a software system to organisation to manage their grant making processes. Our online system removes laborious paper centric practices and moves this all online. When a client signs up with us, we need to import a history (3 years) of their grants so that when...

Hi, I want to create a XML file in excel. I have created the schema in excel in the correct syntax needed for the XML file. I have my date in column B - Z - column A has some static elements which will be used within the schema. I want to paste my data which will vary in to columns B-Z and...

Hello! Every week, I get a report on student grades for tests/projects on different dates. The report that's generated exports to excel but it's not the easiest to work with. I'd like to make a macro to convert this data to a different format (Like student names in rows, classes in columns...