Hello,

I receive a report that gives me the depreciation amount for the rest of the year based on dates. Each month it changes to how many months are left in the year.

I want to rearrange this data dump into an organized chart that shows each month depreciation by account.

Example:

Sheet 1:
Code Date Depreciation Amt
A 1-July 2000
A 1-Aug 2000
A 1-Sep 2000
A 1-Oct 2000
A 1-Nov 2000
A 1-Dec 2000

B 1-July 1000
B 1-Aug 1000
B 1-Sep 1000
B 1-Oct 1000
B 1-Nov 1000
B 1-Dec 1000


Sheet 2:
Jan Feb Ma Apr May Jun Jul Aug Sep Oct Nov Dec Total
A - - - - - - 2000 2000 2000 2000 2000 2000 12,000
B - - - - - - 1000 1000 1000 1000 1000 1000 6,000




Thank you