I would like to copy 4 columns from one workbook to another
Columns are "A - I - M - N"
And upon modification or addition
A change occurs in another file.
Hope that was clear and hope for help.
I would like to copy 4 columns from one workbook to another
Columns are "A - I - M - N"
And upon modification or addition
A change occurs in another file.
Hope that was clear and hope for help.
Hi walid,
Try below code ...
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
Thank you for your interest
I'll try to tell you what's going on with me
Last edited by walid ali; 11-22-2020 at 05:36 AM. Reason: Thank you for your interest
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
Last edited by walid ali; 11-22-2020 at 05:37 AM.
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.
I apologize because it seems that I have not explained what I want clearly.
I mean , the workbook to which the data was transferred opens after the data was transferred to it and I do not want that
So do you want the file to be closed afterwards?
exactly
You can add the line in blue toward the end of the code
Please Login or Register to view this content.
Good morning mister nankw83
thank you very much
I am very grateful for your help
We hope to keep in touch
This is exactly what I needed
Glad to help … If that takes care of your question, please take a moment & mark this thread as [SOLVED] from the Thread Tools above your first post
Gladly
Sorry ... I hope I'm not annoying
Another problem happened ....
The workbook from which columns are copied "A - I - M - N"
I enter data into it through a UserForm
After completing the process, the Excel file opens
It shouldn't work
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
Last edited by walid ali; 11-23-2020 at 12:25 PM.
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
Last edited by walid ali; 11-23-2020 at 02:23 PM.
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
Last edited by walid ali; 11-24-2020 at 04:01 AM.
Hi .... nankw83
I did not find "Solved" in the tools. Is it possible to guide me?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks