knucklehead
New Member
- Joined
- Feb 16, 2003
- Messages
- 31
I have an Excel workbook template that contains several sheets that is linked to a single sheet that I use for a report. The information in the worksheets will change for each individual that I have to do the report on, so that some rows will be blank. I have tried to figure a way to only link the cells with text in them, so that if sheet 1, cell b10 was blank it would automatically go to sheet 2, cell b10, etc. but was unable to figure that out. Now what I thought I could do, is go ahead and link all of the data together in the sheet for my report, then automatically hide any rows that were blank, so that I could fit all of the information onto one page when the report is printed. For example, in sheet 5, I have links to sheet 1, cells b10:b20 in sheet 5, cells a5 to a15. So, if cells b15 to b20 on sheet 1 is blank, I would want cells a10 to a15 to be hidden so that when I print, there isn't a big blank area in my report. I am not familiar at all with macros, or vba, so if there is a formula I could use to accomplish this, that would be wonderful! I would be more than willing to send the template to anyone who thinks they may be able to help. I have been working on this for several weeks, and need to get it fixed ASAP! Thanks in advance for any help anyone can provide!