How To Automatically Drill Down Data In Excel on a SINGLE Click

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
hello and welcome this is Randy with Excel for freelancers and today we've got a great training where we're going to be drilling down two levels of data here so please stay tuned it's gonna be an amazing training alright let's get started today what we have here is we're gonna have the ability basically to drill down to specific data in our workbook so it's gonna be really great and a lot of times we have data in this case we have customers okay we have invoices and we have payments okay but what I want to do is I want to see those invoices with a drill down and I want to see the payments that make up those invoices also and I want to do that all from the same screen now why would we want to do that well there's a couple of good reasons one is it's very quick and it's very easy for the user to be able to see data with just a single click number two is they don't have to go to additional sheets they can stay on the same sheet the same set of data and view multiple forms of data okay that's another reason another reason is it's very fast and it's a very great way for users to be able to get the information they want extremely quickly all right so that's what we're doing and there's a great way that we've done it too so that it's extremely fast no matter how much data now let's go over how this is done okay well once again like I said we have three sets of data here we have a customer table we have a set of invoices and we have a set of payments okay and the important thing each of these tables has a unique identifier unique qualify or number as you can see each customer has their own unique number okay so excuse me when we have customer numbers here each customer has their own unique number okay so that's very important no two customers can have the same number so you'll if you're deciding your table you want to make sure that the user doesn't have ability to edit or change this or to duplicate additional customer numbers in invoice numbers as you just saw each invoice number is also unique as well and that's what identifies each specific invoice you do not want to have more than one invoice number and on payments all we do is we simply track those customer numbers and then we track the invoices so we know which one to apply those invoices to so here's basically a list of payments okay and then each one of those payments is tied to a specific invoice number so that's gonna help us track and that's how we formed our data okay and now what we've done is the idea is when we expand when we click on the plus here it shows all the invoice numbers the invoice dates the amounts and the total payments keep in mind that these values are not accurate it's just test data so they don't add up okay don't worry about that I was just playing with it but I'm sure in your tables they were add up they will add up properly all right and so the idea is when we click on when we expand an invoice I want to know the payments that make up that invoice okay so generally you will have your payment amounts all match the total payments but we're just demonstrating the ability to expand ok so how do we do that okay well let's start out with some conditional formatting all right I've got multiple forms of conditional formatting here and that really helps us quickly color things we don't want to use Excel VBA to color if we can help it because that's a little bit slower conditional formatting is extremely fast and I've been able to do that with one hidden row and let's go ahead and unhide column Oh okaycome ho so will unhide that and as you see here I've got little notations little letters here that tell me what type of data is in this row C is for customer okay IH is for invoice header I is for invoice P H is payment header P is for payment and so on so because we're able to uniquely identify each row we can then create conditional formatting based on those values so let's go ahead and look at it I'll just click on one cell here go to home conditional formatting let's go ahead and I take a look at the rules and we've got a set of rules we've got about six rules or so for each one we'll start at the beginning and this one this particular rule is for our main table okay it's for all these blue and whites down to for this to be accurate we want to have two things actually we want to be able to let's see this should be equal to C let me fix that a little quick all right because I want you to be able to see what that is okay so what this is is the ability says if it's a customer see and if it's an odd row okay this is odd rows what this mod row beginning and end parentheses to tells you every other row every other row color it light blue okay so that's what this is alright it worked all also on m5 but but we want to make sure and this m5 remember it's very important that there's no dollar sign before the five that means that it's going to be able to use for every row okay if we put a dollar sign here it's not gonna work okay and then also the important thing is remember that five okay our starting row also must be five so when we have five and are starting row that means it'll work for every single row okay and so that's what we get that's what we get our main coloring for the main table okay and next up let's go with invoice okay we have an invoice header here okay and this is a very simple rule and all we're saying is that let's go ahead and move it over here dead if it's ih invoice header I'll want to apply the following colors now let's go look at that conditional formatting see what type of we have apply well one I've changed the border color okay - I've changed the font color and I've changed the fill color so we're gonna apply those to three different settings so they have a different color okay and let's go ahead and take a look at the invoice okay those are just four invoice items and again if M five remember no dollar sign off before the five that's critical that that's why we can use one rule that applies to the entire table if it's invoice I want to color the cells what's that like a light blue or turquoise right I'm gonna put a border around it which is the same color we're using and there's no change to the font okay so that helps us colors and when we look at the when we look at the rule it applies to we're not applying this to the whole table we're applying it to columns G right we're starting at G okay so you see G here from to the end till L okay that's gonna cover us for the whole table okay for the for the whole area that we want the invoice just for the invoice section not the whole table whereas in this particular rule we did cover the whole tail because that's for all the invoices and basically the same idea for payments we've gone ahead and you know any the header row that has pH we've gone ahead and changed that color and also for the payment in the individual payments we've gone ahead and given that a light and we've covered only I write high through K high through K just these three just these three columns here four payments so that's how we're able to get the colors all right and now let's go ahead and vbn get under the hood and see how this thing really works all right to get into the VBA editor if you have a developer's tab open you can go here to the visual basic alt F 11 is this sort is your shortcut if you do not have the developers tab into file and options also under the customize ribbon you can see the developers here so we'll want to check that okay so we'll go ahead and alt f11 that'll bring us into the developers tab and first up we have our customer Sheik here okay in this customer sheet we have what we want to do is you want to create macros based on the selection change in this customer sheet this is the only sheet that we have the macros running and the important thing here is selection change okay because what happens is when we select something right it's not when we change something it's when we select something we want some action okay so that's selection change okay and what is the range well the range is this G column here okay G and I've and I've put so if not intersect target range g5 through G 100 now this 100 you can you can make it 1000 you can make it 10,000 so you can change this depending upon your data or you can use the entire column g2 if you want I just kept it at a hundred for now so we're saying is that if we make any kind of a change in this then I want something to run okay if we make any kind of selection now the reason we have if target you're gonna see this a lot in when I do programming because when if without this watch let me show you what happens without it without this okay I'm gonna comment that out now when we select let me pull this up when we select a large range we're gonna get a bug okay it's just and that's what happens when we do a target when we do a selection changes and we highlight a lot of rows we're gonna get a bug okay so and it's gonna say hey something so what we're saying here is if the count if the count is more than one if you selected more than one cell then just exit this up so that's why we have that there so now with that in right and you select more than one row and then you don't get a bug so that's the reason we have that there so it's very helpful you'll want to use that also in most of your code when you do selection change or value change you'll want to have target count but keep in mind that if you're selecting a merged cell it might cause problems because merge cells often contain you know more than one cell so so if you're if you're using merge cells you may not want to use this okay so that's why I have that rule and basically the next area is what I'm saying is if the target value equals this plus sign and M and the target rope equals C then show the invoices so what that means is if it's a plus right if we're at a plus here and this hidden column is a see that means we know that means in that case it's a customer oh it's not an invoice room okay so what do we want when that happens well when that happens I want to run a macro at a macro called show invoices and we'll go over that in a minute okay if it's the minus sign right if it's the minus sign and it's also customer then I want to hide the invoices okay if it's a minus sign like this I want to hide them okay or like this item okay so if it's a minus sign and a see I want to hide okay if it's and then the next two parts of the code are basically saying if it's a if it's a minus sign and an in and an invoice I want to hide the payments okay so if you look on the code here the next the next section is if it's a plus and an I show the invoices if it's a minus this should be hide so either you update that that we're gonna be hiding invoice let me update these are comments so you'll help show you what we're doing so I want to make sure we accurately so we're hiding the invoices and that these are payments not invoices so let me update that code for you as well so that when you get the workbook you know everything that's going on here okay so we're hiding I've also made the macro names very clear to show payments hide payments okay so you've got lots of commenting so you know what's going on so that's all that they're all that's all the code that runs on this page okay let's go ahead and look at the invoice macros okay and we'll go over this line by line so you know what's going on but basically here on the invoices here's the idea what I want to do is I want to want an advanced filter and I didn't know what advanced filters were the first few years and cough thank God I learned that it's one of the if you don't know what an advanced filter is it's one of the best things that you can learn and I'm going to teach that to you here today and it's fast it works with tons of data it's very easy to use it's very easy to manipulate and it's really it's really great thing moving forward you're using all your applications and basically the idea is here is I want to I want to search all of the info and I want to search for let's just say we're working on customer for okay so what we're gonna do is we're gonna take that customer number and I want to know all the invoices for this customer okay so in the advanced filter what I've done is saying I want to filter all these but I don't want to filter it in the place I want to filter it here an advanced filter the ability is here under data advanced okay and we're going to use VBA but if you were doing it manually you would use it here what we're gonna do is we're gonna copy it to another location okay and so first of all what is the data okay here's the data the original data III through K okay the only difference is in ours we don't want 48 because we don't know what the last row is in VBA so we're gonna actually use a variable for that okay and the criteria means it means is here a1 through AG okay so the criteria means what should we filter this by right and then copy to range bool I want to copy the data where do I want to copy it I wanna I don't want to copy it in place okay I want to copy two different locations but we can work with it once it's in a different location and you can see here we filtered this customer number four and two listed only you know you cancel that up and we listed only the customers number four and so that filtered our data so advanced works really good we're gonna do all this through VBA but you can see what's going on here and we did the exact same thing for payments if we scroll over except we use invoice number so I want to know all of the payments for this specific invoice number so we ran an advanced filter now when running advanced filters there's one very important rule okay and that's these headers name names must match these headers if there's a slight difference it's gonna throw an error okay so what I'll do is always you know copy this and then I'll paste here and I'll hold it ctrl and then I'll paste the values okay I want to make 100% sure and that these values are the same as the headers those headers values must be the same that's the really important rule so you'll want to take care of that okay so that's what's going on so basically the idea is when I wanna I want to know all the invoices for this customer I want to know how many and I want the data so I want also when we filter it we use number four here now we know we've got all those and so through VBA we'll do that all right so let's go ahead back into the VBA and I'll show you what's going on here under the invoices we've dimensioned a few variables customer number and invoice number is string okay and the invoice quantity that's gonna be the number of invoices cuz we need to count we need to know how many rows to expand under that plus one for the header so that's very important to know how many ok we need to know the last invoice row when we run our advanced filter we need to know the last row of our invoices okay so that's very important also we need to know the active row and the active row is whatever row we have selected okay we need to know what that row is in this case is 13 but we need to we need to put that into a variable so that we can use that through our code so we need to know what that active row is okay so in our code here the first thing I've done is I've gone with sheet one most of our work is going to be here in sheet 1 which is customers so we've we've used width and width so that we can no longer need to defer to that sheet or refer to that sheet here so we've done which you want and the active row basically is saying where it's the active cell row you could theoretically use active cell row throughout the code as well but we've shortened it up just as a variable under active row okay first of all we want to know what the customer number is okay so the customer number is e and the active row that'll get us a customer remember our customer know it's e right so if we've selected if I've selected G right if I selected here I know the customer number is 1 e 1 right because that's the selected row okay so II 5 is customer number 1 so we know so we have to get that customer number which is here all right now the last invoice row we need to know what the last impress or if we're gonna run a filter right and we're gonna go back into the invoices if we're gonna run a filter on all of these invoices we need to know what what's the last row in our case it's 48 okay but we need to know that through VBA so this line of code will tell us the last row of invoices sheet to 999 you can change this number to I think the maximum is 265 that'll I don't know I don't know what the maximum is but this covers us okay so this is going to tell us the last row of the invoice this is important because we don't want to run an advanced filter on all of you know the possible rows we just want to run it only on the data we have and that helps speed things up okay next is what I want to do is I want to clear out any possible previous filters okay so what I've done here is we're just clearing some contents here a two and a fourth a a four through a G 99 all of clear data and I'll show you what that is basically what I'm gonna do is I'm gonna say you know what I want to delete this I want to clear I want to clear this any any possible customer number before and I want to clear all this out I don't want to get any confused with any possible previous filter so make sure that before we run a new filter we've clear cleared all the data out from a previous filter that's really important okay so that's what this line of does clears any previous data next up for our advanced filter we want to put that customer number in a a to write we want to put that customer number right here okay because that's going to tell us what to filter the data bottom alright so in our next line of code is the advanced filter okay an advanced filter is just one line of code alright and it's the same thing remember it's this it's doing the same thing as this data advanced filter it's doing all of this work okay it's doing that exact same thing except in VBA so under advanced filter alright first of all we need to know what the data is we're filtering okay and remember this is all of the invoices all of the invoices okay so III to K and the last invoice row all of our all of our all of our invoices here III include the header make sure you include the header III to K and then whatever the last row is okay so that's the filter that we're going to be working through okay and the criteria means well you want to filter what is the filtering okay so the criteria is all this right and if you wanted a specific customer number and a specific invoice number you could add theoretically to different criteria shares we're only using one but our criteria is here a 1 a 1 through a g-tube that sets our criteria so that means it knows it's going to filter anything we've already put the customer number in there so we're gonna know what to filter it by all right so the criteria a 1 through AG 2 and now it says we'll wait once this is filtered where do you wanna where do you want to copy this range to okay we want to copy it to a a a a 3 to a g3 and all saying is we want to copy it right here including the headers always including the headers a a 3 through a G so that's all we're gonna do it we're copying it there okay and the last one is is unique are these records do you want just the unique ones and that is correct true so that's what that does so what that does is it's gonna put all that data here so for example if we click on customer right if we click on customer number two and now we see three invoices let's go back okay now you see the code ran customer to customer to right and it puts all informations it's just amazing once you learn how to do this it opened up so many possibilities for me so advanced filter is critical so that's all we did now what we need to do is okay we have all of our data but now what I want to what I want to do is I want to basically say I want to get this data here I want the invoice number I want the invoice date the amounts I want to put that all I want to put it right here okay okay I want to put that right there so I want to put these three information and I want to stick it right here right here okay that's what I want to do so what we have to do is we need to know first of all we need to know how many rows of data how many how many filters so we need the last filter row okay what we need to know is what's the last row in our case this last row is 6 right so we need to find out because we need to know how much data to transfer over we know the starting rows 4 right but we don't know the end grow or VBA doesn't know so the last row is simply sheet to a a we're gonna use this column a a a ok just make sure you use columns that always have data in there a a and then it'll give us the last row so this tells us the last filter row and in if there's a case where the last filter row is less than 4 that means we have no invoices ok so what's gonna do is we said okay if there's no invoices we're gonna skip all the way down here and we're gonna put a little message box saying there's no invoices for this customer ok so what we do is normal normally we're gonna exit sub but this tells us to message just give the user message by saying there's no invoices we don't want to run through all this if there's no invoices so what we this tells us to skip all the other stuff ok so we know the last filter row in this case is 6 okay so the invoice quantity the number of invoices equals the last filter row minus 3 okay so if this is 6 minus 3 that means we have 3 invoices 3 invoice so we know we have the invoice quantities 3 okay now the next line the active cell we need to change it to negative that means back in the customer sheet we need to change this value here if I click on this going to go back to plus just to the right we need to change it from a plus to a minus because it's now expanded ok so that's all that line of code does it just changes it to a minus okay now what we need to do is we need to insert the number of rows basically what we want to do is we want to enter the number of invoices plus one extra one for the header ok we want to enter the header first so we know what it is so all saying is the invoice quantity plus 1 insert down that's what this line of cuz inserts the number of rows and I'll just put inserts number of rows plus one for a header okay and so that's what this does now the next is we need to get the header in here alright but but we don't have the header right where's the header what I've done is I've just put in some simple labels on the right if you'll see here's our invoice header all I've done is taken this information just put it here and you'll want to hide this right in your own thing in your own workbook you'll hide it okay put it somewhere where you know anywhere the old my suggestion is don't put it low if you put it down here and you're inserting the rows if you put it down here and you start inserting rows it's not going to be row you know 11 or 12 because as you insert rows so make sure you put it above Row 5 or put it on another sheet is even better okay you can put it on another sheet that's okay just make sure it's on row 5 or above because as we expand these rows that road numbers change and we need to know what row these headers are on okay all right so make sure you didn't do that I did it yep that's why I learned so you'll want to go to where were we oh so we insert the header so all we're doing is saying they H and the active row plus 1 right active row plus 1 that's the row we want into the header and where's the header it's u3 through z3 okay our headers on u3 through z3 okay so all we're doing is copying those values remember we don't want to copy the format so the formatting is already taken care of through our conditional formatting so all we're doing is pasting the values as soon as the values get placed and as soon as we place that I for invoice right and as soon as we we place that it's gonna take care of itself so we don't have to worry about that and as you can see I've included the header item IH right that's that's gonna help us determine I've included those headers here so when we paste it in automatically it's pasted here and then our conditional formatting is going to be automatic all right and next up on the line of code we have the ability we wanted to so we're gonna add in the header and once we add in the header it's necessarily gonna be justified right it's gonna be based on justified these so what we want to do is I wanted to Center I wanted to make sure these header was in the center so I add a line of code that says this will justify I just take that one single header row and I give it a horizontal alignment of Center okay so that's what that line it goes it just centers the header centers all the text matter the next line of code is let's go ahead and add in some notes on that add invoices okay so the next line of code is gonna say H and the active row plus two right okay so that's H here right and the active row remember active row is still that first row plus two so we're starting at the second row plus all of the what I want to do is I want to add in all so it's gonna start here right start here start plus 2 all the way to L and the active row plus 1 plus the invoice quantity okay so basically what I'm doing is I'm defining this range right here okay I'm defining this specific range and I was saying in this range something right and what is that something well in that particular range I want that to equal sheet to a c4 and do this so let's go over that sheet to a c4 okay starting at invoice a c4 and what do I want it to go I wanted to go all the way to AG and the last row and we've defined that last row right so a c2 AG and the last filter row so basically I'm saying put this data right place it right here okay that's all I'm saying with that one line of code places steady here we haven't quite entered this yet okay you but we'll do that in the next row now we need to know what types of these we know that these are invoices right these are important for coloring if we take one of these out right you see it's gonna right you see how the colors are dependent on that you see that so those eyes are important that helps us that helps us tell us what color you know what colors should go there so it's very important that's how we've used to color code it so we're saying the next row is M right basically that same rate M from the active row all the way to M just add an ID or so basically all I've said is M through this make those I okay so that we can properly color those cells and probably label them next up we want to to mark line as invoice okay so the next up on the G right and the active row we want to make it here so we've done that let's go ahead and take a look at that we want to add the plus here because we want to be able to expand these so G right we want to add this so that way we can expand it right so all I've done is adding the plus sign which will tell us tell to use it that they can expand that so mark line is invoice we'll put this to expand expand payments a little bit more clear payments okay for payments and so you can expand that and the next tide of MS will next them we also have to format these cells as you can see the main table format it is basically text you know general formats but and this isn't is a dollar amount right so if we don't format these are gonna be dollar amounts right if I do let's go let me show you without that line of code okay let me let's comment this item out okay and comment this item out okay so let's take a look at what this looks like when we when we add a row okay look the invoice is a dollar amount which we don't want okay this this looks okay but you know it's it's not always I think before maybe not on all roasts because I know some rows it's necessarily look this one's on the left this one's on the right so it's important to format these properly okay and this definitely is not going to work so we need to know hey this is not it we need to tell Excel this is not a dollar amount there should be an invoice right or general right we basically says hey this should be not accounting we need a general right so that's what these two lines of code do okay know and comment that out that's what I didn't that's why it was working right so let me let me do that again let me comment this one out just so you can see alright so when we expand right there we go now you can see it's that's not right okay it should not be that because that's formatted for phone numbers right so it's not going to work so the idea is we need to just set these two these two rows set the format's correctly okay set one's for amount and one for invoice number invoices general okay the amounts is zero you can set this to what you can you can change the currency here no problem you know if you like you know what not using dollars okay so that's the reason why we've used two lines to format this because basically we have a different data type it's the same column but at different data types we'll make sure we format that accordingly and that's it that is all that is required to do the expand and now why don't we go ahead and go over what it's taking to basically when I reduce it you know or when I hide it but these are not hidden rows okay if we were some people say oh well you can use hidden rows but if you have a table of 1,000 or 10,000 you cannot use hidden rows it's way too much data and it would be way too slow it's just simply unnecessary when you can use this right this way so hidden rows and I know Excel has the ability to expand right you have the ability to expand and delete but that's also cumbersome and doesn't look good so we can also I know Excel has grouping where you can use grouping here but that also is not a good solution this is a better solution because it's inherently just like a software application and that's what we were trying to achieve and this is much more user-friendly so that's it so the next up we have hide invoices basically what we want to do is we don't really want to hide them but it we're gonna actually all we're going to be doing but the code is deleting these rows okay just deleting those rows only so to do that I say okay oh I want to delete these rows but I only want to delete these rows how do we know which rows to delete when we click on here we want to delete it when we click on here we want to insert it okay so we want to delete these rows so that's what this little macro is doing once again we're determining what the active row is and next we need to get the last invoice row okay in this code here what we're doing is we're offsetting okay one row down and one row to the left right if it was a plus one it would be one row to the right okay one column excuse me one column to the left and one row down so what I want is saying is okay one one row down one column to the left that's here if this is the active cell okay if this is the active cell one row down one column to left that's the offset what I want is I want to know how many rows here what is the next I want to know what is the next cell with a value in because that's going to be the limit okay so what this is it's going to tell us the last row let's just say in this case it is 21 right so in this case that number is 21 but I don't want 20 because I don't want to delete that okay so I want to leave one less which is minus 1 okay so now we're going to say the active row plus 1 the active row is still this row plus 1 which is this one all the way to this row minus 1 which basically is going to be these rows right here right this one delete those rows that from this road to the road delete so that's how we've defined it okay so we're saying this one we want to change it back to a plus okay change it back to a plus and delete these rows all right that's all we're doing here that's very simple amount of code there so that's that's how we delete the rows because it's simple and if we want to expand again just do it it's extremely user friendly and now with payment macros it's exactly the same thing except with payments there's no difference when we're expanding payments we're doing the same thing right we are putting an invoice number in right we're getting the invoice putting the invoice in going through all of the payment data until the last row okay we're putting the invoice number here we're running a filter okay we're finding the last row of the filter we know the first row we're finding last row we're and we're going to copy in we don't need this when we know what customer we know an invoice we don't need the customer name but we want the payment date we want the payment amount and we want the payment type okay so we're going to copy that three columns of information we're going to copy it right in here and before we do that we're gonna grab our header row from here okay including the little use for conditional formatting the value we use for conditional formatting we're gonna paste that right in here and you'll notice there's a row skip there's a row missing calling missing that we're not using here as well here as well okay also here so all we do is paste this entire thing in paste it right here with the code grab the values from the advanced filter paste them right here then we place the peas in there and then there's no other expand so there's nothing here so then all we do is we place DP which stands for payments and that's going to customize the row and that's what we've done in this macro here it's the same thing we've done all the same thing we've gotten the active row we've determined what invoice number is we are getting the last row let me see this it should be payments okay the last row of the payments then we are clearing any previous filters from the payments we are taking the invoice number and we're putting it in a b2 that's how we get the filter alright we're putting it here putting the invoice number that's how we get the filter we are then running our advanced filter with this line getting the last row of that filter okay if for some reason are no payments we're gonna skip all of this is saying if the last filter is less than four if the last filter is less than this okay the last row is less than line four we're going to skip we don't need that okay we're gonna take the active cell value and change it to - right active cell we want we want this change to a - here actually it would be here here right here want this change to a - four payments and then we're gonna shift the entire cells down write the number by the number of payments that payment quantity the number of payments okay and we're going to add in the payment header or justifying it we're gonna add in the payment data with this wrote just basically copying over those filters we're gonna mark this line with a P alright we're gonna mark it with a P so it can properly color it and then we're gonna format right let's take a look let's go ahead and paste this we're going to format we don't need this row that was from previous two let's go ahead and get rid of that we only need to format the amounts because they're all they're all amounts here right we only need to format the amounts here these dates remain the same so we only need to format J okay okay okay in that case and actually should be J let's go ahead and change that to j j here j j here so j j - j it's only one column so that's correct okay J - J right only one column this doesn't need to be formatted generals fine and then that's it and then we format it there's nothing else to it and the same thing with the high payments we've gone ahead and just determined what with the last row is and in this case in this case we're gonna use this column here to determine let's see we are going to use active cell the offset one row down we can use the existing row we're not offsetting any column here okay one row down to count them that means we're here remember this is our active cell one called down we want to count the blanks here we're counting the blanks until the next plus right because when we want to minimize it we only want to delete the rows in the middle nothing else and what another feature I like is if if we hide this it's gonna it's going to hide everything I love that and so it's really nice if you've expanded a lot of them you know and you want to see all the invoices you don't need to go hide each one you can just hide the customer because remember it's gonna pull all of those it's gonna delete them all right then delete them all because it uses disk all right so that's unique and it does that all right that's pretty much it so we've hidden the payments and I think that is it I think you guys are going to really enjoy this one it's really simple once you get the process down once you get the conditional the conditional formatting can be a little bit complex but once you get them down it's it's really amazing you can drill down any type of data is extremely fast and I hope you found this helpful if you have not already please join our group over at Excel for freelancers group and as always if you like this video please please share it thank you very much
Info
Channel: Excel For Freelancers
Views: 113,144
Rating: 4.9487181 out of 5
Keywords: Microsoft Excel Drill Down Data, Drill Down Data in Excel, Drill Down in Excel, Excel Drill Down Data, Excel Data Levels, How To Drill Down Excel Data
Id: sKOpTOTbPSI
Channel Id: undefined
Length: 40min 59sec (2459 seconds)
Published: Tue Oct 24 2017
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.