PDA

View Full Version : Copy data to other sheet



asdzxc
08-23-2013, 10:10 PM
VBA for "copy A1 data in Book1 - Excel and paste into another worksheet A1 in Personal - Excel (macro enabled)."

Aussiebear
08-24-2013, 12:51 AM
Try the following

Sub CopyData()
With Sheets("Sheet1")
Range("A1").Copy
With Sheets( Sheet2")
ActiveSheet.Paste
End Sub

asdzxc
08-24-2013, 01:40 AM
Try the following

Sub CopyData()
With Sheets("Sheet1")
Range("A1").Copy
With Sheets( Sheet2")
ActiveSheet.Paste
End Sub

I want to copy A1's data in Sheet1 of Book1 worksheet (macro not found there) and paste into Sheet1 of Personal worksheet (macro are found here)

SamT
08-24-2013, 07:20 AM
Personal.xlsm should not be used for data storage. It should only be used to store Macros that you want available in any and all other workbooks that you open.

Tell us about your existing scenario and what you ultimately want to accomplish. We can help you decide how to do that in the most usable way.

asdzxc
08-25-2013, 04:45 AM
problem solved