C
cp1cp2
Yes, I posted this in the microsoft.public.excel group, but I haven't
heard anything in over a month; so I thought I'd try here.
****
I have a year-to-date accounting report I run every month, for multiple
departments, which I copy the month-to-date detail out of and then
paste to a new tab, and then sort and subtotal each tab the same.
Details:
Rows 2-5, Column A, both YTD and MTD tabs
[Business Unit Name]
Account Acctivity by Department
Expense Accounts 51900-58999
YTD ending [current month] [current year]
The MTD tab row 5 reads "MTD ending...".
Row 6, Columns A-J, both tabs
Account | Dept | Unit | Product | Descr | Source | Journal ID | Line
Descr | Date | Amount
Afer rows 1-6 are set up I sort by date then copy and paste the current
months data to the MTD tab. Then I sort each tab by Dept (B) then by
Account (A). Then I subtotal by Dept in the Amount column (J). Then
subtotal again, without replacing the prior subtotal, by Dept in the
Amount column. Then I bold the subtotaled amount by colapsing the
subtotals and using the Visible Cells option in the Go To Special menu.
So, can a macro do all this for me?
Thanks.
cp
heard anything in over a month; so I thought I'd try here.
****
I have a year-to-date accounting report I run every month, for multiple
departments, which I copy the month-to-date detail out of and then
paste to a new tab, and then sort and subtotal each tab the same.
Details:
Rows 2-5, Column A, both YTD and MTD tabs
[Business Unit Name]
Account Acctivity by Department
Expense Accounts 51900-58999
YTD ending [current month] [current year]
The MTD tab row 5 reads "MTD ending...".
Row 6, Columns A-J, both tabs
Account | Dept | Unit | Product | Descr | Source | Journal ID | Line
Descr | Date | Amount
Afer rows 1-6 are set up I sort by date then copy and paste the current
months data to the MTD tab. Then I sort each tab by Dept (B) then by
Account (A). Then I subtotal by Dept in the Amount column (J). Then
subtotal again, without replacing the prior subtotal, by Dept in the
Amount column. Then I bold the subtotaled amount by colapsing the
subtotals and using the Visible Cells option in the Go To Special menu.
So, can a macro do all this for me?
Thanks.
cp