Truthfully I could not get your code to work, but it did open my eyes to a
different way of working through my problem. I was originally hoping for a
macro that would function within an already open document and using
activecell parameters so that the macro could be used on files where the
I have done a little work on my own and have a portion of it done. I can
now automatically perform a vlookup against the parts listing by selecting
the column the parts are located in and starting my macro. The code I used
to do this is as follows:
Selection.Insert Shift:=xlToRight,
Please check hope this is what you are looking for:
Option Explicit
Sub RemoveData()
Dim wbkFile As Workbook
Dim vararrDataToRemove()As Variant
Dim lngLoop As Long
Dim rngData As
I sample of the file I receive is as follows:
25727861 GM DLT 1
20130716 17091432 GM NS 8
20121227 12527740 GM NS 8
20121221 10328906 GM NS 0
89018306 GM NS 12
12617309 GM RB 44
12365265 GM NS 10
20121026 12588318 GM RB 18
20120301 16631629 GM NS 11
the comparing file is
Dear svenyarl,
Pls share a worksheet with us.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Aug 21, 2013 at 8:13 PM, sveny...@gmail.com wrote:
I sample of the file I receive is as follows:
25727861 GM DLT 1
I am open to suggestions on how best to go about this and am aware this
might be a fairly simple request but I either lack the expertise or the
correct vernacular to find the answer myself.
On a daily basis I receive files of approximately 56000 rows of part
numbers along with each parts