G
G&GSolutions
I have an excel spreadsheet with two worksheets.
Worksheet 2:
- has multiple entries for different companies
- it also has multiple entries for a particular company for various years
Worksheet 1:
How do I prompt the user for the company name in the second spreadsheet so
that I can provide the user only the appropriate data from the first (larger)
spreadsheet?
Example below - Data loos like the following:
worksheet 2:
Company Name Year col 1 col 2 col 3 col 4
ABC 2005 3 2 0
ABC 2006 4 7 5
ABC 2007 1 4 2
XYZ 2006 9 2 3
XYZ 2007 4 6 4
PQR 2007 1 7 9
In worksheet 1:
When the user opens the excel sheet. I want to prompt the user to enter the
name of the company. Once the company name is entered, I want it to pull the
data related to that company from worksheet 2. For example, if user enters
company name as XYZ then I want populate worksheet 1 with the following:
Company Name Year col 1 col 2 col 3 col
XYZ 2006 9 2 3
XYZ 2007 4 6 4
How do I do this?
I really appriciate your help.
Thank you.
Worksheet 2:
- has multiple entries for different companies
- it also has multiple entries for a particular company for various years
Worksheet 1:
How do I prompt the user for the company name in the second spreadsheet so
that I can provide the user only the appropriate data from the first (larger)
spreadsheet?
Example below - Data loos like the following:
worksheet 2:
Company Name Year col 1 col 2 col 3 col 4
ABC 2005 3 2 0
ABC 2006 4 7 5
ABC 2007 1 4 2
XYZ 2006 9 2 3
XYZ 2007 4 6 4
PQR 2007 1 7 9
In worksheet 1:
When the user opens the excel sheet. I want to prompt the user to enter the
name of the company. Once the company name is entered, I want it to pull the
data related to that company from worksheet 2. For example, if user enters
company name as XYZ then I want populate worksheet 1 with the following:
Company Name Year col 1 col 2 col 3 col
XYZ 2006 9 2 3
XYZ 2007 4 6 4
How do I do this?
I really appriciate your help.
Thank you.