Do you want to attach a sample of the input and an expected output after the macro would be run? It would help in easily deciphering what is required, and provide a solution quickly.
Do you want to attach a sample of the input and an expected output after the macro would be run? It would help in easily deciphering what is required, and provide a solution quickly.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
........A.......................B................. ........ ........C....................DOriginally Posted by Excel Fox
1. Empty............Veneer SKU....................7/5/2011..........7/6/2011
2. Empty............Face............................. Empty...............Empty
5. Empty............Back............................. . Empty..............Empty
9. Empty............Core............................. . Empty...............Empty
Rick,
It would have the data grouped like above. This is an example of the collapsed data. It would group all data between empty cells in column C and leave the actually rows containing the empty cells as a "Sub-Header" of Sorts. Column A will eventually be hidden in further code.
Posting Permissions
Reply With Quote
Bookmarks