brent.fraser
New Member
- Joined
- Aug 27, 2009
- Messages
- 41
Hi. I am trying to create a workbook with multiple sheets. The first sheet is the master sheet that gets filled out with information in certain columns (location, category, description and URL). I want to see if I can reference the information on the first sheet on another sheet based on different criterla like location.
For example, I want to have all the information (location, category, description and URL) with the location of "new york" all on one page. The next worksheet would be "new jersey" and so on.
My goal is to set up the worksheet so it references the master sheet based on certain criteria. From here, I am going to export that to XML for an RSS feed and I want it to be as labor friendly as possible.
I have tried lookup, vlookup and index but it doesn't seem to do exactly what I want it to do.
It might be a VBA activity and I am OK with that.
Thank you in advance.
Brent
For example, I want to have all the information (location, category, description and URL) with the location of "new york" all on one page. The next worksheet would be "new jersey" and so on.
My goal is to set up the worksheet so it references the master sheet based on certain criteria. From here, I am going to export that to XML for an RSS feed and I want it to be as labor friendly as possible.
I have tried lookup, vlookup and index but it doesn't seem to do exactly what I want it to do.
It might be a VBA activity and I am OK with that.
Thank you in advance.
Brent
