Hello Everyone,
As the question on the title, I want to update the values of a sheet from every new sheet that gets created by a macro I made. I made a Macro run when inserted Client Name on the inputbox that runs after you click a button. (Image 2)

When the Client Name is correct, the Macro will automatically create a sheet and name it after the Client Name and also will create a new Table for that Client (The Table Format does not change on any Client).

In that table afterwards values will be entered, like the amount of income, the date of that income, and which of the Workers took the income. Specifically in cell "I8" will be entered the amount, in "J8" the date will be entered and most importantly in "K8" the name of the Worker who took the income will be inserted, this will go on to the other income of the client "I9","J9","K9" then "I10","J10","K10" and so on (Image 3).

The Table that I created for those 4 existing sheets of Workers is as shown at Image 1, so on "A10","A12","A14" and so on the name of the clients that the worker got the income from will be pasted (hopefully). if the client name is on "A10" then the amount of income that the worker will receive will be entered automatically (hopefully again) at "C10", "D10", "E10", "F10" and "G10", Also the date when he got the income "C11", "D11", "E11", "F11" and "G11", same goes if the Worker gets income from other clients (Ex: "A12" -> "C12"=Amount, "C13"=Date, "D12" "C13", and so on) , see the Image 1.

(Keep in mind there are 5 different times a client can send incomes, that's why there are 5 columns for incomes)

Now the question is that, I need a code that will automatically:

1. Copy Paste the name of the Client to the Worker Sheet
2. Copy the amount of Income that the client gave to a Worker, into the Worker Sheet
3. Copy the Date of when that amount of Income has been received

The Macro Code I made did not work (They either ended up with a error and even fixing the error didn't do anything, or simply nothing changes on the Worker Sheet if I enter any value at the New Client Sheet).

Note: The First Sub is just the application Inputbox code and Sheet Formation, the Second Sub is the Table formation and at the end of it is the codes that I commented on purpose, because none of them worked.

Image 1: Disabled because I am new to the forum
Image 2: Disabled because I am new to the forum
Image 3: Disabled because I am new to the forum

If you do not understand from the code below because of the format, here are the codes shown in image:
Code Image 1: Disabled because I am new to the forum
Code Image 2: Disabled because I am new to the forum
Code Image 3: Disabled because I am new to the forum
Code Image 4: Disabled because I am new to the forum

Please Login or Register  to view this content.