Macro to copy New Data into cell Excel

[pattyjean]

I have a spreadsheet that needs to get updated daily. I enter the new data into a row and then copy and paste the same data into the top of the sheet so we can look at it at a glance and the details under it.

The data is organized like this
Day - HeadcountTtl - HeadcountCampus1-HeadcountCampus2
Todaysdata 3/23 - 120 -35 - 85
3/20 - 100- 25 - 75
3/21 - 105- 30 - 75
3/22 - 110 -30 - 80
3/23 - 120 -35 - 85

Each day new data is added.
Any advise will be greatly appreciated.

 

[SkipVought]

Hi,

This can be easily done using either a PivotTable or a Query (faq68-5829).

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[pattyjean]

I want the top row to be updated with the new date's figures on the same worksheet. Maybe I am not asking the question correctly?

I want to update one line of data (by date) and make it populate into the top row for easy viewing.

 

[SkipVought]

I understand perfectly.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Gavona]

Another approach:

In A1
=max(A2:A65535)
In B1
=vlookup($A1,$A$2:$D$65535,2,0)
In C1
=vlookup($A1,$A$2:$D$65535,3,0)

Though you would be better using a named range that automatically extends as rows are added.
faq68-1331


Gavin