Search results

Can anybody explane me the getpivotdata with example....

Can you please update me the sheet.

Thanks Hui

Hui Please try this steps, 1. First in data table you put some color in some cells. 2. Just right click and click filter and then click "Filter by selected cell's font color" it will work....

Hui it is possible that we can filter by color. you can refer: http://www.dummies.com/how-to/content/filtering-by-color-in-an-excel-2007-table.html

Actually Hui I need to to do some colour for present that sheet. but after doing this if I reopen this sheet again it comes by default (text mode).

Thanks Vijay

You just click that filter in Pivot Table, you can get one option top 10.

Hi Sandane, You call this in command button First you need to put the range like: Sub copy() Range("cell number").selection //this is the first cell of the data// Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.copy End Sub I think it will help..

Hi Tanu Can you please update the datasheet for this.

can anybody please update me how I save *.csv file with formating

Hi I am Biplab and I am a Matric Analyst in a telecom industry. I love to do excel and I try to learn more and more in excel.