Transfer macro

**Loisw** · 05-29-2009, 07:54 AM

Hi,
I have attached a credit control spreadsheet. i was wondering if i could write a macro that transfers all invoice lines that contain a capital P in column T from the Outstanding tab to the next blank row in the paid tab. i have tried a few macros but none of them have worked!

**mewingkitty** · 05-29-2009, 09:07 AM

Please Login or Register  to view this content.

Something like that work for ya?
Just create a new macro and drop that entire code in there.
tested it briefly, I believe it does what you want it to.

mew!

**Loisw** · 05-29-2009, 10:04 AM

Hi it doesnt like the y=y+1

**mewingkitty** · 05-29-2009, 10:36 AM

I don't like soggy cheerios.

Could you perchance be a touch more specific? In terms of which section of y = y + 1, and also the error which it's giving you.

Please Login or Register  to view this content.

**mewingkitty** · 05-29-2009, 10:39 AM

oohhhh, nvm. I see what I did.

Got a <> in there instead of a =

Please Login or Register  to view this content.

You got a "Subscript out of range" error I'm guessing? that y = y + 1 was looping to infinity and beyond, if I'm not mistaken.

mew.

**Loisw** · 05-29-2009, 10:40 AM

Hi
its run time error 6 on the first y=y+1 it is not giving a specific warning!

thanks

**Loisw** · 05-29-2009, 10:44 AM

Its working now thanks very much ive been pulling my hair out for days over that!!

**mewingkitty** · 05-29-2009, 10:44 AM

bump.
Answered the same time that you did, wanted to make sure you knew it had been responded to.

And I just needed another reason to mew.

mew!

**mewingkitty** · 05-29-2009, 10:45 AM

np,
take care.

**Loisw** · 06-01-2009, 03:06 AM

Hi
sorry to bother you again but i have just thought of something else that will make the macro work better:

can it be modified so that any macros that are transfered from outstanding to paid are deleted from the outstanding tab & the same amount of new rows added to the outstanding tab as were deleted?

There is a total on row 41 of the paid tab. Can it be set so that it doesnt paste the rows over the top of the total?

Thanks