Looking for a VB/Macro in Excel 2010 expert. Small pay like $75, to write the script. Pretty much a piece of web based software spits out a CSV file that needs to be re-formatted as well as some minor calculations happen. The contents of the file changes every week, and the script will need to accomodate this. When I say contents, I don't mean the what the columns represent, rather 5 rows of info that need to be added up and consolidated in week one, then in week 2 there are 10 rows instead, week 3 there might be 2, etc. The data is rows of time entries for a given project, sorted by all entries for a given client, broken up by the end user that actually entered time and then by the day the work was done. So an example woudl be 5 rows representing 5 days.
End result should add all those rows into a single value for that user and put it into a column for that user. I have examples of the data spit out by the system (start), and what my acounting dept is currently cutting and pasting right now to make it look how our boss wants it(end product). If you are interested, email me at edward.tsai-at-inlandpremier.com.