Creating A Macro to export data to another workbook!

[yorkie287]

I have a list of approximately 200 entries made up of the customer details charges, weight of products etc,

e.g.

ticket no>customer name>>product weight> rebate >>>source

122 >>>>customer A >>>>>30000kg >>>>>>£500 >>>>customer a yard
123>>>> customer B >>>>>12000kg >>>>>>>£0 >>>>>>outside yard
124>>>> customer C >>>>>12560kg >>>>>>£250>>>>> customer c yard
125>>>> customer B >>>>>13444kg>>> >>>>£300>>>>> outside yard
126>>>> customer C >>>>>16252kg>>> >>>£100>>>>> customer c yard
127>>>> Customer A >>>>>15452kg >>>>>>£50 >>>>>>customer a yard

this is just an example of the list i have infront of me, i would like to create a macro that collects all customer A data together, all customer B data together, and all customer C data together and then exports them either to indiviual workbooks or just to new sheets within the same workbook,

thanks for taking time to look at this
all feedback/help is welcomed
oli

 

[yorkie287]

finally how do i save the macro so i can apply it to other workbooks?

 

[VoG]

You can save it in your Personal workbook http://www.rondebruin.nl/personal.htm

 

[darkstar911]

You can save it in your Personal workbook http://www.rondebruin.nl/personal.htm

Hi

This macro was incredibly useful for me but I am wondering that if the elements in Col A are split between tabs, can they also bring the elements in Col B and C with them?

Thanks