Hello All,
GOAL:
Sheet 1 is the master spreadsheet (with more data than my example, but I am making it simple). Sheet 2 displays a summary of data. It will have two columns PAID FEE 1 & PAID FEE 2 with the list of business names that have paid the fee (hopefully alphabetized).
Sheet 1
<tbody>
</tbody>
Sheet 2
Desired Output
Column 1
<tbody>
</tbody>
It would be nice if the business names were alphabetized under each column. The spreadsheet gets updated all the time so it should have a trigger that if sheet 1 changes to update sheet 2.
One option is on sheet 2:
=IF(PAID FEE 1 on B2= PAID, BUSINESS NAME on A2,“"), copy this equation down to the number of businesses.
One option is on sheet 2:
=IF(PAID FEE 2 on C2= PAID, BUSINESS NAME A2,“"), copy this equation down to the number of businesses.
I am breaking syntax but wanted to communicate the logic.
This works but there is blanks for the false statement. Also this doesn't run each time the sheet runs, correct? I also wanted it to alphabetize. I can do it with a filter but that doesn't seem like the proper way.
Do I have to create a macro some how? How would it look? The overall goal is to have a separate sheet that summarizes data from sheet 1 for someone that isn't tech savvy. So sheet 2 doesn't perform any calculations or make changes to sheet1 but displays the data in a summary.
I hope that makes sense, and I appreciate any help I can get.
Thanks Mr. Excel Community
GOAL:
Sheet 1 is the master spreadsheet (with more data than my example, but I am making it simple). Sheet 2 displays a summary of data. It will have two columns PAID FEE 1 & PAID FEE 2 with the list of business names that have paid the fee (hopefully alphabetized).
Sheet 1
Business Name | PAID FEE 1 | PAID FEE 2 |
A | ||
B | PAID | |
C | PAID | |
D | ||
E | PAID | |
F | ||
G | ||
H | PAID | PAID |
I |
<tbody>
</tbody>
Sheet 2
Desired Output
Column 1
PAID FEE 1 | PAID FEE 2 |
B | C |
E | H |
H | |
<tbody>
</tbody>
It would be nice if the business names were alphabetized under each column. The spreadsheet gets updated all the time so it should have a trigger that if sheet 1 changes to update sheet 2.
One option is on sheet 2:
=IF(PAID FEE 1 on B2= PAID, BUSINESS NAME on A2,“"), copy this equation down to the number of businesses.
One option is on sheet 2:
=IF(PAID FEE 2 on C2= PAID, BUSINESS NAME A2,“"), copy this equation down to the number of businesses.
I am breaking syntax but wanted to communicate the logic.
This works but there is blanks for the false statement. Also this doesn't run each time the sheet runs, correct? I also wanted it to alphabetize. I can do it with a filter but that doesn't seem like the proper way.
Do I have to create a macro some how? How would it look? The overall goal is to have a separate sheet that summarizes data from sheet 1 for someone that isn't tech savvy. So sheet 2 doesn't perform any calculations or make changes to sheet1 but displays the data in a summary.
I hope that makes sense, and I appreciate any help I can get.
Thanks Mr. Excel Community