Copy cells based on conditions in one workbook to another workbook

F

fLiPMoD£

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.

Many Thanks
Carl.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To copy Data from a row in one wrokbook and insert in a sheet of another workbook 0
Copy cells based on conditions to another workbook 0
Sharing workbooks limitations - Merged Cells 12
Insert full row from worksheer to another base on condition 1
How to create absolue path link to another workbook (Excel 2003) 1
Conditional Formatting with VBA 4
Average problem 1
deleting workbooks as i go 4

Top