Search results

Hi NItesh, This may be help, please see http://www.contextures.com/xlPivot13.html

Kindly upload sample sheet.

Looking for work :) Thanks

Good one Khalid, extraordinary Always!!.

Firstly welcome to our family!. Hi Ravi_Verma, You requirement is unclear. If this is not resolved yet, please elaborate your requirement and share the desired output

For this you can use condition formatting- please refer screen shot below

Hi Sasuke, This is because of nature of Pivot table as pivot table is maintain its own cache, the default pivot table sorting functionality is based on raw data set. If you are appending new data set in your raw data (whatever you are appending or inserting somewhere in data) the pivot table...

Hi Jason, Please refer below ulr, this will help you to make searchable drop down. https://www.extendoffice.com/documents/excel/2439-excel-drop-down-list-search.html

Hey Gregg, It would be great if you can upload desired out and sample. Thanks

Hi Masters, Can anyone help to understand this also please share some useful tips/tricks and urls. thanks

Hey Bosco, Could you please share the list of all Get. function usage or formulas or please share the url if any. No, we can not find {=formula()}

Hey, Do you want to cover all "Treatment amount" before/ after prepaid or only after prepaid. Please see attachment for all treatment amount with date associated

Very nice, good job done. y

Try this one Sub a() iL = Range("a65556").End(xlUp).Row Range("a1").Select i = 1 Do Until i > iL If ActiveCell.Value = "" Then x = ActiveCell.End(xlDown).Offset(1, 0).Row Else x = ActiveCell.Offset(1, 0).Row 'MsgBox x End If Rows(x).Select Selection.Insert Shift:=xlDown If i =...

I am not very much good in VBA, but this will help you Sub rr() k = 1 iL = Range("a1").End(xlDown).Row For Each i In Range("a1:a" & Range("a10000").End(xlUp).Row) Rows(i.Offset(k, 0).Row).Select Selection.Insert Shift:=xlDown k = k + 1 Next i Range("a1").Select End Sub

Dear All, I am looking for freelancing work - Reporting Dashboard Excel Automation Thank!.

Seems there is connection between excel and ppt. please refer below url - https://blogs.msdn.microsoft.com/mvpawardprogram/2014/04/07/powerpoint-and-excel-perfect-partners-for-dynamic-tables-and-dashboards/

This is horizontal double axis chart. you can just add second horizontal axis and show this on top or hide

This is quite interesting, can you please share the correlation between all sheets. suggestion- Yes, this is possible thru index / match but for range we have to use INDIRECT function to make dynamic range.

+ and for formatting 3. without moving cells (A1) press Alt+E+S+T and enter

You can use paste special link - 1. Copy data from sheet1 2. go to sheet 1(1) and at A1 paste as (Alt+E+S+L) and enter

Using formula -

I think this is what you want - or

Hi Baama2, Is this the solution what you want? if not and you remember the image (chart) just draw and share with us. will try to resolve this. :)

Hey Raj, Few question - 1) Is the count of plan for a day is fixed lets say you have mentioned 15 in Ajay sheet? 2) What is "Dr./Prospect Name" in Data column is this the value for Ajay plans You need to change little bit (need helper column) to do this job. Attaching the sample sheet