Good Afternoon Folks,
I am looking for assistance with a Macro(?) to replace values in a large spreadsheet based on a lookup table.
Story:
I have a maintenance programme that has all the assets down the left hand column, the fields to the right are intervals, each field represents a week in the year. Some assets have one visit and others may have more than one. Each of the visits are populated in these fields with a 3M, 6M, 12M (M=Monthly). I am looking at some assistance on how to create something that will cycle like a typewriter between these fields and replace the the 3m, 6M, 12M with a number which is essentially the duration of the maintenance visit. As the assets have different durations or frequencies I have built a table that covers this off.
What I have:
An example to share
A look up table
I hope someone can a)decipher what i am looking for and b) help to create a solution. I am going to need to use this often and the amount of rows in the plan will vary.
Thank you for your time.
Yours,
GC
Bookmarks