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...
Hi Experts,
I am looking for a macro code to create rows per employee based on the start & end date. Each employee will have LOP dates with From & To date, I need to create each row per employee for the dates available between dates.
Attached screenshot for reference.
Regards,
Harish S
I have a dynamic range that all the info in is 1 row and I want to use it to populate a combo box but I can only get the value in the first cell to show in the combo box.
Range named adbk is on a tab named Admin and the data starts in b1 and stretches out on row 1 below is the line of code that...
I'm pretty new to using VBA, so please excuse my lack of knowledge or choice of words to describe my question
Alright so I have a;
-Pivot table 1 @ (A25:B29)
-Pivot table 2 @ (A31:B34)
-A regular table @ (D1:K50) ~ this table is constantly changing it's height (row count) could be K50 upto...
Similar to this link(reference the bottom)- I am trying to return multiple corresponding values with two look up conditions, horizontally, in one row. Then I can apply it down other rows.
Not sure how to go about this- I have been stuck for days. I provided a sample below:
ID
Name
Qty
A...
hello i’m new at work and i need help with a very easy task but i dont know how to do it with tables just with ranges in VBA, but its important to keep it as a table to my boss, what i need is a row goes to the bottom depending on the cell value on column O when it says “ DONE” and i prefer not...
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.