cell

  1. G

    VBA to search multiple cells.

    Hey guys, I have this simple code to export as PDF, range AB52 is where it pulls the file name to save as... is it possible to have multiple ranges for the code to look for? I tried "range ("AB52:AB54")" would not work. Is this even possible? If one cell is empty look on the other ones for the...
  2. D

    CONDITIONAL FORMATING LAST CELL IN COLUMN GREEN IF GREATER THAN ANOTHER CELL

    I want the last cell in column L that has a number to be green if it is a larger number than cell D11
  3. G

    Data best fit?

    Hi all, If I have a range of numbers to 2 decimal places in column A, for example from -2.52 to 3.84 with intervals that are not the same -2.52, -2.49, -2.48, -2,42, -2.42, -2.41, -2.38....... 3.65, 3.69, 3.70, 3.80. In column B the number in the cell adjacent to -2.52 is 20 The number is the...
  4. Z

    Font ? =+ not returning it in script

    I am pulling into cell A52 =+j12 from cell J12 thats arial font but in A52 i have the cell to script , but its now returning it in script.
  5. B

    Checkboxes Yes No

    Hello, I have the following code that I picked up from some web page. This one inserts only one button to the left of the cell. I would like to have two checkboxes in one cell, one for "Yes" another for "No" and only one can be checked. I tried to replicate second option by adding "1" to the...
  6. J

    macro is skipping tabs

    good morning, Newbie here...i have a macro for auto generating tabs into PDFs and save them. the issue i'm having is that it is randomly skipping over some of the tabs. anyone have an idea how to fix this? I checked the ones that get skipped to see if cell "A5" is the problem but it is not...
  7. W

    Sum the entire column of named range except the first row

    Hi Folks, I have a question, is there a way (a formula) that i can put in a first cell of a named column and have the formula sum the entire column EXCEPT the first cell of that same named range? This formula "=sum(index("My Named Range",,11))" results in a circular error because its trying to...
  8. S

    Name a worksheet after cell contents

    Hi I have a bit of coding that copies an existing worksheet (called "SCHEMES") and puts it before another worksheet ("AUDIT") but I'd like to add in some code that will automatically take the content of cell A1 of the sheet that's copied across and automatically uses that as the worksheet name...
  9. P

    Formula to pull values related to a coloured cell

    I have 3 cells, each cell has a value, 1, 2, 3 The cell value is related to a score, each score located in another cell, 10, 8, 0 To pick a value, the user has to change the cell colour, for example the user picks the cell with 1 and shades it any colour Then the formula needs to pull in the...
  10. C

    highlight cells more or less than 0.2 to nearest 1

    Hi, is there any way to highlight the cells in a range, if: the value is more or less than 0.2 to the nearest 1 there are already a formula in each of those cells in the range, which will change according to what i change at the other cell. example: if cell value = 6.09, highlight if cell value...
  11. B

    Formatting with Multiple/Varying Conditions

    Hi Everyone - Need some help in finding a way to have a cell change color based off a drop down, and each time that drop down changes, it will potentially change the color of the cell, based off of the current letter in the cell. See below an example of a few rows. My book has 54 rows, but if we...
  12. Geo1126

    IF Last month

    Hi Guys, I think this is pretty basic, yet I still havent been able to figure it out. I want a formula that returns a cell value, if another cell value (date) occured last month. if the month column is blank or not last month return NA. A1 has date B1 has value I wanted formula to capture C1...
  13. J

    find the content of a cell in another sheet based on the content of a cell

    Hello, I'm looking for a macro to jump to a cell in sheet 2 based on the content of a cell in sheet 1. Basically what the macro should do is: Find cell A1 of sheet 1 in column B of sheet 2 and go to that cell. I've looked for a solution but couldn't find it. Hope it is a simple question...
  14. U

    Extract the the one or two characters of a string, depending on number of digits

    Hello, I have a cell which contains the size of an item, "Size20" for example. I have another cell which I'd like to have equal 500 if the size is 16 or larger, in which I have the formula =IF(S22<>"",IF(VALUE(RIGHT(S22,2))>15,500,0),0) However, this does not work for cells such as "Size8", as...
  15. G

    Conditional formating where there are 2 values in a cell

    Hello, before i start rebuilding a spreadsheet to split values into two cells, is there anyway to conditionally format a cell, based on one of the values contained in it. for example <colgroup><col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <col...
  16. R

    VBA does not run

    Hello, I am using this VBA code but it does not run automatically when I enter data in the sheet, I have to run it manually! Sub Pop_Up() Dim cell As Range For Each cell In Range("c1:U439") If IsDate(cell.Value) Then If cell.Value < Now() Then MsgBox...
  17. D

    Copy and Paste Multiple Times

    I just want to know why I am the Visual Basic Applications (VBA) script isn't working as it should be. I am trying to copy and paste multiple tables, depending on the value I put into cell E1. I've used this code here: Sub CopyMulti() Range("A3:D19").Copy Range("E15").Resize(14 *...
  18. S

    Tick and cross symbols in same cell based on formula

    In cell A1 I have a formula which comes up with either 0 or a number greater than 0. In cell B1 I want: 1. A tick symbol to appear if A1=0 2. A cross symbol to appear if A1 >0 Not sure how to do it or what formual would allow this as I have never dealt with symbols in formulas? Can this be done?
  19. TAPS_MikeDion

    Cell/row sorting - data from two locations

    Hi everyone, Hopefully this can be done, and hopefully you follow what I'm trying to do. Sheet1 (for argument sake, columns = A - G, rows = 2+header) <tbody> LAST FIRST MON TUE WED THU FRI Jones Bob 5 5 5 5 5 Smith Ann 8 8 8 8 8 </tbody> Sheet2 (just references from sheet1...
  20. T

    Conditional format if year in cell's date is same as current year

    I have a cell that contains a date in the format 21-Feb-21. I would like it to shade it green if the year in the date is the current year. I am going to have a second rule where if the year in the cell is before (less than) the current date than shade red. I believe I can do it simply but...

Some videos you may like

This Week's Hot Topics

Top