Need changing data from one sheet stored in another.... Please help!

[vcastro458]

I'm almost sure, this is the correct forum to post this question, I'm very sorry if I'm wrong about that.

I need to enter data on ‘Staffing Summary’ tab and have it show on the ‘Staffing Summary Historical’ tab. The data from ‘Staffing Summary’ tab changes every week.
I’d like, if possible, to see newest entry first on the ‘Staffing Summary Historical tab’ and the “Week ending date” on each row should be the same as the D1 on the ‘Staffing Summary’ tab.
Excel stresses me, because I know what result I want, but no idea where to go make it happen.
Any suggestion would be helpful.
Thank you in advance.

V.

[AlphaFrog]

Please Login or Register  to view this content.

[vcastro458]

Thank you for your help. I'm thinking of doing something different with the sheet. I appreciate the time you put into it though.