Hello Guys, I am trying to record a Macro for exell and i am dealing with
some information that changes size from day to day for example.

1 day i can have 100 rows of information another day i can have 300

The information is separeted with titles and it is all located in column A.

I am trying to record a macro to separate each set of information divided by
a title to a diferen sheet.

What i did was press the record button and then i did de function search and
searched for the title then i selected everything under the words that i
searched.

The problem:

since this information changes size everyday the macro goes to the same cell
everytime it does not matter where the word i searched is located.

Sorry if this is confusing but can any body help me?

Gmata