Link to home
Start Free TrialLog in
Avatar of Roman F
Roman FFlag for United States of America

asked on

Help me with Macro please

Let say i have an excel file called Main
The file has a single sheet called Data
The sheet has about four columns, the last one is City
Like example User generated imagei want to run the macro which will automatically filter the Data sheet by City
It always two city so it means it should add two additional sheets: Data LA and Data San Diego.
After running the macro the book will have three tabs/sheets:
Data----------------original
Data LA------------ filtered by City where City is LA
Data San Diego--filtered by City where City is San Diego
Main.xls
SOLUTION
Avatar of Ardhendu Sarangi
Ardhendu Sarangi
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Roman F

ASKER

Thank you,
To nutsch, your solution is the best