Hi,

A client of mine sends me a zip file with a batch of about 10 ish spreadsheets, each of which is a statement of positions with 0 - 15 rows of data.

What I need to do is write a macro that will open each SS in turn, and effectively test to see if there is anything in cell B28. If there is nothing in cell B28 then just close the SS.

If there is something in Cell B28, then continue onto Cell B29, then B30 etc until it comes across no value, then copy the range B28 - BX along to Column AF. Once it has highlighted this range, copy this to the next blank row of SS HSBC_Statement.xls

So what I am doing is pulling out from each statement populated rows of data below Cell B27 to Row X in the range that goes up to Column AF.

Can this be done?

Can anyone give me some guidance?

Many thanks,

B.