copying data extact match vba code

[keilah]

Hi

I need to copy data from one worlsheet in a workbook 1 to another workbook 2 and multiple sheets in that work book, so the data from workbook 1 - work sheet say "fees", is matched exact match and placed into workbook 2, worksheet dec04, jan05 etc.......feb07.

So if HSBC1-8 is in workbook1, worksheet "fees", the net amount say from the range column E, row E6;E264 this is copy to workbook 2, and add to each worksheet from dec04 to feb07 that has HSBC1-8, into each worksheet column c.

HSBC1-8 data well be located in column b (fixed), but not in order.......HSBC1-8 can be in any row from B6:B264.

thanks.....

[austenr]

Can we have a sample workbook please? Thanks

[keilah]

ok i'll post the workbook later on.......once i get the data together. thanks very much for your initial feedback.

[keilah]

Ok here is the first work book

Look at the first work sheet "fees"... i know that there are empty rows in with no data in column E. I already have a macro that will delete all empty rows.

After this step has been completed

with the finished data from column b and the fees column e. I need to match the portfolios in colum b (exact match )and its corressponding fee amount and paste this via a macro in work book 2. (which i will attache seperately).

In each work sheet from dec 04 to date and if a new month is added the macro updates to paste the data as above into the following month when the time arrives to compile the work sheet for the next month.

See next note for workbook 2

[keilah]

Hi this is the second work book

i have already copied the data from the first work book, to show it as an example.

thanks

[austenr]

OK I'll take a look and see what I can do. Someone might get to it before me though.

[keilah]

hi mate once again thanks for your feedback and help