Copy cells based on conditions in one workbook to another workbook
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. |
All times are GMT +1. The time now is 08:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com