Can someone help me with creating a summary worksheet that extracts the data
from a secondary daily input worksheet? On the daily input worksheet, there
is a column for every day of the month, 1 thru 31. Eack day we input the
number of rooms our hotel sells. Ex.) Column C is day 1, a row under it is a
manual input cell for rooms sold that day (50). So from left to right each
day has an input of the rooms sold. What I'm trying to do is create a
"summary" worksheet that will automatically pull the newest days data. I
thought of If statements, but I'd have a string a mile long and I'm not
knowledgable enough in excel to even begin this. Should state that there are
about a dozen stats I wish to do the same thing with, all of the info is on
the data worksheet, but I need this summary information to cycle forward to
the next days amounts.