Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
First off I really need to thank Frank, Tom and Ron! While some of the
others here have also helped out, these three have really stood out when answering my questions! You're help has been amazing! Your patience with the rest of us is very remarkable and much appreciated! Thanks for taking your time to help us out! Now to the question... I want to write a macro that checks column "V" (or range "V9:V133") on a payroll worksheet and then if there is nothing in a cell, the macro returns a message asking if this is correct... and then allows the user to change the cell(s) and continues to check until the entire range has been checked. There might be instances of "0" hours so it's OK to have "0" but not a blank in the cell. In the perfect world... the process would only check for the information in the range "V9:V133" that had information in range "A9:A133" This is probably pretty easy but I'm not clear as to how to figure this one out... especially with the message box(es) that I would need to create... All this because I have users who forget to put in total hours for employees on a worksheet... ohh wellll I'm not sure if this can even be done... but any suggestions would be great! Thanks in advance for any and all assistance! Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
How do I create a macro to remove path from hyperlink "address"? | Excel Discussion (Misc queries) | |||
when a "check box" is checked, a "result" to be shown in another c | Excel Discussion (Misc queries) | |||
Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions |