stuck

I've been messing around with userforms and macros for a little bit but frankly I'm lost when I tried this one. I have pretty basic yes/no popups and have done macros to insert data into the next empty row, that sort of thing. Anyways. I have a userform that I am making using comboboxes and...

=AND(K4,L4<0,"", SUM(K4-L4)) All I get is ' value ' message

Can someone help me solve this.. I'm stuck :(

Using Excel 2013 If Im runing the code below in a for loop then comb works fine. For Each c In Range("B2:B10") 'ersätt range nr = Right(c, 3) If nr = 980 Then unr = c.Offset(0, -1) se = c.Offset(0, 0) comb = unr & " Sektion" & " " & se...

Hi All I'm getting stuck on a friday afternoon, which is never a good time to get stuck. I have a worksheet (Sheet1) with loads of info in it that I'm trying to produce a regular report from on Sheet2. What I'm trying to do I can almost get to work. I want to get all the info from Sheet1...

Hi, For years I've been dragging and dropping formulas when i should of being using an array formula. However i'm stuck trying to make this a working array formula: =ARRAYFORMULA(IF(ISBLANK(A2),"",IF(G2<TODAY(),"passed date",IF(G2<TODAY()+30,"Due In 30 Days","current")))) I'd also like to...

Hi All, I have two sheets and one called Week1. This formula works for me from the other sheet: =INDEX(Week1!$G$3:$G$50,MATCH($C6,Week1!$B$3:$B$50,0)) However, I would like to replace Week1 in the formula with a text string I type say in cell A1. This is where I get stuck. Can someone shed...

Hello I've been trying to figure out a solution to this for a few days but i'm completely stuck! I have a table of data which contains the sources (6370) for 6370 separate dropdowns. Each source corresponds to a tutor and date. There are 14 tutors and 455 dates hence the 6370 separate...

Hi guys, I'm currently working & learning to play with VBA and create certain command button and userforms to ease some of the job. So I've been working on this forms and get stuck with "Compile Error: Method or data member not found" The idea is to have 1 command button on the 1st userform...

I am looking to make a button on a protected sheet and hook it up to a macro opens a box to enter a password that unhides row then protects the sheet again. the ultimate goal is to have 4 of these buttons all with different passwords that unhides only the salary information of a department. I...

Hi, I need help with an excel formula. I have 2 lists, like: <tbody> A X B Y C Z </tbody> And I need to find all possible TWO pairs, without repeating any cell, like: AX + BY AX + BZ AX + CY AX + CZ AY + BX AY + BZ AY + CX AY + CZ ... I did get all possible pairs, like AX, AY, AZ, BX...

Good night on you! Sitting with tight deadline and trying to help colleague who got stuck. It is about compiling economic information about 500 companies and contacts. However, in order for the contacts to be able to imported to a database later, they must be set up differently than the...

Hi, I am trying to #1 ) highlight the top 3 values in cell range $B$3:$B$22 and #2 ) Red = the 1st best value, Green = 2nd best value and Yellow would be 3rd best value. I am stuck. I tried the Conditional Formatting menu and am completely confused. Please help! :)

Alright, I'm having hard time even getting started on this one. My end goal is to have an excel database that will list records I'm performing from my county's land record records. On the website I am running a search with two parameters, record type and date range, the search returns around...

Hi, I have Excel 2016 (365 ProPlus). As soon as I start to change a cell's content it freezes. I then close it from the task manager, open it in Safe Mode and it works fine. I turned off all the Addins, but it didn't help. Also tried the Graphic accelerator on/off. I run Windows 10 and have no...

Hi I have a 10 page excel document, and pages 1-5 are tables that have information that will be fed in via userforms from the user(this is a process flow document, 1-5 are process instructions). Near the end of the document I need to have tables to log dimensional data taken by an operator, so...

I have been stumped by this issue for the past few days trying to sum up the rows based on this MAXX formula in PowerPivot. highest Sched Prod Time (min):=MAXX(summarize(Stations,Stations[Station],"Duration1",IF(sum([prdDur])*2<[Station time In Cycle],[Station time In...

Afternoon all, I have a challenge to identify the changes over time with customers moving through our sales process. The data looks like this: Week 1 Week 2 Week 3 Week 4 Customer Customer Customer Customer 2621892115 2577549317 2633689381 2633689381...

Hey Ive came up stuck. I have a table of answers on "Input" sheet which have the same value im looking up but i need in my labels to show different answers in each. for example my table is 78214 09/06/2015 MABEY HIRE LIMITED TRANSPORT/DELIVERY CHARGE INCL 78214 09/06/2015 MABEY HIRE...

Hi all I have a problem that I’m stuck with and I cannot for the life of me come up with a formula that works! I have a data set that is duplicating on ID number as there is more than one expiry date per ID. I’m after a formula that would look up each ID number in column A but bring back the...