Here is the template I am trying to modify.
http://office.microsoft.com/en-us/te...CT101441121033

I need a formula to check the Date Posted (Column B), Amount (Column E), and
the GL Code (a range of 1000 in Column A, this is what I'll be changing.
Instead of just 1000, 2000, ect. I will have 1100,1200,2000,2400, ect. so I
need it to check range 1000-1999,2000-2999, with no limit) on the worksheet
named 'itemized expenses' and put the information on the 'Monthly Summary'
worksheet. I would like the example for Column C6 of Monthly Summary (January
of the GL code 1000)

Basically I want excel to see a code say 1200 and put it under the 1000 GL
code on €˜Monthly Expenses worksheet, and when it sees 2400, I want it under
2000. When it sees 10200, I want it under the 10000 code. I know it's a lot,
but if there is any way this can be done, it will greatly be appreciated.