excel doubt

hello sir,

i need to transfer data to other spreadsheet like

name address city number email favourate colour etc

now i want to create separate workbook for different cities along with the details..

i was doing with a long way –

1st step – Ill filter data with city

2nd- ill copy the data

3rd – create new workbook

4th- paste the data 

 

this process going on every time i have to separte and create separate book of every cities (500+)

is there any shortcut for that 

kindly help me with that

By: spark

Leave a Reply

Your email address will not be published. Required fields are marked *