wanting

  1. P

    Possible nested functions?

    Hi, I'm sure what I'm trying to achieve is easy but my brains not in gear today.... I have a spread sheet which contains 2 rows (E and I) that each have a date stamp in them, what I want to do is calculate if the two dates are on the same day and if so return a value. I firstly tried...
  2. M

    Wanting to sort column using VBA

    So I have a command button that when clicked, I would like to sort a cell range in a worksheet. For some reason, my cells are not sorting using my code below. Any suggestions? Sheets("Formula Data").Range("I2").Value = rowNum1 Sheets("Formula Data").Range("I3").Value = rowNum2 Sheets("Formula...
  3. H

    If statement until..

    Hello, I'm wanting help with an IF statement. I am wanting to say If value in column G is equals or greater than the minimum (column C ) then 2750 until the value in column G is less than or equal to Max (column D) then 4000 =IF(ISBLANK(G3),"",IF(G3>=C3,2750,IF(G3<=D3,4000))) This is...
  4. P

    VBA save duplicate on close question

    I am having an issue with my save copy on close VBA code. I am wanting to save a OneDrive shared file (which is a .xlsb file type) upon closing the file to a network drive, but am wanting to save it as a .xlsx file, not .xlsb file type. If I use this code, the file will save, but I get an...
  5. J

    Combing 2 cells, one been a date but changes from date to number

    Hi, I am wanting to combine 2 cells, so C5 (28/02/19) and D5 (1) together but when i do it i get the following. 435241 I am doing the formula of =C5&D5 to get this what else should i be doing? I am wanting the outcome of 28/02/191 or even 2802191 would be fine. thanks
  6. D

    Comparing Two Columns And Producing a Result

    I'm trying to compare two columns, say "A" and "B", and if there is a match i'd like to produce the value "retired" in column C. I am really just wanting to work off column A and see if any values in column B match up with column A. Most the values are in a similar style to "abc123456" or can...
  7. dreid1011

    Shapes question.

    Good morning, I am building a tech tree/flow chart and I had an idea to make it a little more user friendly as it may become quite convoluted down the road. The idea would be to highlight/color change any connected lines/arrows when selecting a specific point(shape) in the chart. I tried a...
  8. H

    Convert Text date to date

    Hi, I have a survey which outputs a csv file. In one of the fields it returns August 3, 2018 10:58 AM - Text field I am wanting to convert it in a table to date format, I have tried =date(cell) but it does not seem to work... any ideas? Thanks
  9. K

    input box in formula

    Hi Everyone I need a script to replace the '08-05 TO 08-11' with an input box. I need the user to define which pay period they are wanting to lookup and then place that formula into cell D2. =IFERROR(VLOOKUP(C2,'08-05 TO 08-11'!$C:$Q,2,0),"") Thanks
  10. S

    Copying multiple cells between workbooks

    Hey, I'm new to VBA and I'm wanting to transfer data from a number of workbooks (Sub Workbook 1, Sub Workbook 2, Sub Workbook 3 etc) to a main workbook (Database). The location of the data contained within all the Sub Workbooks is the same (Sheet1 & A4:A52). I'm wanting to paste this data into...
  11. A

    Protecting Sheet

    Is there a way to protect a sheet from being viewed until a password is entered unless someone has another idea? The reason I ask is because I am wanting to have tabs for specific vendors and I do not want vendors seeing each others information. Thank you,
  12. J

    Use the current row

    Hi, I have the following code =IFERROR(IF(INDEX('Combined Page'!I:I,(MATCH('Load & Unload (7)'!A272,'Combined Page'!A:A,0)))>=35,"Completed","Available"),"") Instead of having A272 I wanting to use A then row() How would I write this? Thanks
  13. C

    Automatic population

    I am wanting to have many ISBNs in column 1. In column 2, I want to be able to type the last 4 numbers of an isbn from the column one list and then have the whole ISBN show up in column 3.
  14. I

    Excel changes my input value and format style

    The cell is formatted as GENERAL just like all the other cells in this column. Most of these cells are filled with data like KS123456GB but i am now wanting to type this 5614930256506582 The problem i face is as soon as i leave the cell its format is changed to scientific 5.61E+15 Why ???
  15. M

    Format range based on changing value in another cell

    Hi all, hoping someone can help me out I am trying to change the formatting of a range of cells (G:BM) to two decimal places if the value in cell D1 changes to "SpecificText" Another small wrinkle in the code, I'm wanting this to run every time the value in D1 is updated. This seems like it...
  16. C

    IF M/F then Vlookup table X/Y

    Hi guys, So i have a big table which has males and females on (indicated in column C) and their 100m run times (column H). In column 'I' I am wanting another score based on a vlookup table elsewhere. I am wanting a formula (that works) something along the line of... IF C2 = M then Vlookup...
  17. N

    Multiple Conditions on table with If Statement in Macro

    Hello all! I am trying to use and If statement with a table. If eligibility is before today and if complete says no I am wanting to highlight. My problem is when there is nothing to highlight it is highlighting the whole table. It is not proceeding on to the else statement. On another table I...
  18. B

    Search in Cells from a list of values

    Hello, I have a column in spreadsheet 1 of about 700 values (part numbers). I am wanting to search several columns in spreadsheet 2 that might have the part number from spreadsheet 1 within the range of cells that could be an exact match or within a cell that contains the match (ie it could...
  19. J

    If cell has pack or pk return Pack of 100 or pk100

    Hi, I am wanting a formula for this spreadsheet. Column A has a list of descriptions for example "red pens pack of 100" or "red pens pk25" What i am wanting is in column B to pick up Pack of 100 or pk25 (numbers would change). Ive got partly there with this...
  20. Y

    formula to multiple by -1 based on two unique conditions

    I have a sheet that lists geological formations with their vertical depth(in column C), in multiple locations. The locations are separated into groups and are identified that way in column A(Group 1, Group 2, Group 3, etc). Towards the middle of each group has the target geological formation...

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