loop through sheets

  1. J

    Loop through worksheets - convert used range to values - NOT LOOPING THROUGH SHEETS :(

    Hello, I am attempting to loop through all of my worksheets and if the worksheet begins with "Labor BOE" I would like to copy/paste everything as values (there are formulas all over the sheet that I want to paste as values). Unfortunately, all of my attempts only work on the current "Labor BOE"...
  2. B

    PLEASE HELP!!! Loop through worksheets 2 - 26 and find blanks in columns 1, 2, 3, 4, 5, 6 with varying rows

    Hi. I'm quite a newbie w/ Excel VBA and need your help. I've struggled with this for quite a while and can't seem to figure it out. I need a VBA code that runs through each row in columns 1 thru 6 and finds blank cells in columns 2 to 6 when there's a value for column 1 in the same row. I need...
  3. S

    I am new here and need help

    I have a folder with 5-6 workbooks and each workbook has multiple worksheets. I am trying a code to loop through the sheets in each workbook in that folder (which ever is selected on running the macro) copying the data from B:H and pasting the data in Mastersheet with Sheet1 name as...
  4. E

    Loop throughs rows and make value and sum

    Hello people, I have got a excel document that looks like this see below: I need a function that check first after how many reps the number in the column A , in this case example: 34234 = 12 reps. then when it finds in Column J the value "IND" = 4 select the cell in same row but column "AB"...
  5. S

    Loop through of sheets and execute calculations based on dynamic sheet references

    Greetings, Is it possible to loop through a list of sheets and execute some calculations that have sheet references from a different list of worksheets? For example, you have a list (list 1) of your worksheets, which will be the destinations of the calculations, and you have a second list...
  6. B

    Loop through 4 named worksheets in a workbook

    Windows 7, Excel 2010; I have a workbook with four named worksheets ("Sheet_A","Sheet_B","Sheet_C" and "Sheet_D") I want to loop through those for sheets and perform the same tasks in each sheet. Can someone tell me how to loop through each of these 4 sheet. Thank you in advance for any help...
  7. R

    How to loop for 3 worksheets

    Hi, I want to loop for 3 worksheets to do the same tasks. The task list is huge with about 50 lines of code. The names of the sheets are "Month 1", "Month 2", "Month 3". And in the task, I need to shift between the Month sheet and another Source sheet. So based on the Month, I need to compare a...

We've detected that you are using an adblocker.

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.
Go back
Back
Top