Search results

Hi, Getting all confused with MATCH, INDEX, SUMIFS, COUNTIFS, etc... A B C 1 Ref Sub-Ref Total 2 P001 00 16 <---- Looking to calculate this figure 3 P001 01 2 4 P001 02 4 5 P001 03 2 …based on the sum of these figures 6 P001 04 1 / 7 P001 05 5 / 8 P001 06 2 / 9 P002 00...

From what I can see and what I understand OLA Compliance to be - all your data appears to be SLA focused as oppose to OLA... I am assuming OLA to be Operational Level Agreement - essentially an SLA between internal support groups within a corporation and usually the internal end-client...

Sorry missed a step - you need to refresh the pivot table after setting "Show Items with No Data"... Right click anywhere in the pivot table - select Refresh

If I understand you correctly... Firstly you need to "Show Items with No Data"... Select anywhere within the pivot table... Select Options / Field List to show the field list... Click on Region in the Row Labels quadrant in the Field List and select Field Settings Click on the Layout &...

Heh Deb Thanks again for your assistance on this... Just in passing - my VBA is self taught and I whilst I have been using VBA extensively for some time I still struggle with the concept of methods, objects, etc... so I fully intend to do something about that and get a grip of these concepts...

Hi Deb It copies however... it loses the format of the destination cell which the routine I started with wasn't doing so... and this is essential... Secondly... the process will all take place within another vba routine... which is not expecting user interaction so I need to avoid...

Hi Deb and thanks for the speedy response... I have a specific task in mind... so in my case the cells in question will contain a hyperlink... but appreciate there is all manner of additional checking that can be brought into play...

I've checked out Chandoo's extensive summary on Hyperlinks but still getting myself in a pickle... !! Found this out there out there on the net... courtesy of someone called Webtest Sub HyperlinkMoveTest() Dim aSheet As Worksheet 'Sheet Handle Dim hLink As Hyperlink 'Hyperlink Handle...

Perfect - Many thanks :)

Hi - Any assistance gratefully received... I am trying to toggle between worksheets whilst maintaining the relative scroll position. The idea being that if I scroll down to row Row 500 in Sheet A... and then click the tab to move to Sheet B... that when Sheet B Activates it sets the scroll...

Thanks for posting a reply - and my apologies but I got sidetracked and hence the late response to your reply. And yes - much as I envisaged thanks.

Hi All, Sadly got myself in a bit of a mess... I am creating a dashboard and in the process I have created numerous sheets calling a finite number of Pivot Tables. The Pivot Tables are very large and I think that in my excitement I have created at least a couple of Pivot Tables that are no...