VBA Browse a File and Get Certain Data

unknownymous

Board Regular
Joined
Sep 19, 2017
Messages
175
Office Version
2016
Platform
Windows
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:

IDNameHoldingsY/NNoteSource
001Ann23000NFollow-upOnline
002Ben10000YPaper
003Sue15000NPending
004Chris21000YFax
005Amy9000YDone
006Shawn5336N
007Sel1030YOnline

<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

IDNameNoteSourceKEY
001AnnFollow-upOnlineY
002BenPaperY
003SuePendingY
004ChrisFaxY
005AmyDoneY
007SelOnlineY

<tbody>
</tbody>


Any help will be much appreciated. Thank you!
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,095,247
Messages
5,443,326
Members
405,227
Latest member
Ankit Jain

This Week's Hot Topics

Top