VBA Browse a File and Get Certain Data

[unknownymous]

Hi Team,

So I usually work on a particular task where i need to collate specific data. I need to produce a sheet where it has 5 columns in it namely ID, Name, Note, Source and KEY columns. I was thinking of using Getopen file were it will openthe source sheet which is normally in xls or xlsb format.

See below Source Data Format:

ID	Name	Holdings	Y/N	Note	Source
001	Ann	23000	N	Follow-up	Online
002	Ben	10000	Y		Paper
003	Sue	15000	N	Pending
004	Chris	21000	Y		Fax
005	Amy	9000	Y	Done
006	Shawn	5336	N
007	Sel	1030	Y		Online

<tbody>
</tbody>

Expected Output:
Get the necessary columns and as long as the excel has value on both Note or Source (vice versa), the KEY column will indicate as YES

ID	Name	Note	Source	KEY
001	Ann	Follow-up	Online	Y
002	Ben		Paper	Y
003	Sue	Pending		Y
004	Chris		Fax	Y
005	Amy	Done		Y
007	Sel		Online	Y

<tbody>
</tbody>

Any help will be much appreciated. Thank you!