I have a workbook where tab one updates four rows of data from Bloomberg-it
overwrites the same four rows every week. I have to copy and paste that
information manually every week into another tab to keep a running history of
the information. how can I get excel to paste values from one sheet to
another when the data points update to the most recent date weekly?

The dates change during these bloomberg updates. Is there is any way that
excel could copy and paste when a certain dates data is available? -but the
catch is, if we could do this how do we make sure the data stays put once
that date is overwritten?

Help!

On Dec 27, 9:04*am, Melanie wrote:
I have a workbook where tab one updates four rows of data from Bloomberg-it
overwrites the same four rows every week. *I have to copy and paste that
information manually every week into another tab to keep a running history of
the information. *how can I get excel to paste values from one sheet to
another when the data points update to the most recent date weekly? *

The dates change during these bloomberg updates. *Is there is any way that
excel could copy and paste when a certain dates data is available? -but the
catch is, if we could do this how do we make sure the data stays put once
that date is overwritten? *

Help!

Not sure how much I can help you, but I was curious as to what the
formula was in those 4 rows in the first tab drawing the current data.
Also, name the source it is pulling from. That might help as well.

I didnt create this spreadsheet becuase i dont really know how to pull data
from bloomberg yet but this is what it pulled most recently:

Date Range 11/12/2007 to 12/27/2007
GB2 Govt, Date and YLD_YTM_MID
GT5 Govt, Date and YLD_YTM_MID

i hope this makes sense! the spreadsheet populates percentages under the
YLD_YTM_MID column automatically and updates the date range to be the most
recent data

"Noob Jedi" wrote:

On Dec 27, 9:04 am, Melanie wrote:
I have a workbook where tab one updates four rows of data from Bloomberg-it
overwrites the same four rows every week. I have to copy and paste that
information manually every week into another tab to keep a running history of
the information. how can I get excel to paste values from one sheet to
another when the data points update to the most recent date weekly?

The dates change during these bloomberg updates. Is there is any way that
excel could copy and paste when a certain dates data is available? -but the
catch is, if we could do this how do we make sure the data stays put once
that date is overwritten?

Help!

Not sure how much I can help you, but I was curious as to what the
formula was in those 4 rows in the first tab drawing the current data.
Also, name the source it is pulling from. That might help as well.