doodlebug323
New Member
- Joined
- Mar 6, 2014
- Messages
- 5
Hi,
I have a very large excel worksheet. It contains a summary sheet, with 1-500 in column A. As I receive information for "1", I create a separate sheet, called "1". The summary sheet then pulls in some of the information from sheet "1" to A1/B1/C1, etc. All of the rows in column A that I don't have information for yet (A2/A3/A4, etc) are hidden. Is there a way to have a row automatically unhide when I create the corresponding sheet? ... example: A2, containing only "2", would unhide when I create sheet titled "2"
I appreciate any help anyone can provide. Please let me know if there are questions about what I'm trying to do.
Thank you! Happy Friday!
I have a very large excel worksheet. It contains a summary sheet, with 1-500 in column A. As I receive information for "1", I create a separate sheet, called "1". The summary sheet then pulls in some of the information from sheet "1" to A1/B1/C1, etc. All of the rows in column A that I don't have information for yet (A2/A3/A4, etc) are hidden. Is there a way to have a row automatically unhide when I create the corresponding sheet? ... example: A2, containing only "2", would unhide when I create sheet titled "2"
I appreciate any help anyone can provide. Please let me know if there are questions about what I'm trying to do.
Thank you! Happy Friday!
