Here trade_summary.xls downloaded daily through online source.
Then the Stock Code & Price copy to the Update.xlsx
Name updated through vlookup function from another sheet
Other columns do not need but have to be there to keep inline with accountancy software requirement.
Here what I want is save rows with "Last Price" > 0 & import them as .csv file.
Bookmarks