I need help pulling data from a sheet that appears as a pivot table

i have an issue that i can not find a solution to. Hope someone can help.


Sheet=

Part Oct-09 Nov-09 Dec-09 ect.....
A 102 254 102
B 254 125 963
C 102 254 102
D 254 125 963
ect...


I need to be able to have the user enter a date and pull the info associated with that date into a text file shown below.
user enters date oct-09 into a input box.
excel pulls the data for oct-09 and exports a text file below seperated by pike symboles.

A|102
B|254
C|102
D|254

see attachment for more detail.

Thanks Daryll

Originally Posted by daryllc

i have an issue that i can not find a solution to. Hope someone can help.


Sheet=

Part Oct-09 Nov-09 Dec-09 ect.....
A 102 254 102
B 254 125 963
C 102 254 102
D 254 125 963
ect...


I need to be able to have the user enter a date and pull the info associated with that date into a text file shown below.
user enters date oct-09 into a input box.
excel pulls the data for oct-09 and exports a text file below seperated by pike symboles.

A |102| 10/1/09
B |254| 10/1/09
C |102| 10/1/09
D |254| 10/1/09
A |102| 11/1/09
B |254| 11/1/09
C |102| 11/1/09
D |254| 11/1/09


see attachment for more detail.

Thanks Daryll

i have tried the below code and got a little bit but i cant seem to figure out how to get it to pull the data

Please Login or Register  to view this content.