cell value

  1. D

    Insert a picture into named excel worksheets by client id vba

    Hi everyone, I have a workbook containing multiple sheets. The first sheet contains a unique 4 digit id to identify the client. Other sheets within the workbook are named after a year group so Y1, Y2, Y3 and so on.... Elsewhere on my PC, i have files that are named with the 4 client digit id...
  2. T

    VBA to Make SHeet Name Equal Cell in Sheet

    Hi everyone, I used the second VBA code option on the following site to make sheet/tab names equal a cell value within their respective sheets: https://excel.tips.net/T002145_Dynamic_Worksheet_Tab_Names.html The problem is, the names do not update automatically (as is claimed on the paged)...
  3. K

    On Multiple Sheets Convert Formulas to Values

    Hi all, I'm trying to make a button click change all cell formulas on 5 different sheets to the cell values. The code I have below is perfect for the currently active sheet but I haven't had any success with specifying which sheets I want it to affect. Any help would be so greatly appreciated...
  4. S

    VBA code not hiding columns based on cell values

    I have a VBA code the hides columns based on 3 different cell values, but it is not working properly. If cell Z7 & Z33 do not equal "Black" AND if cell Z39 does not equal "Yes" then hide columns K:N. So I want the code to hide columns K:N if Z7 & Z33 <> "Black" and Z39 <> "Yes". Sub...
  5. M

    set cell value with vba and get the formula in the Excel function bar

    Hello everyone, I am trying to set the value of a cell by using vba. The thing is, this cell is in a column where all cells are set by the following formula : =IF(OR((H17<>"");(F17<>"");(E17<>""));SEARCH("zzz";B$9:$B17);"") So when the user clicks on any cell, this is what the Excel function...
  6. P

    VBA select group # from value in cell

    I am writing VBA code to refer to the group number in cell ("W5") of my worksheet. Instead of referring to ("Group 336") - I want to refer to the group using something along these lines: ("Group (Range("W5").Value)"): Dim wsh As Worksheet: Set wsh = ActiveSheet Dim shp As Shape: Set shp =...
  7. P

    VBA if cell value is greater than another cell value then syntax

    I am struggling to find any solution to my specific need online. I am tying to find the correct syntax to do the following: I want to create a macro that increases the value in one cell (W9) by 25 providing it doesn't go over the value in another cell (W7). I then want to create a second...
  8. Small Paul

    VBA WS Name from Cell, Loop Copy/Paste

    Hi I have a worksheet, “Required Data”, which has data in columns A:M. In column A I have a list of numbers which are derived from criteria in the worksheeet. Starting at cell A2 (A1 is a header) this presently runs 1, 2, 2, 2, 2, 3, 4, 4, 5 etc to 76. Each of these values have a...
  9. E

    copy paste specific content

    I'm looking for a code that will copy certain columns and paste them into a new sheets that will be created based on cell value. for example lets say I have a huge list of data in cell A contain A 5555-01-120-121 5555-01-120-123 5555-02-120-255 5555-05-150-220 I would like to be...
  10. K

    Expand rows based on cell value

    I need a macro code which I can attach to a command button which will expand specific rows based on cell values. My sheet has a series of questions. or each question, there are 4 possible answers in a drop down menu in column A. If the answer has more than 4 characters in length, I need the...
  11. P

    integrate value of cell A3 into formula

    Hello, I try to find a way to integrate A3 cell value into formula I got a folder full of invoices. File names are consecutive numbers starting with 180000.xlsx I want to extract for each file five differents cells. I'd like to manually write in colon A all file names without extension...
  12. R

    Capture cell data into other cell

    Hi, Im sure the title is like others, but I couldnt find a solution and couldnt think of another title. :0) This is my dilemma. I pull a value into a cell everyday by way of formula. I need to start collecting this number in a historical way, so I can identify the change patterns. Example...
  13. Z

    Changing "value" into "any value in a specific cell" in VBA

    Hello everyone! I want to build a macro or use a formula which allows me to search the value of (let's say)"search" cell K10 in a table spreadsheet. Jump to it, replace the background with color green, and jump to the cell next to it to the right (The value of K10 is in E171, fills the...
  14. T

    How to hide and unhide columns based off of a numeric cell value using VBA

    Hey guys, This is my first time posting, but I've definitely used the forums for help before. I need to expand and collapse columns based off of the numerical value in cell A1. And I need to use VBA to do so. Columns B:Z will expand and collapse. For ex. A1 = 0 then no columns show. A1=10 then...
  15. B

    Column for custom comments in data labels, excel 2010

    I am trying to add a column to a score board, in which I can write custom comments which I want to appear as data labels on a graph (e.g next to June entry, "New manager starts" and such information I have found a way I believe in Excel 2013, but this doesn't work in 2010 as there is no option...
  16. A

    Using cell value as a defined name

    Good Day Dear Experts, I wish to use the text value in a cell to refer to a defined Name with a specific numerical value. Somehting like this: A1 = bwt Using Name Definition: bwt = 100. C1 = bwt* (another number). However, I want to use the cell value as a reference to the defined Name, i.e: C1...
  17. R

    VBA: Use Cell Value as Sheet reference to Hide/Unhide Sheets based on Cell Value

    Hi there, Hopefully the title is correctly describing what I need, but here I will elaborate. I will for example have the following worksheets: - Overview - Adam - John - Nick - Tess On the Overview sheet you will find the total of expenses per employee. The name in column A and the value in...
  18. L

    VBA code to Freeze/Unfreeze Panes based on a Cell Value

    Hi, I have a sheet where it would be handy to have/not have frozen panes depending on how you're filling it out. Other people without excel experience will also be using this sheet, though. I have a cell (x) with data validation that has two options: Freeze Panes/Unfreeze Panes. I'd like to...
  19. E

    Extract Cell Value Based on Cell Color Within a Row Range

    Hello, I am new here. I am trying to extract the cell value based on the cell color within a row range. I have looked around and haven't found anything that has worked for me. So I am trying to lookup between B2:Q2 the cells that are colored magenta and then return the cell value of the...
  20. E

    Cell Values within a Formula

    Hello! I am a teacher doing some data sheets for the upcoming school year. I am mainly self-taught and google solutions often, but can't get this to work. (I'm actually in Google Sheets so that admin can get live updates) Two different things, but wanting the same result: 1. I am doing a...

Some videos you may like

This Week's Hot Topics

Top