[CLOSED] VB script for copying ranges between worksheets in the same workbook

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9817071706

July 20, 2011, 12:20 PM

MarciaDrummond

[CLOSED] VB script for copying ranges between worksheets in the same workbook

I've looked at some of the VB/Excel solutions previously posted and have not found anything that does this.

I would like to copy:

Columns A through H starting in row 12 through the end of the data in Sheet1

and

Paste it to:

Column A through H starting in row 23 in Sheet 2

Sheet 2 is a template with the desired styling and it includes the heading, footing, and column titles.

Thanks.

This message has been edited. Last edited by: MarciaDrummond,

July 21, 2011, 02:19 AM

<JG>

An Excel forum might be a good place to look.

July 21, 2011, 09:04 AM

ABT

quote:
Originally posted by MarciaDrummond:
I've looked at some of the VB/Excel solutions previously posted and have not found anything that does this.

I would like to copy:

Columns A through H starting in row 12 through the end of the data in Sheet1

and

Paste it to:

Column A through H starting in row 23 in Sheet 2

Sheet 2 is a template with the desired styling and it includes the heading, footing, and column titles.

Thanks.

You could always record what you want to do as a macro, and edit it to take the juicy bits out.

- ABT

------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro

July 21, 2011, 04:29 PM

MarciaDrummond

Thank you JB and ABT. I will continue researching this request on an Excel forum, as JB suggested.

ABT's suggestion sounds promising and I will try that first.

This message has been edited. Last edited by: MarciaDrummond,