Roman F
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 i 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----------------origin al
Data LA------------ filtered by City where City is LA
Data San Diego--filtered by City where City is San Diego
Main.xls
The file has a single sheet called Data
The sheet has about four columns, the last one is City
Like example i 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----------------origin
Data LA------------ filtered by City where City is LA
Data San Diego--filtered by City where City is San Diego
Main.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
To nutsch, your solution is the best