excel

Sir. in my excel first sheet i have 4 coloumbs with filder option..in second excel sheet have same colounm name and same filder option ...third sheet also same colounm name with filder..what my question is in my first sheet in one colounm name FORM ..if i do filder it will come C ,F,S...I HAVE TO FILDER C FORM IN FIRST SHEET AND SECOND SHEET AND THIRD SHEET ..ALL THE C FORM PUT INTO ONE NEW SHEET ...IF I DO FILDER IN NEW SHEET ALL THE CONTENTS WILL COME CONTIOUSLY..I WANT SHEET NAME (SHEET 1,SHEET2 OR SHEET 3 ) IN NEW SHEET BEFORE CONTENTS DISPLAY..PLS EXPLAIN ME CLEARLY...

Almir's picture

Use "Visible Cells Only"

Filter your data to show "C" only.
Select all data => Press F5 => Select "Visible Cells Only" => Press OK => Go to destination sheet => Paste (or Paste Values).