Searching Multiple Excel Workbooks
 

I was wondering if there are any add-ins or simple programs that would make
it easier to search for information in Excel workbooks? I use a nultiple
workbook system that has thousands of rows of information that I need to make
more user-friendly for others to search for the information within them.
Ideally the information would be pulled up within a worksheet formatted
similar to what we use. Any suggestions?

Searching Multiple Excel Workbooks
 

Maybe it's time to dump excel and put your data into a real database system
(from a non-real database user!).

If you have MS Access, maybe you can keep the data in one central location and
let the users get to the records they need.

G.Simpson wrote:

I was wondering if there are any add-ins or simple programs that would make
it easier to search for information in Excel workbooks? I use a nultiple
workbook system that has thousands of rows of information that I need to make
more user-friendly for others to search for the information within them.
Ideally the information would be pulled up within a worksheet formatted
similar to what we use. Any suggestions?

--

Dave Peterson

Searching Multiple Excel Workbooks
 

Thanks, I have suggested that to my manager, but we don't have any IT
resource people who are familiar enough with Access to produce what we need.
I've been trying to learn it myself but I've hit a roadblock. For instance,
when converting the excel file over to access, how do you maintain
hyperlinks? Some columns also contain both text and hyperlinks and there
doesn't seem to be any other way to display the information the way we have
it set up, but Access doesn't support having both a hyperlink or text if its
in a single field. Any suggestions?

"Dave Peterson" wrote:

Maybe it's time to dump excel and put your data into a real database system
(from a non-real database user!).

If you have MS Access, maybe you can keep the data in one central location and
let the users get to the records they need.

G.Simpson wrote:

I was wondering if there are any add-ins or simple programs that would make
it easier to search for information in Excel workbooks? I use a nultiple
workbook system that has thousands of rows of information that I need to make
more user-friendly for others to search for the information within them.
Ideally the information would be pulled up within a worksheet formatted
similar to what we use. Any suggestions?

--

Dave Peterson

Searching Multiple Excel Workbooks
 

I'm still a non-real database user--so I can't help.

But there are newsgroups (just like these excel newsgroups) where you can post
your specific questions.



G.Simpson wrote:

Thanks, I have suggested that to my manager, but we don't have any IT
resource people who are familiar enough with Access to produce what we need.
I've been trying to learn it myself but I've hit a roadblock. For instance,
when converting the excel file over to access, how do you maintain
hyperlinks? Some columns also contain both text and hyperlinks and there
doesn't seem to be any other way to display the information the way we have
it set up, but Access doesn't support having both a hyperlink or text if its
in a single field. Any suggestions?

"Dave Peterson" wrote:

Maybe it's time to dump excel and put your data into a real database system
(from a non-real database user!).

If you have MS Access, maybe you can keep the data in one central location and
let the users get to the records they need.

G.Simpson wrote:

I was wondering if there are any add-ins or simple programs that would make
it easier to search for information in Excel workbooks? I use a nultiple
workbook system that has thousands of rows of information that I need to make
more user-friendly for others to search for the information within them.
Ideally the information would be pulled up within a worksheet formatted
similar to what we use. Any suggestions?

--

Dave Peterson


--

Dave Peterson