***PLEASE HELP : ) *** I need to create a snap shot of daily data from sheet 1 to create a monthly table on sheet 2****

[JamesOck]

Sheet 1 data changes each day, however I need sheet 2 to record each individual day of the months figures for historical purposes.

Simple example provided below, Please let me know if this is clear.

Sheet 1 (Figure changes on daily basis) on Nov. 3 = $5.00

Sheet 2 (Monthly View )
Nov. 1 = $x.xx
Nov. 2= $xx.xxx
Nov. 3 = $5.00

Thanks.

 

[Andrew Fergus]

I'm guessing there is more to this job than your post suggests but I will bite anyway. I'm curious why you don't copy > paste special (values) from Sheet 1 to a new row in a table on Sheet 2? Is that what you currently do? Or is that not an option?

 

[JamesOck]

yes, this what I currently do, however I'd like to avoid the manual copy and paste function.

 

[My Aswer Is This]

I looked at your posting. But have no ideal what your attempting to do.
Would you please explain in detail what your wanting to do.

 

[JamesOck]

Its pretty simple really, but im looking for an automation so I dont have to manually copy and paste each day....

Sheet 1 data set changes each day. For simplicity this is a risk dollar amount.

I need sheet 2 to record each days risk dollar amount from sheet 1, so by end of month I can view every days risk.

let me know if this is clear. Thanks.