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.
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.