Custom copy from one workbook to another

Craig1

Active Member
Joined
Jun 11, 2009
Messages
322
Hi All,

I have a couple of issues when transferring data from one workbook to another. I have searched the forum to try and resolve the issues but nothing quite matches up.

I run a macro through a command button to transfer the info and the appropriate info transfers over into my workbook without any issues.
The issues I have are:-

1, when all the info is in my workbook I find that some of the unfinished orders have transferred over, so I end up with 2 or more of the same order. I would like some VBA or an addition to my transfer macro to check the order numbers in column B and if it finds any duplicates delete the whole row so I still end up with one order.

2, the second issue is I need to insert a formula in column K and column L when some text appears in column J. I used the function button and inserted the formulas and copied them down to the end of the worksheet but when the auto filter is working to show all data it takes a very long time to check all the way to the bottom. So basically I need VBA to insert the formulas into K and L based on when the text appears in J.
When the info is brought over it comes across in blocks of rows in excess of 50 each time.
The formulas I need inserting are:-
K - =MID($H9,6,1)
L - =IF($K9="B","Bead",IF($K9="L","LDP",IF($K9="G","Powder",FALSE)))

Any help would be greatly appreciated.

Craig.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

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