troubleshooting Question

Trying to populate a summary worksheet in excel from another worksheet

Avatar of Steve Myers
Steve Myers asked on
Microsoft ExcelVB ScriptSpreadsheetsMicrosoft Office
14 Comments1 Solution170 ViewsLast Modified:
I have a summary worksheet in excel I am trying to create, it is to be generated from a much more detailed server inventory worksheet. Within the inventory worksheet called 1-inventory I have a server name in column A, a Server Role in Column B, and a Severity level of the server in Column C. The severity level of the server in Column C sets the reboot schedule of those servers.  In Column G is labeled as Order, what this is, is a order as to which the server should be rebooted, this is per severity since these reboots happen on different days, 1 being the first server to reboot and the word Any meaning can be rebooted in any order.

On the Summary Page, I am looking to derive the following from the inventory page in this format:

Column A - (Low Priority) Server Name, Column B - (Low Priority) Reboot Order
Column C ( Medium Priority) Server name, Column D (Medium Priority) Reboot Order

I would also like the order of these servers shown on the summary page to be ordered by the reboot priority and only populate servers with the role with the word "Windows" in it, I am also ok to put 99 as a replacement for the word Any to keep the inventory column J as numerical for sorting purposes.

I have tried VLOOKUP and the closest I came was to return only 1 field, I am trying to populate the summary page as sort of an executive dash board and would need to fill all the cells in each column with the matching results. I am looking to do this for each severity role.

I tried to be as descriptive as possible and attached is a sample spreadsheet.

Any help is appreciated. Thanks!

sample1.xlsx
ASKER CERTIFIED SOLUTION
Tom Farrar
Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros