What I have is one workbook where the user creates estimates for jobs
this is then saved as the project name. In this workbook I have
macro that will copy selected data (project name, project number, du
date, date received, estimator) and enter it on the next blank line i
another workbook (named Tracking Sheet).

What I would like to do is update the data that had already bee
copied.

So, if the user goes back into the file at a later date and enter
information into another cell for a date that the estimate was sen
back to them, they can hit a button and this information is updated fo
the project that was already copied to the Tracking sheet.

Does this make sense? If I could send the sample workbooks, perhaps i
would be easier to understand

--
tanyhar
-----------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...fo&userid=3514
View this thread: http://www.excelforum.com/showthread.php?threadid=55651