Excel 2007-
I have a large spreadsheet that I add 2 rows to daily. I also have
about a dozen conditional formatting formulas that flag certain
conditions for quick identification. The worksheet that gets the
daily data is named "DataSheet"
I've written a quick VBA Macro that sets a named range
A1=the name of an employee, defined name is "Suspect"
A2= an amount of money, defined as "MaxLoss"
B1:B8 is a column of money defined as "Shortages"
C1:G8 is a range of employee names defined as "Associates"
if the money contained in MaxLoss is less than the amount in column of
Shortages and the
Excel 7
I have 60 rows, one for each of two shifts, each day of the month
Each row has 7 columns with an employee name in each column
I have one column (M) with the number of hours worked.
I have a constant field named "Associate" which contains the name of
one of the employees
Currently I hav
Value errror when used in a formula somewhere else.
Anyhow, I would appreciate any insight from anyone.
TIA, zp18
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links