Hello:
First off, pardon the long post.
The setup:
I have a data entry sheet with thirty different processes listed with cells for qty of good parts, and qty of bad parts. For example: cell C7 is 'Induction/MEECO', cell G7 is total 'Good' parts, and cell I7 is total 'Scrap' parts.
Question:
What is the best way (or any way for that matter) to:
(1) Check values in cells G6:G30 for a value other than "".
(2) If a cell has a value copy the process name, number of good parts, and number of scrap parts to another sheet.
(3) Change change all values to real values instead of formulas (I really should know how to do this).
Anyone care to help me avoid brain damage from beating my head against the wall on this one?
Thanks in advance
Dave
First off, pardon the long post.
The setup:
I have a data entry sheet with thirty different processes listed with cells for qty of good parts, and qty of bad parts. For example: cell C7 is 'Induction/MEECO', cell G7 is total 'Good' parts, and cell I7 is total 'Scrap' parts.
Question:
What is the best way (or any way for that matter) to:
(1) Check values in cells G6:G30 for a value other than "".
(2) If a cell has a value copy the process name, number of good parts, and number of scrap parts to another sheet.
(3) Change change all values to real values instead of formulas (I really should know how to do this).
Anyone care to help me avoid brain damage from beating my head against the wall on this one?
Thanks in advance
Dave