Problem Moving Data from one Sheet to Another

Hello ExcelForum,

I am writing a macro for data transfer from one sheet to another in Excel 2003 and so far this is what I have;

Please Login or Register  to view this content.

But when I run that code, it stops at the first

Please Login or Register  to view this content.

and tells me that the subscript is out of range.


If I get rid of the

Please Login or Register  to view this content.

it works fine for the first selection as long as I start on the "P" sheet, but messes up the rest.

Please let me know how to properly select each sheet so I can transfer the data correctly.

Thanks!!

Same error occurred "Subscript is out of Range" with that code.

Ah there's the problem. It's titled "P", not P. Is there any way to recall that sheet if it's in quotations or do the quotations have to go?

Awesome, Chr(34) worked. Thanks so much!

Oh! One more quick question, would it be possible to compile the ranges into one line instead of having a 6 line code for each line?

Here's the basic code for on line

Please Login or Register  to view this content.

The next one would be

Please Login or Register  to view this content.

Got it, sorry I had a brain fart and entered it in wrong. Thank you so much for all the help with this. Much obliged.