Hello everyone,
I'm really suck and need some help, please and thank you
The goal is that I want to create a vba script that will essentially scan the entire excel document based on a specific date that im looking for and spit it out based on each column.
Excel table:
For example,
I want to find out where 5/21/13 is and I want to show the column and its entry. I want to spit out a record that looks like this
Blue Network
5/21/13
Verse 2
Black Network
5/21/13
Chapter
Section
Section 2
Yellow Network
5/21/13
Section 2
White Network
5/21/13
Verse
Any help would be great
I'm really suck and need some help, please and thank you
The goal is that I want to create a vba script that will essentially scan the entire excel document based on a specific date that im looking for and spit it out based on each column.
Excel table:
Name | Green Network | Blue Network | Yellow Network | White Network | Black Network |
Chapter | 5/16/13 | 8/12/13 | 12/1/13 | 4/12/13 | 5/21/13 |
Chapter 2 | 5/17/13 | 8/13/13 | 12/2/13 | 4/13/13 | 5/22/13 |
Verse | 5/18/13 | 9/13/13 | 9/14/13 | 5/21/13 | 5/23/13 |
Verse 2 | 11/13/13 | 5/21/13 | 9/15/13 | 4/15/13 | 9/12/13 |
Section | 11/14/13 | 8/16/13 | 12/5/13 | 4/16/13 | 5/21/13 |
Section 2 | 11/15/13 | 8/17/13 | 5/21/13 | 4/17/13 | 5/21/13 |
Part | 5/22/13 | 8/18/13 | 12/7/13 | 4/18/13 | 9/15/13 |
Part 2 | 5/23/13 | 8/19/13 | 12/8/13 | 4/19/13 | 9/16/13 |
For example,
I want to find out where 5/21/13 is and I want to show the column and its entry. I want to spit out a record that looks like this
Blue Network
5/21/13
Verse 2
Black Network
5/21/13
Chapter
Section
Section 2
Yellow Network
5/21/13
Section 2
White Network
5/21/13
Verse
Any help would be great