How to copy 4 columns from one workbook to another workbook

Hi walid,

Try below code ...

Please Login or Register  to view this content.

Thank you for your interest
I'll try to tell you what's going on with me

Hi nankw83
I would like to thank you very much
On the code you provided me
I would like to tell you that it is a successful symbol
I was trying for two weeks, but without result
Tried with many code

I was very happy to get to know you and I'm very happy with the success of the code

There are only two notes:
When the columns are moved to the other workbook
The workbook opens to which you want to copy the data
But it shouldn't work

Thank you

Originally Posted by walid ali

There are only two notes:
When the columns are moved to the other workbook
The workbook opens to which you want to copy the data
But it shouldn't work

I am not really sure I understand what you mean ? So do you want the copied columns to be moved to a new workbook or a certain workbook that you use ? If destination workbook is an existing file, then you can use the below ..

Please Login or Register  to view this content.

So do you want the file to be closed afterwards?

You can add the line in blue toward the end of the code

Please Login or Register  to view this content.

Can you post your existing code or file

OK
Only .... The user interface is in Arabic

So you can access the Excel 1234 file
To access code 1234

1- In the final workbook ......sheet1
2- In student fees ............ sheet1

Attachment 705478
Attachment 705479
Attachment 705480
Attachment 705481


I could not find the attachment

If possible, e-mail
So that I can send the file

Please follow the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" instructions on the yellow banner on the top of the page

Please take a look at these notes
OK
Only .... The user interface is in Arabic

So you can access the Excel 1234 file
To access code 1234

1- In the final workbook ......sheet1
2- In student fees ............ sheet1

Pictures matter


https://www.excelforum.com/attachmen...1&d=1606154570
https://www.excelforum.com/attachmen...1&d=1606154557

Hi walid,

So, if I understand correctly, once your UserForms are filled, you want to copy the 4 columns from "Final workbook" to "Student fees" workbook after clicking on "display data" button & the password is correct ?

good morning

Hi nankw83


Well ... once you have filled out your user forms you want to copy the four columns from the final workbook to your student drawing workbook <............ that's right

After clicking on the "View Data" button, is the password correct? <............. This is an error

................Which I want...................

After clicking the Save on UserForm 1 button <............. that's what I want

5.jpg