Please refer above thread I posted few days back. I tested answers received from various excel experts, but I could not get desired results. One recent answer from igold I tested its working partly.
.Thank you igold.As per your message Is this what you are looking for. This code should be run from the TKR.xlsx workbook.in your new code referring (Find Date) macro ,I had done some changes > Changed Str folder ,Str file names> . I tested your code. My first requirement is not accomplishing. Your code is not checking A2 date(in my string file named “niftycsv” with Column B values of wbT (w/b DateCheck). Second part of my requirement is executing partly, total file is copying and pasting in last row of my wbT.Second part of your code is working > it is copying total sheet of “niftycsv”sheet data > but I don’t need header row data > only data below of header row has to be copied and pasted in wbT. Please change your code as per my requirement. 1.first check my niftycsv range(“A2”) date exists in column B of wbT.> if exists give message “Date already Exists” 2.If date does not exists in ColB of wbT then > copy niftycsv data excluding header row (from row2 to last row) and paste them in last row of wbT.
.Thank you igold.As per your message Is this what you are looking for. This code should be run from the TKR.xlsx workbook.in your new code referring (Find Date) macro ,I had done some changes > Changed Str folder ,Str file names> . I tested your code. My first requirement is not accomplishing. Your code is not checking A2 date(in my string file named “niftycsv” with Column B values of wbT (w/b DateCheck). Second part of my requirement is executing partly, total file is copying and pasting in last row of my wbT.Second part of your code is working > it is copying total sheet of “niftycsv”sheet data > but I don’t need header row data > only data below of header row has to be copied and pasted in wbT. Please change your code as per my requirement. 1.first check my niftycsv range(“A2”) date exists in column B of wbT.> if exists give message “Date already Exists” 2.If date does not exists in ColB of wbT then > copy niftycsv data excluding header row (from row2 to last row) and paste them in last row of wbT.
