I have 3 workbooks that come to me everyday from different people, each workbook has only on worksheet. 1 worksheet is called AHT, 1 is called effective use, and the other is called daily statistics. I need to copy certain values in the effective use and AHT worksheets to the daily statistics worksheet. The AHT worksheets has about 20 rows and the effective use has about 600 rows. The common cell/value column between these 2 worksheets is called the empid. What I need is to create, is a macro that will sequential compare the empid's between the 2 worksheets (AHT and effective use), if they match they copy certain cells from AHT and effective use to daily statistics. If they don't match, it then needs to advance to the next cell in effective use compare it with AHT, match? then copy, don't match? then advance to the next cell in effective use.
continue the comparison thru all 600 cells in effective use, once done then advance to the next empid in AHT and then repeat the process. If you could point me in the right direction I would certainly appreciate it.
unfortunately i tried to install colo's utility into my workbook but I get the following error message:"could not load an object because it is not available on this machine".
Thanks in advance
continue the comparison thru all 600 cells in effective use, once done then advance to the next empid in AHT and then repeat the process. If you could point me in the right direction I would certainly appreciate it.
unfortunately i tried to install colo's utility into my workbook but I get the following error message:"could not load an object because it is not available on this machine".
Thanks in advance