Macro which will filter and paste data to new worksheet

Hi,

I need some help with a VBA code as I have no experience with writing a macro.

I have an unsorted data sheet which I need to extract information from and with each data extract I need it to create and save a new workbook.
1. On the tab GL – Column A I have a branch code consisting of 3 digits. What I need is a macro which creates a new workbook splitting out each branch.

e.g. in the example supplied I would like 5 new worksheets created showing data for branch 181 on one work sheet, 182 on another, 183 on another etc etc

2. For each new worksheet am I able to define the worksheet name – ideally I would like the branch name e.g. “181”

3. Is there any way in which I can define the workbook name and location to save to (if it doesn’t exist I would like it created).

I know this is a big ask – if there is a similar workbook that exists that I can copy the logic that you know of please point me in the right direction.

Any help is appreciated.

Paul

Hi

Thank you Fotis for replying so quickly.

That is what I am trying to achieve but rather than create a new worksheet I would like it to create a new workbook - can the code be tweeked to do this?

Ideally I would like the files to be saved directly to here:
P:\Test\Finance\manacc\MAN_ACC\Test2\2014\Mth0214\Transactional Reports\Hygiene

If that path doesnt already exist then I would like it created.

Could the file names be automatically defined e.g. "Transactional Report and the branch number (from column A) and the Month (I can define this in the macro each month)

Hi,

Thanks for the link, I still need a bit of help please:

Currently the macro saves the file to the same desitnation as the orignal file:

Please Login or Register  to view this content.

Is there any way I can change this to:

P:\Test\Finance\manacc\MAN_ACC\Test2\2014\Mth0214\Transactional Reports\Hygiene

And then rather than that file name e.g. "182140318_090259" could I have:

"Transactional Report and the branch number (from column A or the tab name) and the Month (I can define this in the macro each month)

I dont know how to amend the code to do this.

Regards

Paul

Hi,

Thanks for the codes supplied here.

@ragulduy - I dont think this worked as it has not created new workbooks.

@Izandol - I think this may just be what I am after!! I will test it and report back (currently out of the office)