Nick12QB
11-17-2006, 11:03 AM
Hello,
I have barely any experience with visual basic, but I am creating a master file for a company that I recently started at that may need some coding.
What I have is a workbook with a list of building names and the data about the buildings in one sheet. On the second sheet, there are the building names, but the sheet also lists all of the addresses that are grouped under the building name.
What I would like to do is be able to click (or select and press a run button) any cell in the building name column on my first sheet, and then the script would take me to the second sheet, and that data is filtered to only include lines with the building name that matches the one I selected on the first page.
On the first sheet, the building name is column E and it is entitled "Building Address". it contains the same data as column D on sheet two, which is entitled "Franchise Description". Sheet one is called "Territory List", and sheet two is entitled "All Building Addresses"
I think, through writing this out, what I want to know is if there is a way to select text on one sheet and run a macro to custom filter for that text in a specific column of another sheet.
Any help would be greatly appreciated, and I feel really bad asking such a favor without prior contribution, but I am in a tight spot, and I don't have the time to learn this yet myself.
Thanks
I have barely any experience with visual basic, but I am creating a master file for a company that I recently started at that may need some coding.
What I have is a workbook with a list of building names and the data about the buildings in one sheet. On the second sheet, there are the building names, but the sheet also lists all of the addresses that are grouped under the building name.
What I would like to do is be able to click (or select and press a run button) any cell in the building name column on my first sheet, and then the script would take me to the second sheet, and that data is filtered to only include lines with the building name that matches the one I selected on the first page.
On the first sheet, the building name is column E and it is entitled "Building Address". it contains the same data as column D on sheet two, which is entitled "Franchise Description". Sheet one is called "Territory List", and sheet two is entitled "All Building Addresses"
I think, through writing this out, what I want to know is if there is a way to select text on one sheet and run a macro to custom filter for that text in a specific column of another sheet.
Any help would be greatly appreciated, and I feel really bad asking such a favor without prior contribution, but I am in a tight spot, and I don't have the time to learn this yet myself.
Thanks