Re: $$Excel-Macros$$ Macro to copy down/right and back up one line

2010-10-18 Thread DEF
Can anyone help with this? Not sure how well this copied but I have gl accts on the left with the months across the top. I need to copy only the acct data over to another tab and occasionally new accounts will be inserted so I don't want to "lock" in the range. I would like to go to Dec Actual

Re: $$Excel-Macros$$ Macro to copy down/right and back up one line

2010-10-12 Thread DEF
Not sure how well this copied but I have gl accts on the left with the months across the top. I need to copy only the acct data over to another tab and occasionally new accounts will be inserted so I don't want to "lock" in the range. I would like to go to Dec Actual for acct 60, shift end do

Re: $$Excel-Macros$$ Macro to copy down/right and back up one line

2010-10-11 Thread Srinivasan Ethirajalu
sample data pls On Tue, Oct 12, 2010 at 5:33 AM, DEF wrote: > I have a file that is gl accts and $$ amts with a subtotal at the > bottom. I need to copy down and then over and then come back up off > of the subtotal line. I tried offset and resize but couldn't get it > to do a row instead