area

Hi, i need to add only filtered area if criteria is met.... I am adding quantity of sales by salesperson. B2 is salesperson name H2 is the total quantity sold in filtered area. This is the cell i need calculated. C13 to C1000 is salesperson name D13 to D1000 is quantity sold for each sale...

I want to write a sentence only using formulas, for instance, I am comparing many things about a home. I would like to say how things are similar, superior and inferior all in the same sentence if it applies. My version of excel is not really excel at all but a spreadsheet built into my software...

Hi I have a chart that displays 2 sets of data perfectly in the Line Chart format. However, when I change one of them to the Area Chart format, the points in the Area Chart display either nonsensical data or point numbers. Is there a simple reason for this? Apologies for not posting the...

Hello, I have a spreadsheet with two columns, one has an area name in and the second column has the branch name. Some areas could have 5 branches and some could have 15 branches. I would like to format each row based on the area name. So if its area 1 then say a light grey, if area 2 then a...

Hi, I have a dynamic area under B14:H14, which I only want to add rows to via macro input and not limit via cell protection. Is there a way to use Worksheet_Change to detect if a user enters a value in a defined area and prevent cell value edit? Tried to search for answer, but must typing...

Hello Everyone! I'm trying to fill out text area in ServiceNow ticketing tool using VBA, but sadly I've been stuck for a couple of days now.. So far I've been successfully using this method and this exact (excluding site's tittle and text area ID) code to fill out text area in different...

Hey all, thanks for looking at my question. What I'm trying to do is create a VB program for my budget. In my budget, I have two areas for data. One area shows a running total of my current allowance & expenses for any category, and the other area is where I enter each individual expense...

Hello everyone, I'm working with a line chart that (dates on the X axis and some series of data in the Y axis), when i add new columns of data (new dates with data), the x axis extends, but the chart area does not "adapt" to it, so the new part of the chart with the new data doesn't "fit" the...

I have an image open in a form. The user needs to select a section of the image by drawing a rectangle and zoom to that area. I've got it working with scroll bars and command buttons but it's not elegant. A lot of clicking and sliding. I could do it using Shapes etc but am hoping there is...

Hi all. Im trying to work out how many staff i have working between two times and also based on the area they work in. Col A has staff names, Col B has the area they work in, C&D have the start stop time The times the staff are working between are in col C&D and i wish to break them down by...

Hello Everyone, I have a question about Microsoft Excel 2016. What is the correct way to change the color of the side wall, plot area, and floor of the chart? Any advice on that? I will highly appreciate your response. Thanks to all inputs! Best Regards!

Hi, I'd appreciate some help please in doing the following. I have a spreadsheet set up as follows: Column A = question number Column B = question text Columns C to BFW = a list of 1,528 store numbers in row 1 and their corresponding area codes in row 2 There are approx. 80 different area...

I am having an issue with a lot of hands in the pot on the workbook I am working with. One area is the phone number area. Everyone puts it in different and I need it to show up in one format even if it is copied and pasted over with the 123 pasted option. When pasting with that option it takes...

I am looking to set up a Print Area on a sheet that will remain even when I delete columns. Currently my print area is A1:G24 and when I delete columns A and B, my print area becomes A1:E24. I would like to set up the print area so when columns within that range are deleted, the data that moves...

I would be grateful to receive a steer as to the formula to use, where I have a list, that involves 20 names, in 5 different areas identified by an abbreviated label, and those names fall into either T or C types which alter frequently although the area and name does not. I need to produce a...

Hi, I am a novice in VBA but my work is demanding more and more. So my issue is that i am trying to save multiple worksheets in one PDF but when i open the PDF, the output is ignoring my customed print area. I wanted to know how can i deflect that so that both my printed hardcopy and my saved...

So in my spreadsheet, column A is populated with three digit numbers down to row 100. These numbers are from specific areas on a map im working on. The area numbers are going to be temporarily changed, so coloumn B is populated with the new area numbers, for the new map. Essectially, I want to...

Hello, i am working on a sheet the generates a report in a friendly format and prints it the way this works is by having a unhidden area that the user generates information for some of this information is copied over to a hidden area which is the area that is printed when running the macro...

Hi There, Relatively new to Excel. I am trying to create a table with colour bars. When I highlight the area that I want to be formatted as a table, it simply won't format, or only a few bars will fill with color and the rest won't format at all. How can I format a table with color bars...

Hi Experts. I have data in sheet1 <tbody> AREA SKU JAN Feb Mar .. A 1001 10 50 10 B 1001 20 40 20 C 1002 30 30 30 A 1004 40 20 40 B 1003 50 10 50 </tbody> Sheet 2 Summary <tbody> AREA MONTH SKU VALUE A Jan 1001 10 </tbody> I need formula in cell D1 for SKU 1001...