

Tag Archives for " filter "

0 Auto Filter Cursor Movement

Don’t you hate it when you are working with many fields and you want to filter a particular field, so you apply auto filter on the all fields, but you find out that the field you were working on is gone from your sight and you see A1 cell. I did. Not anymore. Solution: Simply […]

0 Create Sheets based on a Column

Ever felt the need of creating different sheets based on the distinct values of a column. For example, in your data, you have a column called STATE, and you would like to create a separate sheet for each state with all the data from that state. Here’s your solution then:(Note: you’ll need to add a […]