Hi,
Thanks for the macro.
What I meant was that code 1 and code 2 uniquely defines a row so if
there is data item in the .csv file than it the macro should insert
the row in from of the code1 (column A) and code 2 (column B). Im my
spreadsheet I have 12 monthly tabs which all look exactly the s
I think someone is using my name in vain - unless there are two Dave's in the
world - and I don't know how that could be...
Dave.
Date: Thu, 17 Feb 2011 09:15:24 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Import .csv & match records
To: excel-macros@go
Piece of cake...
I can probably write it in 20 minutes.
=
Option Explicit
Dim Col_Array_Code1, Col_Array_Code2, Col_Array_YR, Col_Array_MM
Dim Col_Array_CoName, Col_Array_Dept, Col_Array_Qty, Col_Array_Amt
Dim Code1, Code2, YR,