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

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

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

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


roups.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