Macro needed to create new worksheets and feed through specific data

Hi,

I have attached 2 spreadsheets - Test1 & Test2 to assist with my problem.

Test1 is where I currently hold information about accounts. However, I have come across the problem if new accounts are created.

Is there a macro I can use that will extract the data from Test2 and create a new worksheet in Test1 containg all the inforamtion I need? I will then also need the new worksheet to be renamed after 'Code_2'.

In the future there is potential for several dozen new accounts that will needed to be added to Test1 so this macro can't be specific for just the example I have illustrated in Test2.

Any help would be much appreciated.

Thanks

Hi Arlette - that's correct.

Hi Arlette,

Have you had time to review my problem above?

Thanks,

Eoghan

Hi Arlette,

Thanks very much for taking your time to do that. The data from Columns F, G & H from Test2 are appearing in Row 11 in Test1 - it should appear in Row 15. It also seems as though it is pulling through the data for Asset_1 and not Asset_2 as well. Is it possible to achieve this? Thanks

Hi Arlette,

Thanks for your quick response. I've copied the headers into row 14 of sheet 1 but the 2nd issue hasnt been solved - asset_1 is the only one pulling through.

Excellent Arlette - thanks for that!

Hello,

Is it possible for you attach the workbook with the working macros?

Thank you

Please find attached

Hello,

There arn't any macros in them..

I think you need to add them yourself. Do you know how to do this?

Thank you Arlette

Hello Arlette,

I did exactly that and it is written ''subscript out of range'' whwen i run the macro