tristar4ever
New Member
- Joined
- Mar 22, 2002
- Messages
- 5
Hello all,
I have a large database containing almost 30 columns and 600 rows. I have a problem that maybe you experts can help me solve.
I want to make a search for a specific word in one of the columns, say column C. And for every match with that word I want Excel to copy, not only that cell, but a few more (selectd) cells in the same row as well and create a new file (workbook in .xls format) with the content. Maybe pivottable would be one way?
Problem is that I would like this file to update itself automaticlly. If I change anything in the database, I want the information in the file to change as well. And if I add a row with that same name written in column C, I want it to be added into the file.
A lot of wishes, can anyone of you see a solution in this?
All help appreciated,
Marcus Karlsson
Nova Airlines
I have a large database containing almost 30 columns and 600 rows. I have a problem that maybe you experts can help me solve.
I want to make a search for a specific word in one of the columns, say column C. And for every match with that word I want Excel to copy, not only that cell, but a few more (selectd) cells in the same row as well and create a new file (workbook in .xls format) with the content. Maybe pivottable would be one way?
Problem is that I would like this file to update itself automaticlly. If I change anything in the database, I want the information in the file to change as well. And if I add a row with that same name written in column C, I want it to be added into the file.
A lot of wishes, can anyone of you see a solution in this?
All help appreciated,
Marcus Karlsson
Nova Airlines