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...
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...
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,
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...
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
I have the following formula but its not working...
Need to check if both matches are on the same row
which works, but i need it nested within my other formula
Cant work it out, could...
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
Column F =...
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...
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...
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.
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:
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...
Okay so I've been struggling with this for a while and I can't seem to formulate my question that great either, bear with me please.
So, I have created an excel sheet that collects exercise data into columns extending for several weeks.
In my data sheet I am trying to collect these data points...
Hello, I have a Data-Validation Drop Down on Cell A1 that contains Board Game Categories and whenever I click them, I need excel to pull all the Board Games associated with that category and list them down in COLUMN A. So far, my code is only pulling Board Games that has that specific category...
I have a list of direct debits,
sometimes I need to edit or adjust the amount i'm paying for one or more of them for that month
I need a macro that can ask me which ones I want to change and by how much and then add reduce the following months amount by that amount?
So here in...
Thank you in advance for your help!
So I would like to have a separate sheet for certain data that is entered in another sheet, but all located in the same book. Is there a way to do this?
For instance, if the text in cell D2 matches a certain criteria, then excel will auto-populate...