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


--
cliodne
------------------------------------------------------------------------
cliodne's Profile: http://www.excelforum.com/member.php...o&userid=28774
View this thread: http://www.excelforum.com/showthread...hreadid=484627