R
Rachelynn
I'm trying to create formulas for production scheduling. The lookup is
for how many months the product spends in each level. Products move up
levels, but based on the lookup, they move differently and skip certain
levels. The way I have it now, it shows the date in every level, even
though they may not apply. How do I delete the cells that do not apply
without creating an error in the rest of the row? I want to keep the
formulas (not paste values) and I want to be able to use the chart in
pivots. Any ideas? Any hints would be greatly appreciated!
Thank You!
Attachment filename: scheduling.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=644303
for how many months the product spends in each level. Products move up
levels, but based on the lookup, they move differently and skip certain
levels. The way I have it now, it shows the date in every level, even
though they may not apply. How do I delete the cells that do not apply
without creating an error in the rest of the row? I want to keep the
formulas (not paste values) and I want to be able to use the chart in
pivots. Any ideas? Any hints would be greatly appreciated!
Thank You!
Attachment filename: scheduling.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=644303