Copy Data to New Workbook based on two conditions

I

ikflash

New Member
Joined
Oct 15, 2009
Messages
32
Hi All,

I had a pretty good search around the net, I can find the ability to move to a new workbook based on one condition.

Great Example by Ron: http://www.rondebruin.nl/copy5_3.htm

However I am not experienced very well in VBA editing.

Can someone please assist by manipulating this code to allow for all data to be moved to a new workbook based on changes in columns A and M?

The Range of Data is Columns A - AD.

Or if you can advise of a source I have overlooked that would be much appreciated.

Thanks
Patrick
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

P
  • Solved
Filter and Delete Rows from dataset based on Two Criteria
2
Replies
10
Views
224
Joe4
Joe4
I
  • Question
Move multiple rows from one table to another using conditional trigger
Replies
2
Views
469
ItsNursinTime
I
K
  • Question
Help with VB Code to copy workbook
Replies
0
Views
157
kizzie37
K
T
  • Solved
Copy worksheet to new workbook without formulas or macro button
Replies
9
Views
556
Tgrundy09
T
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
231
Insurance Dave
I

Forum statistics

Threads
1,215,004
Messages
6,122,659
Members
449,091
Latest member
peppernaut

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top