Copy and paste of data if matches Conditional calculation and pasting of the data

[DocAElstein]

I forgot to do that last bit to copy S10 value and paste it to S9 & S8
That is very, very simple - See if you can do it.
If you can't , I will add that bit later for you. I am away for many hours now.

---

( You are correct, you still need Function CL() )

[fixer]

No Probelm Doc Sir Take ur Time
I am unable to make it u plz have a look once u r free Doc Sir
Have a Awesome Day

[fixer]

Here i want a little change Doc Sir
calculate the total value of column Q of ActualFile.xlsx and if it is Greater than S10 of ActualFile.xlsx then this macro should do the process else do nothing
So plz relook Doc Sir for the same

[DocAElstein]

At end of macro

' In Actual File, copy S10 Value to S9 and S8
 Ws.Range("S10").Copy
 Ws.Range("S8:S9").PasteSpecial Paste:=xlPasteValues
End Sub

[DocAElstein]

... a little change ..
calculate the total value of column Q of ActualFile.xlsx and if it is Greater than S10 of ActualFile.xlsx then this macro should do the process else do nothing ..

Here is the new macro
https://excelfox.com/forum/showthrea...ll=1#post13404

( These are the test ranges I used https://excelfox.com/forum/showthrea...ll=1#post13403 )

[fixer]

Thnx Alot Doc Sir for helping me in solving this problem Sir
Have a Awesome Day
Problem Solved

[fixer]

Thnx Alot Doc Sir for helping me in solving this problem Sir
Have a Awesome Day
Problem Solved