I have a few questions, and help with any or all would be greatly appreciated.
- My first problem is that my program is time dependent, so in VBA I need to start by re-setting the time on the computer to a specific time. I was told that I could synchronize the time by referencing a website that has the current time. I have a site, but I'm lost on what code would enable me to do this.
- My second problem is that I have two sheets, each with different data on the same topic, and in a third sheet, the data from the two prior sheets will match one column of data, compiling them into this third new one. Is there a way to not only match the data absolutely, but also partly, such as four characters out of five? I'm thinking that the Match and VLookup formulas would be best, or even if I made the columns into ranges and did a simple If statment: If columnAsheet1(i) = columnBsheet2(i) then
carry out theses calcs... But then that doesn't account for the not absolute case.
Thank you very much,
Cami
Bookmarks