sort and separate to worksheets

**new at this** · 01-21-2013, 02:53 PM

I am putting info on a master sheet, and in the first column i put a reference, a reference represents an area, ie Dublin, Wicklow, etc.
I would like all the rows with the same reference to automatically go to a separate worksheet as below

dublin meeting today
galway whatever
cork asdfasdfasdffaadfs
galway asdfaasadaaasddasd
galway assdafaasfdafasfafa
dublin adfweasdfasffewwfdw
cork asfwfwdfwwfdwwe
wexford asfdadqwedwed

I would like all the rows relating to each area to transfer to a separate worksheet.
Any help greatly appreciated.

**jeffreybrown** · 01-21-2013, 02:55 PM

Hello & Welcome to the Forum,

This will require a macro and this should do the trick...

http://www.excelforum.com/tips-and-t...-criteria.html

Place in normal module

Highlight macro to copy >> Ctrl + C >> Open your workbook
Alt + F11 >> opens the Visual Basic Editor (VBE)
Ctrl + R >>opens the Project Explorer (if not already open on left side of screen)
Insert menu >> Module or Alt + I, M >> activates the Insert menu and inserts a Standard Module
Paste code >> Ctrl + V (right side of screen)
Alt + Q >> exits VBE and returns to Excel
Back in Excel >> Alt + F8 >> Macro Dialog Box >> Highlight macro >> Run

**new at this** · 01-21-2013, 04:13 PM

Thanks Jeff,
That works!, as I update the master sheet it doesn't automatically update the other sheets without re running the macro is it possible to have this automatic, or is it necessary to run the macro each time additional data is put on the master sheet?
Thanks

**jeffreybrown** · 01-21-2013, 06:05 PM

Okay this is a little different. You can use a worksheet change event to move rows to specific worksheets.

One of these two threads might work for you...

Option 1
Option 2