Updating data from one workbook to another
 

I have one workbook that copies information to another workbook. What
was wondering is: how can I update the already copied information i
needed?

Would I need a userform?

I'm just not sure how to get myself started.

Thank

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

Updating data from one workbook to another
 

There are 2 simply ways I can think of without knowing what the copied to
workbook does.

1. Write a macro that saves the current file off over the top of the other
workbook.

2. If the other workbook contains formulas etc... why not simply write a
macro to copy the data into the other workbook?

HTH

"tanyhart" wrote:


I have one workbook that copies information to another workbook. What I
was wondering is: how can I update the already copied information if
needed?

Would I need a userform?

I'm just not sure how to get myself started.

Thanks


--
tanyhart
------------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148
View this thread: http://www.excelforum.com/showthread...hreadid=556511

Updating data from one workbook to another
 

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