Re: Searching And Printing From Multiple Workbooks
Yes you are correct. I am using 1 workbook which has 20 worksheets in it. I am sorry if this caused any confusion for anyone.
As far as this is concerned, I am not exactly sure what you mean by share column headers. Yes each worksheet have certain categories in common but there are also ones they do not sure. This is why I decided to make multiple worksheets. If I go with a single worksheet, I will end up with multiple columns which are only used by a few rows out of the hundreds in the worksheet. If that is the only way possible to get the search feature that I want to use to work, then that is something I will have to deal with. I hope I interpreted that right. If not, please let me know and I will give you a correct explanation.
Does each worksheet share column headers? (Regardless of the fact that some have more than others) If so I'd suggest making one worksheet with all your data in it; see Efficient Spreadsheet Design.
I am looking into this now. That is along the lines of something I wanted to use for the search feature but can also be used for the later input. Thank you for the suggestion and all your help so far.
I woudl also recommend using a Userform so that you can really control what end users are able to do, in addition to the fact that you can make it "pretty" and overall more user friendly.
I have been trying to look up ways to search and have it bring the result to the fore front for the user to easily see and understand but I have had no such luck finding something that looked like it did what I wanted that I could understand. If anyone has any help, I would be very grateful.
Video Tutorials / Excel Dashboards Reports