Choosing Selected Data In Cell

  • Hi all...


    I'm a beginner in VBA. I have a question to ask. Maybe this is a simple question.


    How to choose the selected data and then copy and paste it to other workbook using VB?


    Before this I manually open the file, copy the required data and then open the other workbook and paste on it. All of this is wasting my time because there are too many file that I need to do same thing every time.


    Thanks.