Worksheet and workbook question

A

Amedea_C

Hello

I am looking for a piece of code that will do the following using VBA:

1. Transfer data from one worksheet to another worksheet within the same
workbook (for eg. "worksheet for May" is copied to a new worksheet, which
will be renamed "worksheet for June". Some data on this new worksheet will
remain the same, while some will be modified)
2. On this new worksheet, the data to be modified comes from different
workbooks. (for eg. there are atleast 5 instances where data is copied and
pasted from 5 different workbooks)

Kindly let me know if its possible?

Thanks
 
G

Gary Brown

This is an example of taking pieces of May thru August and pasting to
September.

Sheets("Wks for May").Select
Range("A3:A8").Select
Selection.Copy
Sheets("Wks for Sep").Select
Range("A3").Select
ActiveSheet.Paste
Sheets("Wks for Jun").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Wks for Sep").Select
Range("C3").Select
ActiveSheet.Paste
Sheets("Wks for Jul").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Wks for Sep").Select
Range("B7").Select
ActiveSheet.Paste
Sheets("Wks for Aug").Select
Range("E5:E10").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Wks for Sep").Select
Range("E5").Select
ActiveSheet.Paste
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
merging data/worksheets 1
Auto populate one worksheet from other worksheets 4
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Get location of match in another worksheet 2
How to copy & paste a worksheet but change 1 bit of the formula? 1
Excel 2003 - Relocating an entire row of from one worksheet to ano 2
Help Required: Pulling data from a workbook into a worksheet. 1

Top