for each statements

I am trying to manage a list of inventory items using Excel 2016. I have three end products, each with its own Bill of Materials, and I have the relevant information all on one worksheet (Inventory Part, current inventory quantity, and quantity of said part in each of the 3 BOMs). Say I am...

Hi everyone, this is my first post so I apologize in advance for any mistakes I can make posting. Here's my problem: I wrote a macro to loop through a range of cells and then, if the cells' value is more than 0, to copy the cell and the adjacent ones to another sheet. The problem is that it...

I'm very new to VBA. I've done my best to copy and paste from forums like this one and then alter it for my purposes, but obviously that can only get you so far. I am trying to get the following code to repeat adding the rows and the text for every time the word "Date" appears in column c. I...

I'm trying to use the for each next loop to test whether the value of a cell in a range = "Y". If it does I want it to run firstpart however regardless of whether each cell = "Y" or not it runs firstpart. Can anyone help me on this? Sub Entireprocess() Dim autrnl As Range Set autrnl =...