Create new rows, with a macro running over all Worksheets

[Bongobob21]

Hey,

I created a macro which loops through every worksheet for a certain word. If that word is found on a worksheet it should copy every value in a row one after the other and copy it into a new row on a specific worksheet, until there is no value anymore in that certain row. I created this Macro, but it doesn't work and I don't really know where I made a mistake. If I want to

Please Login or Register  to view this content.

I checked with a MsgBox, that it loops through the different Sheets, but it doesn't fill the var variables at all. Any suggestions where I made a mistake in the Loops or If statements?

Thank you!

[StephenR]

You are not actually referring to the sheets in your code

Please Login or Register  to view this content.

[stnkynts]

One thing is that you are not correctly looping through the sheets. Your sheet identify is the variable "I" but nowhere do you actually use "I" as a proper sheet reference.

Please Login or Register  to view this content.

In addition, I am not sure what you are trying to do with the variable "counter" but I am pretty sure it is wrong.

Provide clear and concise details on what you are trying to accomplish for an exact answer.