I have a code that works but how can I adjust it to activate for a different row?

I have a code that chooses the data that correlates with the condition and inputs it in another sheet, which is in the workbook, but how do I adjust the code or find a new code to make it work for the 5th row instead of the 1st row? Thanks for your help!

.
Sheet1, B5 is an integer ... if selected ... the macro works.

Sheet1(2), B5 is NOT an integer .. if selected ... the macro will NOT work.

Sheet1(2), B6 IS an integer ... if selected ... the macro WILL work.



I don't understand why you want to edit the existing macro ???

I found out that the problem I was having was that the data was overflowing, so would you happen to know how to make it long?

.
Explain : "data was overflowing" and "make it long"

What is the ultimate goal you are wanting ?

Sorry, the post seems like it works because it has less data than the document I'm actually trying to organize. The macro separates data that matches one condition and puts it in a new sheet but the data starts on the second row and my data starts on the 5th row because I have to put some title information before the data. So I thought that the macro didn't work on my document because the data started on the 5th row, however after trying another code that does a similar function, the error was that the data was over flowing so it was past the capacity and had to be labelled as "long" instead of "integer". I'll post that code too and maybe it can give you an understanding but this code doesn't have dim as long so I don't know how to call out the values in the cell to be long. Hopefully I described that well enough. Thanks for following up with me.

Please Login or Register  to view this content.

.
Ok ... so if I correctly understand ... from the MAIN SHEET where all the data is located, in Column B ... beginning on row #5 and down there are repeating terms
of "conditions".

The goal is to create a separate sheet for each unique term ... then copy all the rows of data where the unique term appears in Col B ... to it's own named sheet.

Is that correct ?

https://www.excelhow.net/split-data-...on-column.html
Here is one of the resources I found to help with the code.

Sorry I think another post I posted didn't go through, but yes that's exactly what I'm trying to do. When I tried adjusting the code I noticed it was breaking and I found another resource that said it might have been because there is too much data for the way the code was written since the data I'm working with has over 60,000 rows. The code works when I have less, however it breaks with this data set, and the resources say to use "long" instead of "integer" so I'm thinking that might be the problem. Is there a way to adjust for larger sets of data?

.

Please Login or Register  to view this content.

thank you so much for your help and effort. Your code gave me a better guide on how to adjust it to make it work.

.
You are welcome.