Hi guys,
This is slightly urgent and i was given it Friday to complete for the weekend - ..
I need a VBA based process where i copy a list of semi formatted text into workbook1 [manual process]. The text is organised as a simple series of line data. i.e. a screen copy and paste from data service
I then want to be able to assign the process to a button to run the scan / extract / convert / add to archive
i.e.
RAW data:
PORT**************** IFO - 380 CST IFO - 180 CST MDO MGO
Fujairah************ 591.50-592.50 603.50-604.50 984.00-985.00 989.00-990.00
There are numerous 'Ports' in the text list but i only need to extract about 12 plus their price data
Based on a small table in worksheet2 [PortName, ProductID, price1, price2 price3] defining what price elements i want from the Port - i want to cycle through [ ColumnA 1-200] workbook1 searching for the content in the table in worksheet2. Always the "PortName" is the first part of the line string so search using left() function
It will cycle through the worksheet1 line data for each Portname entry in the table found in worksheet2
Once it locates the line [identified by the "PortName", we then need to check what data [as identified by a "1" [a flag it is selected] next to the Portname in worksheet2] and extract and convert it from text to price, and store in worksheet3 [Report]
In effect, we are trying to extract only Port data for the key ports used - and the product [IFO-380 or IFO-180]
Price History:
Finally - for a given result - we want to store the daily data in it's own worksheet - so we have a daily price history worksheet for each port + product [each port has it's own worksheet with Date, MIN-MAX data for each product [380, 180, MGO]
Given enough time I can do this but it will take me most of the weekend to re-educate myself in VBA so appreciate anyone who can help me work through this.
I can email the xls to work with but copyright means i cannot publish here.
help! :-)
Thx
Bookmarks