Showing a copy of data based on dated entries.

**avidcat** · 09-30-2010, 09:57 AM

Attached is an example I am working on.

Basically I will have a data entry sheet where we keep inputing new entries by date.

On the top of the sheet I want the most current data by date to be populated.

So as we enter new data the most current entry will show a copy on top of the page.

I appreciate any help.

Thanks,
Nick

**Charlie_Howell** · 09-30-2010, 10:53 AM

I'm not quite sure what you ae looking for but I did come up with this work-around

**mlopardo** · 09-30-2010, 10:54 AM

Looked at your sheet and I'am not understanding excalty what you want to do. Is date current date?
Do want to just copy from a given cell?

**avidcat** · 10-01-2010, 04:13 AM

Basically we are going to keep having new entries. The dates will be entered as we go.

We will skip dates that we have no entries for a given date, so it might go from 9/5/2010 to 9/8/2010.

So basically we would need a formula that will search column B for the most recent date and populate the data to the right of that date in rows 3 through 10.

I attached a new sample.

I appreciate any help on this.

Thanks,
Nick