Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook in which users dump in data, run a macro and use the
result. The macro itself works great, but the users need to go the original data to confirm that the totals still match. Here is the process: Users dump data into the 'Data' tab (original, huh?) Run Macro Compare the total value on the 'Output' tab to the 'Data' tab to make they match. Here is what I am thinking, but don't know how to code: Dim x As Double Dim y As Double x = SUM(Sheets("Data").Range("F2:F50000")) y = SUM(Sheets("Output").Range("Q2:Q50000")) If x<y Then MsgBox "Totals do not match" End If Thoughts? PJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I want to compare totals and flag those less than or more than | Excel Discussion (Misc queries) | |||
Need some help with more effective range manipulation | Excel Programming | |||
For better Performance in VBA for Excel - Strings manipulation OR Objects manipulation | Excel Programming | |||
Range manipulation | Excel Programming | |||
Range Manipulation Question | Excel Programming |