Im trying to automate some excel tasks.. All I need is to filter a particular column from the "dropdown box" . Once its filtered I need to get the values for the corresponding column as well.. I tried using something like below but not seem to be working. Can anyine help?
Original content restored above by GrandFather.
Thanks for the reply..
I used Spreadsheet::WriteExcel (autofilter). I actually wanted to read the values once the excel is filtered..
I have a very big file with many columns, I need to filter out "a column" say C and remove the blanks.. After filtering I want to find the other column values, say if column C3 has value 0.2, I want to get the value for column B3, A3..