Search results for query: *

Morning, Skid, The snow on the road in Vancouver took me 70 minutes to arrive at office this morning, I just tried it by your method, it is perfect. I really need to read some book to study VBA or basic formula for Excel later. this will definitely help me to better understand the answer from...

@cmeagan656, Yes, I am working in Richmond but living in Burnaby, I guess you were living in Delta or NewWest. Happy New years,

Hi,Skid, I had got the attach file from the email, that is exactly what I want. Please forgive my unclear request and thanks for the time you spent for me. Per your reply, you said you had changed Macro to UDF. 1. May I know if I could copy this function to make it working at another...

Skid, I will leave office now, and thank your for your help to my question. Have a good weekend. Scott

Hi,Skid, "Are you stating that additional note is a GENERAL definition, that does not connote the same specificity as the items in the Val list?" A: Yes, You are correct. "Did you desing and enter the data into this workbook? Do you have control over the content?" A: 1).Yes, I designed...

Hi,Skid, I think it is my fault that I still didn't say my request clearly. example: Task 2.Lubricate axle joint.Interval: 3000 Hours.Threshold note:7000 KM. Based on basic "task description"(Lubricate axle joint) "Additional note" in this example is "Interval: 3000 Hours.Threshold note:7000...

Hi, Skid, "additional note" in my example means the task only has the description for itself, there is no other specified requirement. Task 3 is example, it doesn't have "inerval note","threshold note" or other knid of "note". I am doing the test by your method now. thanks, scott

Happy New Year, Could you please modify the code from Dave for me, I am not so smart to understand what you are saying. I did make several times of try to replace the key word inside but it doesn’t work. I made excel spreadsheet but I can't get it directly uploaded to this server...

Hi, here is my continued question, could you please help again. A1: (Original) Visual inspection of tire. Interval: daily A2: (Original) Lubricate axle joint.Interval: 3000 Hours. Threshold note:7000 KM I want to: (note: * = line break) --Insert 2 lines (line break) before “Interval”...

Thanks you so much, DaveInIowa and SkipVought, the method from both of you work great ! For the method provided by SkipVought, I don't quite understand the meaning of number at left side of ")&",but once I made a try to change it,I got the secret. Acutually, I am not a expert to use formula...

Hi, I am using Excel 2003 at office, are there any experts to teach me how to use Marco or VBA to automatically insert line before and after designated word in each cell under the same column. Example. Under the column A, there are Cell A1 to A100, each cell has the same word of “Interval”...