I have my code written to copy the necessary information from another workbook -
(I have an example of that data in the attachment on Sheet2.
After I copy this data, I massage it a bit, but I am having problems writing additional code to find in range("Z33:AF38") any "0 -" and replace with a "12 -" then find any cells with "- 0" and change to "- 12".
I need to look in values, without matching the entire cell contents. I need to find a way for it to not replace a cell with "10 -" (a double digit integer) otherwise my data wil be incorrect.
I have a routine called "formatschedule" - I had to type it all out since I was stuck on the best way to set my varibles to copy range("Z13:AM24") to range ("Z33:AF38") with the modification of hours and minutes. If you could educate me on how to get it to be reduced down, it will help me + plus, if I have to make any changes in the future I do not have to modify so much code.
I am attaching a copy of a workbook with my sheets and code. All code is in Module 1. I think this will help in showing what I am trying to do.
I would appreciate any assistance on these 2 issues.