answered

I have a set of data, a subset provided in the mini sheet, that I want to do a calculation for the area in gray/red using a formula that I can drag across columns and rows to match the full data set. Cells E1:P1 and D2:D13 are years. Cells A2:A13 are years. Cells B2:B13 are datapoints...

Good Afternoon, this should be easy. I just need to take the cell value in column 14 of active cell row and add 1 in the cell below. I've scoured the internet and cant't find anything similar enough for me to figure it out. It will happen with a button click that will have other functions.

I have a workbook I enter data and have to wait for product approval before sending to a different workbook that everyone else looks at that has all the approved products. Right now I have 2 different buttons to use to send the entire row of selected cell to other workbook based on the product...

I am wondering if anyone has any suggestions to assist me with my problem. Below is a sample of what my data looks like. A B C D E F G H I J 62 Shop 456.20 NO YES NA NA NA Overtime 63 Check 8756.00 YES NA...

I have a large list of items that need filtered using 2 criteria. I currently have: q1 = sh2.Range("B11").Value If q1 = "Y" Then sh1.Range("A2").AutoFilter 10, "Y" ElseIf q1 = "N" Then sh1.Range("A2").AutoFilter 10, "N" End If What I need it to do is if cell B11 on sheet 1 is answered with "N"...

I was just wondering if all questions get answered on this forum. I asked a question yesterday under the Excel questions, but it hasn't been answered but my other threads I asked same day were. Please don't take this the wrong way, I'm very grateful for everything you all have provided, all...

Hi There, We are trying to use excel in several ways. We have a survey that our staff fill out, a series of questions some are answered yes or no, some are answered on a scale from 1 to 5. The questions are different for each role. We currently have a workbook with a sheet for each role. The...

How can I get the survey results below shown as second table below? Idea is to capture names of associates who answered "1" in a single cell. Raw data: <tbody> question 1 question 2 question3 Associate1 1 1 2 Associate2<strike></strike> 3 1 1 Associate3 2 2 2 Associate4 3 3 3...

Hello Everyone, I am having difficulty in identifying and highlighting exact number matches between two lists. If this questions has answered could someone point me to the appropriate forum post ? Thank you everyone for your time...

I'm working with a survey dataset that needs to be aggregated for analysis purposes. Right now I'm looking to identify all instances where different respondents answered a question with the same numeric answer from a multiple choice list, the number of respondents who answered with the same...

Hi everyone, First of all, great site. I've had sooo many questions answered here that I can't thank enough. But, for the first time after looking everywhere, there is one i can't seem to have answered. I'm an engineer and I've used excel macros for a very long time to automate my workflow or...

Hey all, I want to calculate how many calls is needed (answered in Service Level column C) to reach the target (column G). In below example this would be 1156, not taking in account that calls are abandoned. So incoming calls and answered calls will increase. How can is calculate this using the...

I have a sheet, that pulls values from two workbooks to do a comparison. I'd like to make it more flexible, so I believe I need to use the INDIRECT function to set the filename as a varaible. Attempts to date, in C1 a file path A:\[file.xlsx]Sheet1 in A3 =INDIRECT("'"&C1&"'!B2") and various...

The data in my worksheet is being stored in the database as a timestamp even though it's a date. When i pull the data and copy it over i need a quick way to look through multiple sheets for a defined header or column and format it from timestamp to date. the below example does exactly that but...

Hello guys, I'm trying to create a code that has to be run manually. It should search for the word "total" in column A and clear the contents of the cells in columns K and L in the same row. I tried searching and using bits of others codes I saw here but I can't seem to find anything useful...

Hey Guys, I have some code: Public jan As Double Public feb As Double Public mar As Double Public apr As Double Public may As Double Public jun As Double Public jul As Double Public aug As Double Public sep As Double Public oct As Double Public nov As Double Public dec As Double Sub...