If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I have a workbook with 2 worksheets, Reports and AR.
On worksheet AR I have Formated a table with headings
NAME JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NAV DEC YTD
On the reports page I want to display users names, currect month and year to date data.
Thanks in advance for ne help.
Last edited by jenksonu; 07-01-2009 at 05:16 PM.
Reason: Attach sample
I posted an edited version of your workbook.
The Reports page has a cell for entering the current month.
The Units by Mo column has formulas that return appropriate values from the AR sheet.
Thanks for the help. That's slick. Is there a way to just have Reports sheet, Units by Mo just automatily show current mo. sales without entering anything?
Are there rules for when the month changes? Is there a cell that contains a reference date? Otherwise, the formula would be referencing the current date and using that month. What's your preference?