Re: $$Excel-Macros$$ Import .csv & match records

2011-02-18 Thread Dave
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

RE: $$Excel-Macros$$ Import .csv & match records

2011-02-17 Thread Dave Bonallack
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

Re: $$Excel-Macros$$ Import .csv & match records

2011-02-17 Thread Paul Schreiner
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,