Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cells based on conditions in one workbook to another workbook | Excel Discussion (Misc queries) | |||
I CAN'T SELECT THE CELLS IN A WORKBOOK I WANT TO COPY | Excel Discussion (Misc queries) | |||
Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
Should be able to name Excel sheets based on cells in workbook | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |