I have an Excel sheet with 12 columns and 4000+ rows. In Column E, I have a list of part numbers. These part numbers may or may not be repeated based on the city names found in Column F. For example, Part A (located in Column E) may be in 3 different rows: one row for City X, one row for City Y...
Hi folks,
Is there a way to auto-fill laterally across columns like there is down rows perhaps using a macro?
I was thinking this might be handy in some instances I've run into, but I'm not sure how to make the ActiveCell part work.
Sub FormulaFill()
'
Dim rng As Range
Dim y As...
Hi,
In my worksheet, I would like to add a macro which does the following at once: 1) refresh the active workbook, 2) clear the contents of a specific worksheet, 3) import columns data from a closed workbook, 4) refer to the path of the closed workbook based on cell data in the open workbook...
I want to be able to drop information into sheet 1, and automatically in sheet 2 it searches for the column name and inputs the data below that?
In more detail, I want to be able to drop multiple different invoices into sheet 1, the problem is they are never laid out the same.
I'm hoping to...
Hi there!
I am trying to write VBA code to execute the following (visual screenshot attached)
If the concatenated store and zip code value (ex: Walmart98101) is repeated in any of the columns (ex: columns C, E and F), I need to ensure the value of row 1 is the same in each instance of the...
I am working on a Classroom Files.
Where i have many files containing report of each test like Test 1, Test 2, Test 3...
I have to make a Master workbook that will contain the Mark Columns from All the Test Files
I tried the PowerQuery ( I am very much new to PQ) but failed as it was...
I have the following spreadsheet with about 2000 rows,
ABCDEFGHIJKLMNO1Ref No(s)TitleEff DateATAComments2TEST 1B737 ADVERTISING PLACARD INSTALLATION25Referenced By: TEST3ParagraphMethod Of ComplianceRLifeLast
ComplE/D O/RideLimit/ IntervalF/ LNext
DueRemain4Initial Issue...
Hi, I'm new to the board and a newbie to VBA. I tried different approaches found online but seems none of mine works.
So here is my questions: I need to copy 5 columns from Worksheet A to Worksheet B. The columns in worksheet A and B have different rows: let's assume wsA has 20 rows and wsB...
Hi everyone,
I'm searching the web but I only found one code that kind of works but I need to make it more complex.
Let me explain.
My issue is that I have an Excel sheet with multiple worksheets, which all contain the same kind of information but are copied weekly by me. So every week, I will...
Hello ?
I would like to compare 2 columns populated with a lot of text in each cell, and then have inserted on the right a third column that would mark the differences between the two selected columns.
For example, I have some outdated text in column A, and some newer, amended text in column B...
Thanks in advance for any ideas you may have on my issue here:
I have column ("times,") formatted as time (XX:XX:XX AM/PM) that has times in it. I have a second column ("times round,") that is referring to the first one and is ROUNDING (down) those times to 30 minutes (and formatted the same)...
Hi Masters, can anyone help me create a VBA code that can help remove unwanted columns start from column H..
I want a VBA that I can enter just the column header that I want to remain in the sheets.
Sample: I want to enter " Tea " in the input box then all other columns with different...
I am trying to output concatenated content into defined columns. There are 6 pre-defined columns (see the image below): Requirement Text, Requirement Rationale, Requirement Guidance, Requirement Lessons Learned, Verification Rationale, Verification Guidance, and Verification Lessons Learned...
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...
Hi, I was search online and found old thread Merging two columns; only overwriting blank cells with the solution below which works great but only if I type in the =K7 formula in each cell. I will have 1000's of blank cell after I do a Xlookup. Is there anyway to get the formula to auto fill all...
Hi guys!
I'm wondering how to build a macro for the following repetitive tasks:
1. Selecting a specific cell,
2. Goes to the last row with data,
3. Selects all the row, since the 3rd column until the end,
4. Cut all these cells
5. Pasts on the column A of the first blank row below the...
Hi all!
I have a code to sort columns of data based on the value in row1 of the column. Its a fairly large code and I was wondering if theres an easier version? Basically I want it to sort 1-200 in ascending value, with X values moved to the end. This macro is run using a shape/button.
Thank...
I have several sheets that have hidden rows and columns but on occasion I need to unhide them. This usually results in a freeze/crash of the sheet due to the volume of columns being unhidden. How can I limit the number of both rows and columns to something like 15 and 50, respectively?
Can anyone help me with this code that I have problems doing for the last 2 days. What I need to do is find the last column in that particular row starting from column H onwards, if there is any text that shifts down the row in column G and repeat the action; when it finds the text in a cell it...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.