Hello,
Trying to create a macro to carry out certain functions from a csv file. First step is to create a new worksheet (Sheet1) which is labelled as merged.
1) Use only a certain set of Headers from the csv file , currently doing this using WorkSheet.Function.Match
2) Copy two of the headers from the csv file to the new worksheet (merged), this is currently doable.
3) remove duplicates based on Column 2 (the name is duplicated). This is currently doable.
Problems:
1) I need the other selected headers from WorkSheet.Function.Match in the new worksheet
2) To do Sumif function in the new worksheet(merged) using data from the csv file, I have to do sumif for all the Match function selected headers.
Any help is greatly appreciated.
Thank you,
thekid
Please Login or Register to view this content.
Bookmarks