1. R

    Replacing cell contents with the lookup value of that cell

    I'm at a point where i'm bringing in two columns with values (city and county) and i've got a lookup sheet where the value of the state - Say Michigan (or MI) is 45 for example and the county is 13. I'm inputting MI in to the cell but would like for it to somehow reflect 45. I'm wondering if i...
  2. F

    Selecting pictures within highlighted cells

    Hi, I’m trying to delete a picture within a certain number of highlighted cells. I’m trying to do this in VBA and every suggested code I’ve tried doesn’t work or requires specific cells to be selected however I’m highlighting the cells via ActiveCell.Offset codes. The sort of thing I’m after...
  3. Jyggalag

    Remove weird borders from Excel cell?

    Hi all, I currently have an excel worksheet with this information: Apologize for blurring out all the information. However, there are a bunch of weird borders around some of my cells that popped up when I started copy pasting data way back. Now, no matter what I do by filtering with "no...
  4. T

    Go To Cells That Dont Match From Table

    Hi Everyone, I was trying to make a VBA code that would compare a list on a page "Locations", and go through all of the other sheets comparing a column in these sheets to see if there is a match or not. If there was no match, ignoring blanks, the VBA code would go to the cells where the match...
  5. E

    Box parts of text within cell

    I would like to box parts of text within a cell. I know it is possible to format the font of partial cell contents but is it possible to box it. I have attached a picture of what i would like but in just one cell. using Office 365
  6. V

    Trying to use selection in a listbox to resize a selection of data

    I am trying to use a listbox selection to lift only a small segment of the data out of the source of a listbox. I am trying to use the cells argument to pint point the starting spot and then resizing the selection to pull data into another part of the workbook. Unfortunately the resize argument...
  7. H

    Macro to move cells from one column to another column based on value from cell (Calendar)

    Hi, I have just got a hang of macro but need some help with coding in VBA! I have a calendar with a lot of different activities placed in different cells. Let's pretend that my activities are A,B,C. The cells in the calendar (workbook A) will be externally referenced with data (dates) from...
  8. S

    =IF statement assistance

    Hi, I am hoping you could assist me with a formula I need. K2 has a drop down list with the following options; 12 month nomination or 2 year review. K36 needs to be able to calculated based on the option selected above. e.g if 12 month nomination is selected then K36 needs to divide K35 by...
  9. L

    Power query % help

    Good morning, I am writing to you because I am completely blocked ! I have an array with formulas in Power Query ! The principle is simple : Get the difference between "cash buy (achat comptant)" and "cash sell(vente comptant)" values ! There is a file in history and a graph. I would like to...
  10. J

    Macro Help!

    Hi I'm trying to create a Macro so from my worksheet by pressing a button it will export it as a PDF, but then save it based on 3 cell Values, C4, C6 & C8. C4 is a name C6 is a name C8 is a date I'm wanting it to save to a specific file location to: C:\Users\Vector\Google Drive\H_O...
  11. P

    How to fill Filtered Cells with data??

    Hi everyone, I am trying to use to populate the "AD" column fields (filtered by rows that contain data) with the word "SENT". I can't seem to manage to fill the correct cells due to filtering. "SENT" needs to be populated in the AD column in the cell where there is filtered data also needs to...
  12. Y

    How to delete data from Non colored/Highlights Cell from excel?

    Hi There I am working on big excel , where i have highlighted few cell where which need to be uploaded and rest of data which in non Highlighted should be deleted. This Data has 300 Column and 10000 Rows Any help how to delete the data from non highlighted cells.
  13. D

    Help me understand my VBA code please (easy) - thanks!

    Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...
  14. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  15. C

    Data Validation CAPS and LIMIT

    Is there a way to set a Data Validation to CAPS and LIMIT meaning I'm using Excel, Data Validation, Custom, =AND(EXACT(A3,UPPER(A3)),ISTEXT(A3)) this makes everything CAP. But I also want to limit how many charters allowed in this area meaning 10 or less... so far I figured out how to do one...
  16. T

    Delete Boxes in cell?

    Hello! How do I delete boxes that are input into a cell?
  17. D

    If two cells are different

    I paste in a number in a cell that is linked to cell I4 (so that changes I4 cell's number) Then I paste the same number from a different location in another cell that is linked to cell E4. So that both cells stay the same all the time. Sometimes I do not paste in the cell that shows up in I4 or...
  18. N

    Excel hyperlink to scroll to specific section of active sheet.

    I know you can link directly to a cell pretty easily with an image in excel, but what if I want it to have the specified cell show AT THE TOP of the sheet? What happens now, is the hyperlink does take me to a specific cell, but it scrolls to the bottom of the sheet. I would like to have the...
  19. T

    Move names into a text box and pushing data back

    Hi Everyone So I need to get some names and make userform inputs so heres what i need, I have 5 Cells with headers and 5 cells which need readings I have userform1 I want to take userform1 and Place the headers from Cells A10,C10,E10,G10,I10 to header boxes Below the header boxes I have Input...
  20. T

    Calculating a double percentage discount

    This is fairly difficult to explain. I want a spreadsheet to calculate 50% of the total and then calculate 25% of that 50%. This should be output as the total amount discounted and then as the total payable in another cell. For example, the total is £2500.00. 50% reduction is £1250.00. 25% of...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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