Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a sheet for one year?
Is there some kind of coding that can be put onto a sheet or workbook that
will ignore data from a prior year? Here's the specific dilemma. I downloaded a General Ledger from the Microsoft website through exel, new, microsoft office online, ledger, generalledger1. I work on a fiscal budget so, naturally, I have 2009 data and 2010 data on the same sheet. The sheet has the following formula in it for a 2009 entry: =SUMIF(_6652[Constructed Key Field],"="&(TEXT(Expenses[[#Headers],[Jul-09]],"mmm-yy")),_6652[Amount of Check]) The formula for a typical 2010 entry is: =SUMIF(_6851[Constructed Key Field],"="&(TEXT(Expenses[[#Headers],[Feb-10]],"mmm-yy")),_6851[Amount of Check]) In 2009, all my information from 2009 was visible. Now that it's 2010, my 2009 data has "disappeared" but the 2010 is visible. It's a mystery. I can't figure this out. Thank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to know formula to make expire in a year. | Excel Worksheet Functions | |||
Make Worksheets Given a Certain YEAR | Excel Discussion (Misc queries) | |||
how do i calculate what i make in a year into an hour? | Excel Worksheet Functions | |||
how to make a rolling calender where hours roll off after a year | Excel Discussion (Misc queries) | |||
How would I make a calendar template in Excel for the year 2006?? | Excel Worksheet Functions |