spot

  1. R

    Compare Dates in Various Columns

    Hi There, How can I check to see if all rows in columns A, B, and C have the same dates and spot the rows where the dates are different in these columns? Thanks.
  2. D

    Insert a custom image

    I have code that puts an image in the right spot. Could someone help me with the code that allows you to insert your own image and put it in the same spot please? This is the code that puts the set image in the right spot. Sub cmdGarrettSig() Dim shp As Shape Set shp =...
  3. P

    Problem deleting rows in VB

    Morning, I have a code which should be deleting a selection of cells if the word does not start with LMK or DUB or ORK but it seems to delete it even if it does, can anyone spot the error of my ways please ? For i = LastRow To IRStartCell Step -1 K = Cells(i, 18) If K <> "DUB*" Or K <>...
  4. B

    Question on Filling Out Fantasy Roster

    Hello, I'm trying to build a fantasy baseball spreadsheet. I have a list of players that I'm hoping to fill in each roster spot for each team. The player's name is in Column B. The player's position is in Column C. On the same tab, I'd like to place each player into a roster spot which is...
  5. J

    Floating Task Bar Items

    Crap, I said Task Bar in the subject, but I really meant Quick Access Tool Bar. On Excel 2016, I have shortcut icons all along the Quick Access Toolbar. I have them sequenced from left to right in an order that makes them most usable for me. Lately, a couple of the icons have started floating...
  6. J

    Method 'Busy' of Object 'IWebBrowser 2' failed Error From Access

    I am at a loss...I cant find anything online to help figure out why I am getting this error message. I have used this VBA code before (located below) and now when I try to use I keep getting this error and cant move forward. The website opens and I can sign in but the coding is supposed to...
  7. A

    Rotating Parking List

    Hey, So, I'm trying to create a monthly parking list for my office. we got X employees, and 2 parking spots. I got 2 sheets: 1. Employee Details - List of employee names, list of license plate, and if the employee wishes to use the parking or not. 2. Results - A list that should be field with...
  8. S

    VLOOKUP external data

    Hello, I am trying to make a worksheet vlookup from another data source using the below. =VLOOKUP(C10,'C:\Users\scusk1\Desktop\Stephen\Archived Workbooks\[Driver Database Live.xlsx]iForm Data'!$1:$1048576,11,FALSE) Can anyone spot an error as it is returning NA Thanks Stephen
  9. K

    Need to use column and row label in formula

    In a spreadsheet I have I like to a column label and a row header in a formula. The formula looks like this: =+'[2018 GNC DC_.xlsx]JAN, 2018'!E4 The "GNC spot" I'd like to grab from the text in B27. In other rows there will be other text The "JAN spot" I'd like tp grab from the text in C26...
  10. E

    Averaging sub categories from the bottom up

    How can i average each lower level sub group and put its value in its upper level. ex Average all the numbers in E that are a 4 and place the result above in the 3 spot. Average all the numbers in E that are a 5 and place the result above in the 3 spot. Average all the numbers in E that are a 7...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top