row

Each row in the database is assigned a unique ID number (5 digits long) I want to be able to enter than ID number in a textbox in a userform and have the row information (4 columns total) displayed in a listbox. I want the listbox to update after each 5 digit long ID number entry so I can keep...

Hi guys I need to insert two rows after a row with some content like this: To this: I haved found this code: Sub InsertRows() Dim Rw As Long Dim Rng As Range Set Rng = Sheets(1).Range("A4") Rw = Rng.Row Do...

Hi all, I am wondering if anyone can help with this following spreadsheet VBA – my knowledge to date, has been web searched, combined with a mixture of cut and pastes solutions posted on this forum ?. Unfortunately, my own knowledge doesn’t extend past that and I have been unable to get my...

Hello, I'm defining my max rows via a basic lookup =LOOKUP(8,1/('Data'!A:A<>""),ROW('Data'!A:A)) This will be named "Rownum" to call globally. So for instance Rownum = 345 or however long Sheet "Data" col A is. I'm looking to change the hard-coded "z20" and "aa20" to still reference the...

Dear all, I am a beginner here. I would like to ask a help for someone who can help me to solve the problem. I have around 800 data in excel and I want to move data from one column to different column and row. It is difficult to say here, I will give the example in the table below. Please...

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...

Hi all, I'm new to VBA so trying to learn as much as I can but I'm stuck on this one. I'm trying to create a macro that when the appropriate button is pressed, resets the formulas in a column that have been overtyped. I can do this for a single cell, though I want to create one that performs...

Good evening everyone, I'm looking for some code in vba that can find specified dates in a line, if the date is not the same I need to delete the 3 columns, I want to leave only dates in the line that correspond to date1 and date 2 as in the example before later

Hello, I am trying to highlight the value "0" with conditional formating in consecutives cells (in the table) in the same row and in the same colunm like I done manualy in picture b3a. The first value in the table is in cell B3. I have this formula...

Hi, I have this VBA code that I found on this site. I have tweaked it a tiny bit for my needs. It essentially is a vlookup but returns multiple matches. However, it inputs the matches next to the desWs value (“A1”). Goes column by columns. How can I edit this to input the data below? Also I...

Hello all, I'm unsure if this is something that can be done. However, I'm wondering if it's possible to add a subtotal (from a measure) onto a row value? In the attached example, I would be looking to add the Inbound actual excl recharges value, with the inbound unallocated actual value on the...

Having watched a MrExcel YouTube video about pulling records based on a condition, I attempted to reorganise a large question bank we have for learners. Unfortunately, the formula doesn't seem to work as it's getting caught pulling correct row numbers and always returns 0...

Hi, I'm trying to count how many weeks a specific Product has been active. The Product has been active if they have a value for that week. The value in Column B has to match a defined value (i.e. A, B, C, D - the data in cells B12-B15), and then the data from columns C to G have to be...

Hi All, Please see below. I need a formula (in yellow cells) that will return how many times the number is counted as well as the corresponding row returning a "yes". So for example, cell BA3 should be 6. Bit stuck with this one so any help will be appreciated. Thanks in advance, Mark

Hello I'm trying to figure out a code that could insert a new row where the sequential numbering mismatching. As you can see in the picture a row is missing for POS 2. I would like a code that could insert, in multiple places, during the sequence. For example, in some cases the sheet could be...

Hi All I have 2 workbooks and i want to check if a row matches another row in another book. Lets say in Workbook1 you have the following Workbook 1 Workbook2 A B C D T Y U O W E R T A B C D I have the following formula but its not working...

Hi all Need to check if both matches are on the same row =row(A6)=row(B6) which works, but i need it nested within my other formula =IF(AND(COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),A6),COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),B6)),"Match","No Match")+ Cant work it out, could...

Hello, I'm trying to get 2 multiple results from 2 different columns under 1 column and in order. Column E = Matching Apple in column A -> returning C value {=INDEX($C$1:$C$6,SMALL(IF(ISNUMBER(MATCH($A$1:$A$6,$E$1,0)),MATCH(ROW($A$1:$A$6),ROW($A$1:$A$6)),""),ROWS($A$1:A1)))} Column F =...

Hello all, I'm quite new to VBA searching for guidance. I was wondering if anyone had an idea how to write an excel VBA script that would do the following: 1. Search column B for a cell containing "Checker Plate". 2. And if the adjacent cell (Column A) contains a "6" or a "9" then highlight...

Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...