Move Data from Master List to Sheets with City Name
I have a Master worksheet that has both Dallas and Austin listed in the City Column. I tried to use an "if" formula to populate the Dallas worksheet with the row information that shows Dallas as the city and one to also populate the Austin worksheet with all Austin row information.
I am fairly new at Excel so really appreciate your help. This is pretty fabulous to be able to get help from professionals!
Thanks!!
Short Sample Workbook attached.
|