Copy MTD info from YTD detail and paste to new tab Macro

[cp1cp2@gmail.com]

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

[???]

I think so :You Can try to Record a Macro
Just Follow as below

Tools=>Macro=> Record New Macro



--
Ares.Chen
Shanghai,China,Asia
Windows XP SP2 + Office 2003 Professional Edition


<cp1cp2@gmail.com> ??????:1126135195.390158.31630@f14g2000cwb.googlegroups.com...
> 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
>