Hello from Steved
Excel Find old Value and replace with new Value.
The Value to be replaced will always be in Col A
The Value could be in any one off 85 sub directories Files in 3 Directories.
The Directories are named Mon-Fri, Sat, Sun.
The value in A column is numeric ie 2356
This how the Old value is to be found.
Lets say that 2356 is the old value and the new value is 7457.
This is how I want to go about it please.
The below is for Outward trips
I will type in 4 values 2356, O, 267, and 8.00 which are in 4 different cells all in the same Row, Once found then change the old value from 2356 to 7457.
The below is for Inward trips
I will type in 4 values 2356, 8.00, 267, and I which are in 4 different cells all in the same Row, Once found then change the old value from 4897 to 3576.
The file has 2 Directions I = Inwards, O=Outwards
Every File has a Row Heading. Which is hidden
2356, The Heading is Duty No
O, The Heading is Outward Trip and I for Inward Trip
267, The Heading is Route
8.00 The Heading is Time
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Microsoft Excel spreadsheet.