If your data and titles are all Column A, what distinguishes a title from
your data? Is it that your data is numeric and, of course, your titles are
not? Or something else?

--
Rick (MVP - Excel)


"Gmata" wrote in message
...
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