area

Hello all, I got two comboboxes in my worksheet names cmbDepartment and cmbFilter. When a department is selected you can filter the department with cmbFilter. To fill cmbDepartment i filled in the ListFillRange. To populate cmbFilter i use the following code: Private Sub...

I have posted this before but the marco did not do what I needed. I would be so grateful if someone would help me. I process reports at my work while they are all different meaning different numbers of columns and rows of data and number of tabs etc. They each need to have three things before I...

Hi everyone, I have a problem for a userform which uses comboboxes. So basically I have column A with "area" items and column B with "process" items. I don't know how many different items I have in theses columns. But everytime you have an area, you have a process written next to it. I want a...

Hello I have distance in my data that I would like to categorise into radial areas (The cell containing the distance is AN2). For example 10 and under is Area 1, 10.1 to 15 is Area 2, 15.1 to 20 is Area 3, 20.1 to 25 is Area 4 and anything greater than 25 is Area 5. Any help would be greatly...

Good morning! I have created a pivot table (round of applause for me please!) I have added additional columns to the raw data but the data is not showing in the pivot after refreshing. I believe this is because the initial area of the pivot doesn't include my last column. Could you tell me...

Dear All Could you please advise a VBA code or Excel advanced functions to automatically shift entire rows from one area to another. What I mean by area - is that I have 3 areas with 3 different color depending on certain cells values or status of the row. So once a certain cell is updated...

My personal computer has a weird quirk where the area of a cell border that I can interact with to drag-and-drop or autofill is smaller than on every other computer I have used excel on. On other systems, when I click on a cell, I can easily click the border and drag the cell contents to...

Hi All, Im new here to bear with me on the newbness. My question is the following. I used to LOVE and use a lot this in Office 2011 for Mac I could move the "print line" with the drag of my mouse to resize the print area or the area to save a PDF. I upgraded to Office 2019 (ver. 16.19) and it...

Hi there, I have a workbook and each sheet has a different range set as the print area. Some are bigger than others but on the whole they are all pretty similar. I'd like to be able to set each page's print setup so that each 'print area' range fits to the width of the print paper (or PDF...

Can someone please help me with possibly an advanced macro. I process a bunch of different reports with different sizes, sometimes single tabs, sometimes multiple tabs, different rows or columns of data and different formatting etc. But every report I send has a few formatting requirements and I...

Hi everyone, I have made a stacked area graph which looks lovely but my x axis values don't start at zero aren't aligned with the axis ticks :( Does anyone know how to align? https://ibb.co/ceN1Nq Thanks:)

Can any one help me with a formula or macro to analyze dimensions? My column has many sizes listed, but I need to change it or mark in another column that it's too big fit in my area of 12.375x18.375. For instance, I have these sizes below, they would be marked too big cause they don't...

Hi, I have some data with column of town names (40k rows with around 500 unique towns). Is it possible to group the data by a geographical area i.e Northern or Southern area? Thanks for any help offered

Hello All, I am honestly not sure if this is possible in Excel, but I will throw it out there anyway in case someone has some thoughts! I would like to create a spreadsheet that will be used to keep track of information by week (i.e., week 1 data, week 2 data, etc.) over the course of a year...

Hi, looking for a shove in the right direction. I would like to have a graphical representation of a battery (224 individual cells) and what I would like to do is map the readings that will be in a separate table onto the cells so you can see for example "If an area of the battery is hot...

I'm trying to do a concatenate formula to combine all the categories from sheet 1 into one cell. The values in Sheet1 for categories would be a drop down list of blank, L, M, and H. In Sheet 2, if the category has a value, include it in part of the concatenate formula. Is an loaded IF statement...

If I have a Named-Range that has multiple areas, such as ... TempRange =Sheet1!$C$2:$C$4,Sheet1!$X$2:$X$4 And I want to get the 2nd Value in the 2nd Area, in this case ... Sheet1!$X3 Using the Named Range, How do I reference that cell in regular Excel formulas?

Hello everybody. I'm attempting to define an Excel area in which, in case of human typing, a macro has to run in order to recalculate automatically values in other cells. The process suggested by Microsoft, until a certain point, is ok...

Hello, I hope someone can help me with my question. I have a formula that resets an area to the formatting of a specific line: Sub Resetformatting () Range("B17:W17").Select Selection.Copy Range("B18:W468").Select Selection.PasteSpecial Paste:=xlPasteFormats...

I used to know how to do this but its slipped away from me.... On one sheet I have a number of cells which contain the code 'cc'.I want to get the sum of the values in the cells to the right of each one of the cells with cc in them. The cells are all contained within a certain area but not in...