looking to import data for a 12 month period. 100 rows of information per day.
pre recorded basic macro for the date of 16th February 2013 done. file to be supplied. succesfully pulls in data required.
but need to create a loop from user entered parameters in the main excel worksheet ( 4 or 5 ).
eg Excel cell a1 = start date 2012/01/01, b1 = end date 2013/02/16 , c1 = event code SR , d1 = destination range, e1 = other?
so as to extract data over a 12 month period say.
Only 1 error trap required ..... eg on a particular day there may not be a sr event. this date needs to be recorded.
Fixed price easily determined as extended project is a byproduct of already working macro for 1 day. data cleansing / manipulation not required inside current worksheet.