Hello everyone and thanks for any help you might be able to provide me, with my project. What I am trying to do is update a single sheet and have as much of that information populate another sheet as I can, but only if the customer is a certain one AND the "SFDC Category" = "Closed Won". Here is what the first part of my sheet looks like (blurred info that is not necessary):
Here is the second sheet that I am looking to populate information onto:
What I would like to accomplish is the following:
For all of the columns that contain the account name "iland" and the "SFDC Category" = "Closed Won", I would like to have it populate the second sheet with the "Project Name" value from the same row, the quote number value from the same row of the "Quote #(s)" column, the price from the "Total" column in the same row and the value from the same row in the "HPE Order #" column.
Thank you in advance for the help.
