Macro that calculates formula when entered from one sheet to another

[EXCEL0429]

I am looking for a macro that will update details in from another sheet based on a formula. The amount is at the summary level so i need to assign an amount at each detail level The formula summarize all the details amount based on a master roll number and a customer. Each line that has the same criteria master roll and customer then then a % of the total will take the amount for the data entry tab. I have upload a test example.

[Ed_Collins]

Thanks for posting the file, but if you could post another file, and give a few examples of your desired result, it would help. I downloaded your file, looked at it, and then re-read your question several different times, but I'm still not sure exactly what you want.

For example, I see the three columns you highlighted in yellow, but two of them already have formulas in them. And I don't know what the AB column, that says Allocate from Data Entry is supposed to contain.

(Sorry.)

[EXCEL0429]

Thank you for looking at this for me I have uploaded another file. Basically the areas that are yellow instead of have a formula in those area I would like the formula to be automated. So in Column O & P i would like that to be automatically populated from a VBA code for that sheet, and Q a macro that will take the data entry amounts and alocate it in that column.

Thank you again for looking at this.

[EXCEL0429]

TESTDATA2.zip the example are now included

[Ed_Collins]

Okay, give me an hour...

Edit: Or an hour and a half. Gotta get something to eat, first.

[Ed_Collins]

As a test, make a copy of the current values of the contents of your O, P, and Q columns. (Copy them elsewhere.)

Next, delete all of your formulas from these three columns so that all of these cells are now blank.

Finally, run the code below.

As you will see when you compare the values from my code to the values from your formulas, the code replicates the values exactly.

Please Login or Register  to view this content.

[Ed_Collins]

It does assume the data in DATA ENTRY will continue to begin on row 12.

It also assumes the columns will continue to remain as they are. But if not, the code is easy to change.

[Ed_Collins]

Finally, you can assign the code to a button or run it manually, or whatever you wish.

[EXCEL0429]

Since i am selecting the test customers i need updated is there anyway of updating those customers and not keep overwriting the other customer data if it was not selected. i need to select a customer update that one then select the next and so on and so on.

[EXCEL0429]

is it possible to only updated the selected data from the entry sheet to update the master sheet?