Range Select from another cell

[miles44]

I have a baseball game I've created using Excel. I would like a MACRO that will copy several rows/columns of stats from one sheet to another. It would paste the stats in the cells on the 2nd sheet in the range reference by cell A1 of the 2nd.

Each team will begin with a different row number.

For example, I have (25, 3) in A1 and C25 is where I want the "paste" to begin. I'm having trouble getting it to work.

The first range is from the "PLAY GAME" sheet.

Here's what I have:

Please Login or Register  to view this content.

Thanks for any help you can give.

[mikerickson]

"(25, 3)" not the cleanest way to store two values. "25, 3" is better, but A1= 25, B1 = 3 is easiest of all.
I'm not sure that I have the sheets the way you want them, but code like this would do what you want.
The "get starting data" section could be modified to suit the scheme you decide on.

Please Login or Register  to view this content.