L
LUE42
I hope someone may be able to help me out...
I have a spreadsheet that is an output of all computers on our network
and what applications are installed on them
The spreadsheet is organized by all computer names listed in column A,
and all software listed in column B.
So, in column A, you will see multiple entries for each computer and
in column B, you will see a different software name in each of the
rows next to the computer name in column A.
On another sheet, I would like to be able to choose from a dropdown
list of computer names (grabbed from column A) and have it display all
the software that is installed on the computer (column B). I have
already made that dropdown list and it is at C2 on the sheet.
So, on this sheet, I would like to be able to quickly be able to
select a computer name and have it list all the software that is on
the PC. I am doing this on a different sheet as there is a bunch of
other lookups I am doing that make up this page.
Thank you very much
Cory
I have a spreadsheet that is an output of all computers on our network
and what applications are installed on them
The spreadsheet is organized by all computer names listed in column A,
and all software listed in column B.
So, in column A, you will see multiple entries for each computer and
in column B, you will see a different software name in each of the
rows next to the computer name in column A.
On another sheet, I would like to be able to choose from a dropdown
list of computer names (grabbed from column A) and have it display all
the software that is installed on the computer (column B). I have
already made that dropdown list and it is at C2 on the sheet.
So, on this sheet, I would like to be able to quickly be able to
select a computer name and have it list all the software that is on
the PC. I am doing this on a different sheet as there is a bunch of
other lookups I am doing that make up this page.
Thank you very much
Cory