I have Excel 2003 on Windows 7. Made a bid tabulation sheet for my business but I'm constantly changing the Output Sheet when my bid tabulation sheet changes. I need to make the rows of cells disappear/reappear in output sheet if my bid tab sheet changes (or has not data). Example In My Bid Tab Sheet I may have 10 rows of items for one project and 7 rows in another. The Output Rows in project with 10 rows work but when I use the same template and rework everything for project with 7 rows in bid tab sheet, I have to go to output sheet and change/hide the rows there. I need to make the Rows in the output sheet disappear if there is no data in bid tab sheet row and still keep the formula in that row. I think this is what you call conditional formatting but IM not too sure.
Also I opened my excel file on another computer and Excel crashes every time I view the sheet that has the missing image or image that is supposed to be there but the image file is missing. When I click on the sheet with the image, I can see the path and where the image is supposed to be but with no image and Excel Crashes. I have tried to view the sheet in Excel Safe Mode but problem is still there. I need to change the path or reconfigure the sheet without deleting it