We're looking for an excel macro expert who is available IMMEDIATELY and be available FULL-TIME over the next couple of days to help with a project where we have a series of spreadsheets all with the same structure. In each worksheet there is a series of records pertaining to traffic/vehicle observations passing through a series of locations along a route. The information recorded is Type of vehichle, time, registration numbers and location. Initially we need some extra calculated columns to be created automatically based on the original data e.g. Period (taken from time supplied). These 'recoded' spreadsheets will then form the basis where analysis of journey times between locations can take place based on selected parameters (e.g. period, van/bus, day)
We would like to be able to enter two location points from the route e.g. 1 and 5 and the macro should ten list all the vehicles (registration numbers) along with the time recorded/observed in locations 1 and 5 along with the difference in the times.
25 pekerja bebas membida secara purata $270 untuk pekerjaan ini
Hi! I've done many VBA apps, and I use an Excel sheet full of macros for my own scheduling. I'm ready to start now, and will work on this until we're finished.