Transferring data from one worksheet to another

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
 

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

Embed the same Excel multiple times 0
Worksheet and workbook question 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Auto deletion of cell entry in given circumstance 0
Excel macro to copy rows in one sheet and insert into another sheet 5
Transferring text from one worksheet to another 1
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
How to update data from linked worksheet back to a master worksheet? 0

Top