|
|
#1
01-27-2016, 06:35 PM
|
|||
|
|||
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Complex calculation from multiple sheets to master sheet | inreality01 | Excel | 49 | 01-06-2016 03:09 PM |
 Excel, transfer data from Master Sheet to sub sheets, using key word from column
|
anvqui | Excel Programming | 9 | 06-16-2015 01:35 PM |
|
seprate process data from main master list
|
Santhosh AMASL | Excel | 1 | 01-12-2015 09:33 AM |
| Combine Data From 2 Sheets into a new sheet | bremen22 | Excel | 1 | 09-11-2013 12:59 PM |
|
How to syncronize data in two different sheets
|
diegogeid | Excel | 2 | 09-30-2010 12:19 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode