Copy cells based on conditions in one workbook to another workbook

fLiPMoD£

Guest

Posts: n/a

1st Aug 2007

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.

« permission | Date error message (VBA) »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy cells based on conditions to another workbook	fLiPMoD£	Microsoft Excel Discussion	0	2nd Aug 2007 12:31 AM
Copy cells based on conditions to another workbook	fLiPMoD£	Microsoft Excel Programming	0	2nd Aug 2007 12:31 AM
Copy cells based on conditions in one workbook to another workbook	fLiPMoD£	Microsoft Excel Worksheet Functions	0	1st Aug 2007 07:43 PM
Copy cells based on conditions in one workbook to another workbook	fLiPMoD£	Microsoft Excel Discussion	0	1st Aug 2007 07:43 PM
Copy cells based on conditions in one workbook to another workbook	fLiPMoD£	Microsoft Excel Misc	0	1st Aug 2007 07:43 PM