Macro

Hi guys I need some help with macros. In the attached file, the sheet named Front Page is the report I would like.

The input page is where the date would be pasted into. I have created sample sheets named Sample 1 and Sample 2 which have the formate of the data that will be uploaded.

I would be copying and pasting the data into the input page and would like the macro to fine the items from the Front Page in the Input data and paste as values only in the relevant columns.

Example:

If I was using Sample 1 data in the Input page, I would be finding Total Net interest Income and copying and pasting the values in cells A47:C47 into cells B8:D8 in the Front Page sheet and values of cells F47:H47 into cells H8:J8 in the Front Page worksheet.

I tried creating a macro but the only problem is that if the number of rows is different (like the 2 samples), the macros won’t work.

I would really appreciate if someone could help me out.

Thanks heaps.

Originally Posted by Carim

Hi,

Why don't you post your macro ... for a quick fix ...?

Hi Carim,

I have created a new post with the file and macro in it. The post name is: macro to work for variable number of rows

Your help will be highly appreciated.

Cheers!