Formula to search for a word and put that entire row in a list
 

I have a column which contains the word "Contracted" and all corresponding
columns have data which I want to put into another worksheet.
I want to creat a function that allows me to search for only the rows which
contain the word Contracted and then formats the adjacent columns data after
that.
I have probably 3000 rows that it will need to search through putting all
the data in the columns one after another.

Tracy

Formula to search for a word and put that entire row in a list
 

If you meant that literally, Tracy, you should repost this question in Excel
Programming. If you want to create your own customized worksheet function,
it's not that hard to do but it's what we do over in the Excel Programming
forum; here we talk about how to use the worksheet functions that MS built
into Excel. And if you want to use the already-existing Excel functions to
copy data over to another worksheet -- that is, if you want to write a
formula in workbook A that'll put data into workbook B -- sorry, no can do,
because Excel's functions, as far as I can tell, affect only the contents of
THIS cell, never another. Oh, you can write a formula in the other cell to
copy what's in this one; but no formula in this cell can write the data over
there. That takes an Excel program.

That said, writing an Excel program isn't impossibly difficult. If you've
never done it, and this is what you need, at least give it a try. You'll
need help to get you used to the concepts, but you're surrounded by
enthusiasts and lots of them will want to give you pointers.

--- "Tracy" wrote:
I have a column which contains the word "Contracted" and all corresponding
columns have data which I want to put into another worksheet.
I want to creat a function that allows me to search for only the rows which
contain the word Contracted and then formats the adjacent columns data after
that.
I have probably 3000 rows that it will need to search through putting all
the data in the columns one after another.

Formula to search for a word and put that entire row in a list
 

Thank you Bob, guess I'll give 'er a go.
--
Tracy


"Bob Bridges" wrote:

If you meant that literally, Tracy, you should repost this question in Excel
Programming. If you want to create your own customized worksheet function,
it's not that hard to do but it's what we do over in the Excel Programming
forum; here we talk about how to use the worksheet functions that MS built
into Excel. And if you want to use the already-existing Excel functions to
copy data over to another worksheet -- that is, if you want to write a
formula in workbook A that'll put data into workbook B -- sorry, no can do,
because Excel's functions, as far as I can tell, affect only the contents of
THIS cell, never another. Oh, you can write a formula in the other cell to
copy what's in this one; but no formula in this cell can write the data over
there. That takes an Excel program.

That said, writing an Excel program isn't impossibly difficult. If you've
never done it, and this is what you need, at least give it a try. You'll
need help to get you used to the concepts, but you're surrounded by
enthusiasts and lots of them will want to give you pointers.

--- "Tracy" wrote:
I have a column which contains the word "Contracted" and all corresponding
columns have data which I want to put into another worksheet.
I want to creat a function that allows me to search for only the rows which
contain the word Contracted and then formats the adjacent columns data after
that.
I have probably 3000 rows that it will need to search through putting all
the data in the columns one after another.

Formula to search for a word and put that entire row in a list
 

And if you don't find sufficient help there, feel free to drop me a line at
the email address exposed in my profile (after suitable antispam
modification); I'm one of the enthusiasts I was talking about.

--- "Tracy" wrote:
Thank you Bob, guess I'll give 'er a go.

--- "Bob Bridges" wrote:
If you meant that literally, Tracy, you should repost this question in Excel
Programming. If you want to create your own customized worksheet function,
it's not that hard to do but it's what we do over in the Excel Programming
forum; here we talk about how to use the worksheet functions that MS built
into Excel. And if you want to use the already-existing Excel functions to
copy data over to another worksheet -- that is, if you want to write a
formula in workbook A that'll put data into workbook B -- sorry, no can do,
because Excel's functions, as far as I can tell, affect only the contents of
THIS cell, never another. Oh, you can write a formula in the other cell to
copy what's in this one; but no formula in this cell can write the data over
there. That takes an Excel program.

That said, writing an Excel program isn't impossibly difficult. If you've
never done it, and this is what you need, at least give it a try. You'll
need help to get you used to the concepts, but you're surrounded by
enthusiasts and lots of them will want to give you pointers.

--- "Tracy" wrote:
I have a column which contains the word "Contracted" and all corresponding
columns have data which I want to put into another worksheet.
I want to creat a function that allows me to search for only the rows which
contain the word Contracted and then formats the adjacent columns data
after that. I have probably 3000 rows that it will need to search through
putting all the data in the columns one after another.