Forum Discussion
Reza_Majdmrmajd
Dec 12, 2023Copper Contributor
Data transfering from one workbook to another using VBA code
Hello everyone. I have an issue with below code. it make the new sheet with the name that i choose from a cell but the data does not transfer from the source file that I already selected. try many d...
JKPieterse
Dec 12, 2023Silver Contributor
What exactly happens? Which error do you get (if any) and if you click Debug, which line is yellow?
Have you tried stepping through the code to see which "turns" it takes?
Have you tried stepping through the code to see which "turns" it takes?
- Reza_MajdmrmajdDec 12, 2023Copper Contributor
JKPieterse thanks for your reply, there is no error at all the macro runs, it make the new sheet with the name in the defined cell but no data is transferring to that sheet. No error at all it goes to the end of subroutine