creating

I recorded a macro while creating pivot table fields and the coding is quite big. I am only showing a small portion of the coding. Is there a way to reduce this? With ActiveSheet.PivotTables("PivotTable1").PivotFields("Cost Center") .PivotItems("123744000").Visible = False...

I have created a simple Pivot Table & want to Sort the 'Sum of Total' Column from Highest to Lowest. Screenshot below https://ibb.co/iEP20U Is it possible to Sort on the Pivot Table or do i have do the Sort the raw data before creating the Pivot Table ? Thanks in Advance.

hey everyone im creating a simple task list that is seperated by days (Sunday through Saturday) 3 different task split between 3 different people beside the task there is a drop down menu for whoever is assigning tasks for the week - however though my question or problem im having is that im...

Hello Everyone, Would it be possible to create a circular progress bar? I'm well aware of creating a progress bar using form and label but I'm not sure it is feasible to do it in excel 2016 and display it in the userform.

Hello everyone, I have an issue with creating the formula for the range of negative numbers. I have a column that contains thousands of negative numbers, in my case, from C2:C5000. I need to create a formula that will filter all the numbers when value is higher than -18. (meaning when numbers...

does anyone has a VBA code for creating fishbone diagram?

Greetings Folks, I've been spending the past week or two learning Excel and Access from a service my employer has access too called Lynda. It seems great for people who are very novice like myself. I've completed a lot of the courses for basic understanding of Excel and Access with the goal...

Hi all, Please see the document attached. I basically need to figure out how to do the percentages. Thank you. EDIT Correct link: https://www.dropbox.com/s/gkqmefowfaxoirk/Version%202.xlsx?dl=0

I have a workbook that has over 25,000 contacts that includes Name - Email - Phone Number - Location - City - Role. I am currently using a indirect list validation to sort between Location - City - However Roles are not filtered by City - they are filtered by location... This leaves roles...

Hello, I am new at creating Loops in Access. I want create a new column for each new occurrence of a ID using a loop. If there is a better way to accomplish this I am open to ideas. Below is what I want to accomplish. Table A <tbody> ID Exception Id Exception Date ABC 55576 7/4/19...

Hello, I found a snippet of code that will loop through a folder and do a specific function (i.e. insert a formula). I am looking for one of the functions to be changing the extension from CSV to xlsx without creating a new workbook. Can any one share the line of code that will perform this...

I am creating a Masters golf tournament pool sheet and need to set up a web query for the scores. But every website I try to import only have the option (as indicated by small yellow box and arrow) at the very top left corner, which is the whole page. I wish to import just the leaderboard table...

Hi there, Just wondering how I would go about creating this button? The button has two options, 1 to either Print or 2 Print to PDF. I would need this to be recorded as a macro and then assign the button. So create a button and give it 2 options but how do I do this? Any help is...

Hi Whilst I am quite familiar with creating a list of controls and properties for a form by using code in the forms code module I cannot find a way of doing this for all forms. If I correct in thinking that the userforms collection only includes loaded forms do I have to load all forms and...

I have two formulas. But both of them are not working in the right way. the first formula is: =IF(COUNTIF(G31:G37,$E54),$F54,0) issue: It is not able to read a cells were inside are more than 1 letters. (E54=X) So the main problem that I have with this formula is that is not able to read a...

I know that I can refresh a worksheet by clicking on the refresh icon in the ribbon, or by pressing F9. What I'd like to do is to create a shape which is easily seen—my eyes ain't as young as they used to be—and activated with cursor and mouse click. Creating the shape is easy; please would...

I am creating a calendar with each month being it's own sheet. Each day is represented with a named range. I have a navigation sheet that I would like to be able to show today's named range on. I have nt been able to figure out a formula that will associate the name of the range with =today().

Hello guys. Writing here, hoping that someone can help me out. I have two formuls on "Sheet 1" that looks like this: =CONCATENATE(A13;",";B13;",";C13;",";D13;",";E13;",";F13;",";G13;",";H13;",";I13) =CONCATENATE(A14;",";B14;",";C14;",";D14;",";E14;",";F14;",";G14;",";H14;",";I14) I want ONE...

Hello everyone. My computer is Dell and I'm working with Office 10. I'd like to know how I can use a formula to subtract a larger number from a smaller one without creating a negative. For example: <tbody> <tbody> <tbody> 16 16 16 16 29 31 65 67 -13 -15 -49 -51 </tbody>...

Hi all I am quite new to VBA and have found a number of the posts on this board really helpful! I have come across a query I haven't been able to find an answer for though - I have 60 folders, each assigned to a different client, and within each of these is the same set of subfolders. I am...