A
Abe85
I have an excel spreadsheet linked to a network printer, it contains a
list of what each user printed, how many pages, and the total cost. It
is constantly updated. The total cost column contains the wrong price,
so Im using this formula: =SUM(D2/C2)*(H2) in EACH field on the total
user cost column to extract the CORRECT price. So, I started my macro,
highlighted the entire TOTAL COST column, then inserted my formula into
each field in that column. The correct price displays for rows that
contain data, but I am getting "#DIV/0!" on the rows that do not
contain data. This is fine, but when I try to create a SUBTOTAL (Data
--> Subtotals) for each user, I get the following error:
"To prevent possible loss of data, Microsoft Excel cannot shift
nonblank cells off the worksheet."
Can you help me write an IF statement that basically says: IF there is
data in this field than use the formula =SUM(D2/C2)*(H2), and if there
is NOT data in this field then leave the cell blank? Thank you...
list of what each user printed, how many pages, and the total cost. It
is constantly updated. The total cost column contains the wrong price,
so Im using this formula: =SUM(D2/C2)*(H2) in EACH field on the total
user cost column to extract the CORRECT price. So, I started my macro,
highlighted the entire TOTAL COST column, then inserted my formula into
each field in that column. The correct price displays for rows that
contain data, but I am getting "#DIV/0!" on the rows that do not
contain data. This is fine, but when I try to create a SUBTOTAL (Data
--> Subtotals) for each user, I get the following error:
"To prevent possible loss of data, Microsoft Excel cannot shift
nonblank cells off the worksheet."
Can you help me write an IF statement that basically says: IF there is
data in this field than use the formula =SUM(D2/C2)*(H2), and if there
is NOT data in this field then leave the cell blank? Thank you...