Copy data to other sheet

[asdzxc]

VBA for "copy A1 data in Book1 - Excel and paste into another worksheet A1 in Personal - Excel (macro enabled)."

[Aussiebear]

Try the following

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

[asdzxc]

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]

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]

problem solved