Copying 4 columns from a work called "Final Work" into a work called "Student Fees"

[walid ali]

Hi
my name is Walid
New member .... still learning new vba
I thank the forum for hosting me
.................................................

I was looking for vba code to do a specific job
I'm running into writing code that does the task of copying some columns from a workbook into a separate Excel workbook
Can you help me

[walid ali]

Allow me to explain to you a few things about the project that I am working on, and I hope that does not bother you

1 - I am doing this project to learn to write symbols on vba.

2 - There are some difficulties for me in some programming issues

1- I took good steps, but I am still at the beginning.


What I would like to clarify is that my project is currently based on two Excel files.


* The first file is called "Final Work".

1- Contains three worksheets.

2- The final workbook file contains a secret number * for the tables and the source code.

3- On Sheet 1 - There are 15 columns A2 through 02.

4- I would like to make copies of 4 columns: from "Final Work Book" "A - I - M - N" to "Student Fees".

5- Condition - Any change or addition to these columns that affects the other file.


* The second file is titled "Student Fees".

1- Contains 7 columns.

2- Three columns working on the following functions:

• Column A = IF (B2 = ",", SUBTOTAL (3, $ B $ 2: B2)).

• Column F = IF (B2 <>, TODAY (), ").

• Column G = IF (B2 <>, NOW (), ").


* The operation to be performed: -

Copying the data entered in the final workbook from the required columns to the student's fees with any change or addition being modified

If you'd like to submit work files for a closer look ... I can.

Hope this is clear and hope you can help.


Thank you .