I am trying to create a report and I have it done, but it is very messy. I am hopeing there is a cleaner way of getting this done. Here is what I have and the issues:
I have a resident worksheet that has the following columns:
Name, ID#, Room, Date Arrived, Date Review, Date departed.
I have a shower worksheet that is used to track if residents are taking a sufficent number of showers. On this sheet, I want the Name, ID#, and Room to be in the cells automatically. I was able to do this by using =Residents!A2, etc
The first problem is that if Residents!A2 is blank then I get a 0 in the cell. I can hide the 0 by conditional formatting the font to white,but it makes another formula more difficult to achieve and printing will print all the cells if they have data. In other words, I initially have 10 residents, but for expansion issues I have 70 cells referenced to =Residents!A2, when I print the sheet, I will get several "blank" pages. Is there a better way to do this? I want to be able to create the sheet and not have to add rows/formulas when I get more residents. (I might not be the one using the workbook and want it to be simple to use. Any suggestions?
I have a resident worksheet that has the following columns:
Name, ID#, Room, Date Arrived, Date Review, Date departed.
I have a shower worksheet that is used to track if residents are taking a sufficent number of showers. On this sheet, I want the Name, ID#, and Room to be in the cells automatically. I was able to do this by using =Residents!A2, etc
The first problem is that if Residents!A2 is blank then I get a 0 in the cell. I can hide the 0 by conditional formatting the font to white,but it makes another formula more difficult to achieve and printing will print all the cells if they have data. In other words, I initially have 10 residents, but for expansion issues I have 70 cells referenced to =Residents!A2, when I print the sheet, I will get several "blank" pages. Is there a better way to do this? I want to be able to create the sheet and not have to add rows/formulas when I get more residents. (I might not be the one using the workbook and want it to be simple to use. Any suggestions?