Hey All,
This is my first time on this board, but I am hoping to find someone that can help me. This is what I am looking to do:
I have an excel where Sheet1 will contain a template that is supposed to be a "summary" type page. Sheet2 will contain thousands of rows and many columns of data.
What I am trying to do is have the summary page be dynamic in displaying only items from a certain column IF another column within the same row has a certain variable.
So let's say I have 5 columns (A-E) on Sheet2. If any cell in column D has either "Earth" "Wind" or "Fire" THEN what I want is in of Sheet2 on any row that meets that criteria in column D to paste the data from column B within a certain cell that will have a Title in Sheet1.
Two more possible complications:
1.) If I go next week and paste the same report in Sheet2, the columns will be the same, but the number of rows could change depending on how many are on each report.
2.) I need to get all the data into one cell so that the Summary template will always display that information in the same spot.
If you could figure this out for me, you'd be a lifesaver!!!!
This is my first time on this board, but I am hoping to find someone that can help me. This is what I am looking to do:
I have an excel where Sheet1 will contain a template that is supposed to be a "summary" type page. Sheet2 will contain thousands of rows and many columns of data.
What I am trying to do is have the summary page be dynamic in displaying only items from a certain column IF another column within the same row has a certain variable.
So let's say I have 5 columns (A-E) on Sheet2. If any cell in column D has either "Earth" "Wind" or "Fire" THEN what I want is in of Sheet2 on any row that meets that criteria in column D to paste the data from column B within a certain cell that will have a Title in Sheet1.
Two more possible complications:
1.) If I go next week and paste the same report in Sheet2, the columns will be the same, but the number of rows could change depending on how many are on each report.
2.) I need to get all the data into one cell so that the Summary template will always display that information in the same spot.
If you could figure this out for me, you'd be a lifesaver!!!!
