A Formula to Update Information Daily Between Two Sheets

**artiststevens** · 10-05-2010, 12:22 AM

I need a formula that would copy and paste between two sheets. The first sheet is the Master Sheet and the second sheet is the Temporary Sheet. I want to be able to automatically paste the current days data from the Master Sheet into the Temporary Sheet and have it update when ever a new row is filled in on the Master Sheet, so the Temporary Sheet, which only consist of a single row, would only roll over when the next days information was entered into the next blank row of the Master Sheet. Any help with this would be greatly appreciated. Below and attached is what I have thus far but I keep receiving a N/A error.

Master_Sheet
A B C D
1 Date Data1 Data2 Data3
2 9/29/2010 3 5 7
3 9/30/2010 8 1 9
4 10/1/2010 5 3 3
5 10/2/2010 7 5 8
6 10/3/2010 10 1 2
7 10/4/2010 10 3 7

Temporary_Sheet
A B C D
1 Date Data1 Data2 Data3
2 10/4/2010 10 3 7

Please Login or Register  to view this content.

**JBeaucaire** · 10-05-2010, 04:19 AM

On the master sheet, take the spaces out that are hidden in front of your dates.

**artiststevens** · 10-05-2010, 05:48 AM

JBeaucaire,

Thanks for the help. I did as you suggested but in on the Temporary_Sheet the "A2" cell was filled with the number "40456". Any suggestions? Thanks again.

**artiststevens** · 10-05-2010, 05:57 AM

Okay, when I change the format to date I get the current date but I don't get the Data numbers.

**artiststevens** · 10-05-2010, 06:26 AM

Thanks Again JBeaucaire! I fooled around with the formula and I got it to work. I pasted the formula in each column and made a couple of changes and it worked. Thanks Again! SOLVED!