Hi,

I hope someone could help me on this. I need a macro that will enable user
to do the following

1. load sheet3("Template") in workbook1
2. copy and save value and format of Template as new workbook say wb2
3. opens wb3 and checks for each cell in column A2 to A"lastrow" that has
value greater than 2 and count them
4. insert the number of counted rows in Sheets("Template"), after eg row 4
5. now copy cell(i,2), cell(i,5), cell(i,7), cell(i,12 to 15) into the
inserted rows in Sheets(Template)

any help will be appreciated.

i can do steps 1 and 2. have used Case to find those cells in column a=2
but struggling in counting them. i get stuck on steps 3 and 4.

Many Thanks
Carl.