Thread: [Solved] HLOOKUP, if,? OR MACRO
View Single Post
 
Old 04-13-2011, 07:29 PM
bobbyarnold bobbyarnold is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Apr 2011
Posts: 13
bobbyarnold is on a distinguished road
Default Hlookup, true false

Ok now i have this Macro working for me and doing alotALOT! of my long hand work. Was wondering if there is a way to count the welders for each weld (Done) and couunt if there is a date in a cell in the row from which it counts. so if a welder gets credit for 1 weld inwhich his ID is in a cell in that row. could there be a function or macro that would count if the row has a date in a coulumn. example the welder has 20 welds (Done) if 15 rows have been x-rayed then the number beside 20 welds is 15 for the number of xrayed welds. thanks in advance for any help or communication
if this cant be done or is too complex just let me know but this would be of great benefit as well.
Reply With Quote