looping code

I have a spreadsheet that survey's equipment condition for equipment condition for multiple places, which is designated by ID (see Data Input example). For each row I need the equipment under the columns header "E1" and "E1C" copy/pasted into another worksheet ("Data Output") with the ID number...

Hi all, I am trying to filter data from a table (not pivot table) and then move boxplot charts and scatter charts to different sheets. I tried to do this by looping at the beginning but I don't know how since every "category" is named differently and also I want to copy charts as pictures and...

I have a worksheet, there is currently 14 columns with information in them, only 6 of the columns are important. There are currently 3,500 rows in the workbook. I have created a macro that loops through column E and highlights the range C:N for any value greater than 1. That value is in a summed...

Hello, I am trying to use loop for the first time. I need to loop through open workbooks, and close each workbook after I have copied the data from it. I am trying the following the below to indicate the next workbook, but it always treats the value as true even if there is only the workbook...

Hi, I have some code which opens another workbook, copies two columns and pastes it into the current workbook. Now the code works perfectly, except that it seems to be repeating itself 4 or 5 times before it is done and subsequently the code following it is also repeating. Wasn't sure if this...