how to get the value of a column to cell in new sheet

[amethystfeb]

Hi,

I have same values in column C.

I need the current value of column C.

Each time i filter column b, i need its correspondin c value in new sheet B2 and for next filter C value in B3.

I have attached sample sheet and expected output.

Any suggestions!!sample_shr.xlsx

[Kamboj]

every time you filter the value increase in column b,c,d,e,f.... please explain more

[amethystfeb]

No the values do not increase.. I have values in columns a,b,c.

Each time i filter column b say with the sample attached. I filter column b with value"111", its corresponding C value i require. When i filter B (111), column C will have same values. I need to copy the value to a new sheet.

basically i need C value displayed in duplicates in column C to be pasted as a single value in a row in the new sheet.

[Kamboj]

I have used drop down list and macro to copy the value in new sheet, if you require any more than write us