Moving Data Between Sheets

[bsteeves]

Hi everyone,

I have one very large piece of data located in one worksheet that I use across ten other worksheets. I simply copy and paste this data into each worksheet each morning after the data has been refreshed. Is there any way to be able to simply have my master sheet update and then get coppied to all of my other sheets? Thanks in advance.

 

[bsteeves]

Sub test()

Dim wb As Variant, wb2 As Variant
wb = "COA.xlsx"
wb2 = "Invoice.xlsx"
Workbooks(wb).Sheets("Sheet1").Range("A1").Copy Destination:=Workbooks(wb2).Sheets("Bonds").Range("A1")

End Sub

Still cant seem to get this to work. I am getting "Subscript out of Range" on the very last line of code. Any ideas? thanks.

 

[texasalynn]

do the sheets and files actually exist? Double check the spelling also.

 

[bsteeves]

Good call, sorry.