how to

Hello I am new in Excel and I would thank a lot if someone can help me. I wrote this code with linked dropdown lists in cells: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$S$4" Then Range("$T$4").Value = Empty End If If Target.Address = "$S$5" Then...

Hi Hope you can help me. I’m trying to create an excel data-entry form using VBA to capture data and -- when submitted -- paste the data onto a separate tab on the spreadsheet. This is what I have so far. This form will be used by my colleagues when they collect information from customers...

Hello. My data is structured as such below except I have hundreds of unique products. How can I tell how many items were purchased per product? My goal is to determine which products sold the most and how many units were purchased of each. Thanks in advance. Product How many purchased Apple...

How do I convert decimal dates into a format that shows the month and day? I have tried the formulas given on the internet, but they do not work for me, and I can't figure out why. =DATE(INT(A1),1,1)+MOD(A1,1)*365.25-1 gave 646481. =DATE(INT(A1), 1, 1)+MOD(A1,1)*(DATE(INT(A1)+1, 1...

I need help finding the count of unique encounters for data similar to the example below. A unique encounter = unique ID at a unique location receiving a unique service on a unique date by a unique provider. I need to be able to filter and run unique encounter counts based on those variables...

Cells in "SKU" column are the pasted value of cells in "SKU Formula" (concatenate) column. How do I get the "SKU" column (pasted value) to automatically update when a change is made to data in cells shown in SKU formula? <tbody> Collection Prefix Shape Size Supplier Color Code SKU Formula...

Hey Guys, New to the forum, but I have something tricky that I want to do in excel. I want to generate a part number based off a specific word input. For example <tbody> Titus 350FS 22 22 24x24 Lay In Std White No Screw Holes None None None None </tbody> = <tbody>...

Hi all, Just being trying to find out how to create a chart like to the one included in the link below which highlights a volume and price variance (PA to PB and VA to VB, highlighted in red and blue), im hoping to recreate this dynamically in excel. Could you advice how to create and what...

Hello, I am there new and I need your help :). My mother language isn´t english, but I try to do my best. I need to help with worksheets in the work. I wrote some data in Worksheet 1 bud there are really much informations, we need to make it smaller and "easier" that we can print it and show it...

Dear Experts, Can you please guide me how to make this kind of infographic in Excel or if it is not excel so what tool could be used to design one like such (attached)

Good morning. It's my first time seeking help here. I have an Excel spreadsheet which has attendance reports for all employees working in the company. I want to create a pie chart which shows the percentage of good attendance, late arrivals, leaving early and absences per person each week and...

In excel, you can track changes if you "share" a workbook. These changes appear like a comment in excel. I'm trying to export these comments via Adobe Acrobat, in a PDF. Instead I receive an error message, "Acrobat PDFMaker may not be able to convert comments and some links for shared...

Hi.. Someone please help me here. Example: In column A I have the below data, I want to apply filter to only get cells with ent and I don't want treatment and dentist. COLUMN A treatment for hair loss treatment for skin free treatment clinic best ent doctors top ent clinics clinics for ent...

Hello, I'm new here, and I hope someone can help me. I have an analysis equipment that measure the HP (horse power) consumpted by an electric motor every 20 seconds during 3-7 days. So, I have a between 13,000 and 30,000 points in one column. The motor have 4 stages (lets use a 100hp motor)...

So I only recently have started using excel so I'm very basic at it. So naturally I'm working in a project that requires extensive knowledge of it. I work as an IT help desk at corporate for a medical group. I have decided to take the 100,000 tickets we have and export them to excel to create a...

Hello. I've got a table that I need to know three parameters before I can consulte them, e.g I need to know the: -diameter - height - time exposure to fire Only after I know that I can get the value that I need that it is on the table. When I only need to know 2 things before consulte...

Hello, We run a MMA company out of Michigan and I had a question on how to set up a spreadsheet to help with ticket figuring. Here is the scenario I need help with. We sell the tickets for $20. Tickets are signed out to fighters and they sell them to make a cut. If they sell 1 ticket through...

Hi all: I have a custom function that count a range of cells by a specific color that works great, but i need to modify it, so it doesn't count more than one cell in a row.:confused: This is the code: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)' This...

Need a formula that'll allow me to add days to a date and exclude weekends as well as federal holidays in the process. Example: If my date is March 25th, 2014 and I need to add 5 business days to it. The result I'm looking for is April 2, 2014 (not adding the weekends, March 29 and 30; also...

plz anyone do help me:cry:....its very urgent... I created a macro for creating Pivot table. But when i Run it, it shows Error. Every time i have new data with changed Data range with different sheet range.I want to create macro such that it can be used in general for creating Pivot Table in new...