Transferring Data Between Sheets (Excel VBA) [Archive]

ShiGuy

07-21-2016, 04:01 AM

So I'm trying to do a complicated data transfer between one "master" sheet and multiple "sub" sheets. Today is my first day with Excel VBA so I'm pretty lost haha. I decided to start small and transfer data from one cell of one sheet to the other sheet but I keep on getting this error of "Cannot jump to 'Sheets' because it is hidden". Can anyone please lend me a hand? Thanks in advance.

Sub transfer()
Dim strSourceSheet AsString, strDestinationSheet AsString, sourceData AsString
strSourceSheet ="profile list"
Sheets(strSourceSheet).Activate
sourceData = Sheets(strSourceSheet).Cells(30,37).Value
strDestinationSheet ="RADIANT OPTO-ELECTRONICS CORP."
Sheets(strDestinationSheet).Activate
Sheets(strDestinationSheet).Cells(C,11)= sourceData
End Sub

GTO

07-21-2016, 04:30 AM

Cross-posted Here (http://www.mrexcel.com/forum/excel-questions/954305-transferring-data-between-sheets-excel-visual-basic-applications.html)

ShiGuy,

Welcome to VBA Express. Reference your cross-posting, please read This article (http://www.excelguru.ca/content.php?184)

Thank you,

Mark