Search results

Hi, Your requirements are not clear. Are you saying in report sheet D4 you enter the Company name like A1, and then you expect the data from UPdate client sheet to come in report sheet? pls clarify regards, Prasad DN

Hi, Try this VBA code: Sub RemoveDataAfterGrp() Dim iCol, iRow As Integer iCol = 1 iRow = 3 Do While Sheet1.Cells(iRow, iCol) <> "" If VBA.InStr(1, Sheet1.Cells(iRow, iCol).Value, "Group", vbTextCompare) > 0 Then Do Sheet1.Cells(iRow, iCol).Value = "" iRow = iRow + 1 Loop Until...

Hi, You almost got it! Try this code after you do copy paste: Dst.Cells(LastRow2, "A").EntireColumn.AutoFit Regards, Prasad DN

Hi Deepa9, In reference to your above quote, if you see the formula it creates when you use getpivotdata, you can see if it referring to Jan (like absolute reference), you need to edit it to Feb manually, or you instead simply give the cell address like relative reference. Again, as Narayan...

Hi, I believe you can try GetPivotdata() formula. whenever you do refresh PT, it will automatically update your data sheet. In case you need to retain the previous PT's numbers, once you get the data using formula mentioned above, copy and paste as values, so that whenever you do refresh of...

Hi, Try this formula: =IF(OR(C2="",C2=0),IF(OR(B2="",B2=0),"TBD",B2),C2) Regards, Prasad DN

Hi Jagdev, I hope you are fine with VBA solution. if yes, check the code in the thread: http://chandoo.org/forum/threads/how-to-control-excel-pivot-table-filters-from-cell-values-with-vba.19261/#post-116218 you may need to change slightly to fit your requirements. Regards, Prasad DN

Hi, If you can arrange the headings to be consistent in both the books, then you can acheive this without any macros. for example, in book 1, i changed the "August " to "August", and in book2 i changed "August (2014)" to "August". Similarly for other months headings as well. And, then...

Can you pls share sample file Regards, Prasad DN