domestic

I have a central tab called "Summaries". From this tab, I'd like to assign a macro to a button that separates out new worksheets based on titles starting in cell B5, with the name of the tabs matching the titles. Sometimes, the number of titles can vary but they will always begin in cell B5. In...

Hi All, I am trying to create a formula to have data populated from a drop down menu but I am unable to get it to work correctly. <colgroup><col><col><col><col span="2"></colgroup><tbody> Depending on which department you select, the data should automatically populate, but I am not sure...

Hello, I need to extract a summary from a large data set (I have mentioned an example). The summary should add up the hours based on location, date and service. Some of the services are to be combined, in the example, you will notice that the hours for Domestic RRD and CTL RRD are added...

Hello! I am having some trouble that I am hoping to get some assistance. =COUNTIFS(H11:H1000,Q4,I11:I1000,W3) I need to calculate that if UK(Q4) appears in column H and then also count if 9 different options appear in column I. Currently my formula is only for 1 of these options (W3) as I...

hello, I want to transform the first table to the second: ¿can you help/guide me? <colgroup><col span="3"><col span="2"></colgroup><tbody> Segment Channel Product.ID jan feb Domestic 1 23 5 1 Domestic 1 54 1 5 Online 2 43 34 5 Segment Channel Product.ID Month...