1. M

    Deep question regarding IF function and everything else I want it to do

    Hello :) How can I get a cell to say, "Over Budget" in the BAD STYLE (red background, dark red text) if SUM of two cells is over value of another... and also to say, "Ok" in GOOD style (green background, dark green text) if SUM of two cells is equal to or under value of another??? Picture...
  2. M

    VBA, copy data into new sheets. Please can someone help a newbie

    Hi im very new to VBA, my boss has asked me to do something I have very little experience in in a short amount of time :( I have a large data set exported from a simulation software which looks like this: 5 5 0 -3.34384 45000.55 0.109103 -3.23011 45000.2 0.109103 0.017424 33.0513077...
  3. N

    Help with VBA - Changing column headers?

    So I am trying to use this macro. Basically I want to sort column W ascending, then use the formula "=W2*-1" in column X, delete all values in column X that equal zero and W is blank, then copy and paste the values from column X to column I. When I do this it seems to work but it is changing...
  4. E

    PowerQuery question: how to make my 2nd column become my top row (or even the header row)?

    Hello, I'm new to PowerQuery and loving it so far. I have some ETF prices I pulled from Yahoo Finance and pulled into PowerQuery. I have manipulated it into the following (Table 1): I want the data to look like the following (Table 2). Essentially, I want the "Ticker" column to instead by...
  5. S

    Sending email based on cell value

    Hello, First of all, I am still new to VBA and more complex excel coding, so I'm learning by doing, searching forums and tutorials, stitching together bits and pieces of code I need. However, I ran into a dead end and would need help. Basically, what I'm trying to do: I have a project to sort...
  6. D

    How to copy over only new rows

    I have a report which I have to update from time to time. The combination (Concat) of the values from two columns is unique, so I have a "code" which identifies the row. So, for the example: Sheet 1 has 1000 rows, Sheet 2 has 1200 (The previous 1000 are included in this) I want to copy over to...
  7. N

    Subtracting if drop down box says "Yes"

    Hi all, I would like some help with an excel spreadsheet I am creating to keep track of my overtime at work. As seen in the attached file, Column D is the overtime that I worked on that day. Column E is a dropdown box (Yes,No) which identifies if I have used those overtime hours (Eg. On X...
  8. J

    Calculate Number of Days Overdue using either column, with one taking precedence over the other.

    Hello, my 2nd post here and I'm pulling hair on another stuck Excel sheet. I've got an Excel sheet prepared however just couldn't upload it here. Actually just one question however with several conditions so I'm putting them into bullet points numbered below: 1. For each document, how do I...
  9. D

    Converting data extract to individual line items

    Hi, I'm trying to build a macro with the following data... What I want to do is to transform the above into this: Basically, what I'm trying to accomplish is to take the data set and transform it into individual line items. Account numbers, names, and risk types repeat, but LOB and Net...
  10. K

    How to show selected menu in slicer to other cell ??? (Like a Refrence Indication)

    @ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference
  11. A

    Separating a part of the string from it's three first characters

    I am trying to separate a string from it's three initial characters. Example: 100345-123-2455 100 345-123-2455 345-123-544444 345 123-544444 I have figured out, with help, how to separate the three characters, using the function...
  12. A

    Taking first 3 characters from a cell A1 and comparing it to a range. If there's a match, the three characters from A1 go to B1.

    I am trying to compare the first three characters in A1 with a range from C1 to C100. If there is a match, the first three characters would copy to B1.
  13. M

    Resize Every Table Of my Powerpoint Document

    Guys I really need some help. I have tons of tables in a powerpoint document. Some are 2 in x 2 in and some are 3.5 x 3.5 in. I need to resize only the 3.5x3.5 tables to a size of 2.8x2.8 I know this can be done with some easy vba code, but I don't possess the knowledge for it. I know it has to...
  14. J

    Calculate cells edited in last 7 days

    Hello, To give a bit of background: I'm one of the editors on a website currently hiring writers. We're creating a spreadsheet to track the content the writers create and when they created it. I want to create a count for the number of blog posts they've written in the last 7 days, if that's...
  15. D

    Measure variance over week period

    Im having a lot of trouble working with this formula, what im trying to get is, if the week number is even, then get the difference compared with two weeks ago (current- twoweek), else (current 53-previous 52), the thing is with other measures works perfect, but with this particular measure is...
  16. A

    Insert Row based on Cell contents and copy data from Row above and paste data from another tab

    Bit of a complicated one here, i will try to explain best as i can Main Sheet Day Route Reference Shift Start Depot Name Customer ID Customer Name Customer Address Postcode Arrival Time Depart Time Product Name Call Type Order Details 1 Tue 100/011 08:19 PPARK DEPOT 08:51 09:21 C...
  17. D

    Macro inserts column in wrong place

    Hello, I usually code macro's in Excel but I need the process automated. I tried to record a macro but for some reason it goes horribly wrong. This is what I want it to do (and what I recorded): - Insert a column in a table - Do a VLOOKUP - Do this for all remaining rows When I recorded the...
  18. C

    Beginner Question - Sheets I'm editing become inactive until I click another sheet or workbook (Intermittent)

    Hi there, everyone! I just registered to the forum to ask about something that has been mildly inconvenient for a few months now. I'm a bit of a beginner, but I've committed to getting better at using Excel going forward (including starting a training course). So, here's what I've got: I...
  19. S

    Lookup query

    Hi. In Sheet0 I have columns A to O populated with travel data. E contains email address I contains departure date L contains country B has the formula =IF(COUNTIFS(TA!C:C,E2,TA!E:E,"*"&L2&"*",TA!D:D,"<="&I2+7,TA!D:D,">="&I2-7)>0,"yes","no") which looks to see if there is a corresponding value...
  20. D

    Inserting table column name into excel formula

    I got a question answered and then I posted another question in the same thread. I forgot I needed to post new questions in new threads. I get an error with trying to insert the following formula into a cell in vba. .Range("M11").Formula = "=IF([@[Wait Time/Hrs]]<3,3,[@[Wait Time/Hrs]])" The...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back