cell value

  1. J

    Formula to find column value with ticked/filled cells for Google Sheets

    I have a question about what formula I should use for the following: I have a spreadsheet (similar to below). Across the columns are values such as A, B, C etc. Down the rows are item numbers. I have one table which has these items down the rows and ticks next to the relevant column value. E.g...
  2. J

    VBA save in folder and subfolder based on cell value

    Hi, I've looked around here for the answer but could find any like mine and my go-to IT Mgr. no longer works here, so I'm having to learn all of this on my own. The VBA code I have saves the current .xlsm as .xlsx as it's supposed to. It is a checklist and I'm wanting to save the workbook in a...
  3. D

    Creating a named range from cell values

    I need a solution on how to create a named range based upon cell values. The cell values are variable, and the sheets on which the named ranges need to be created are hidden from the end user, hence the need to automate it. I've had some success with the actual name of the range as per a cells...
  4. P

    Insert cell value as sheet name in VLOOKUP formula

    Heeeelllo, I am not sure how this works, I've invested a lot of time into this, please help. Thanks so much. So... I have this formula, which works perfectly fine, but I want to make it more automatic right? =IFNA(VLOOKUP(B5,IMPORTRANGE("mydocURL", "517!A:F"),6,FALSE), "0") I have several...
  5. M

    VBA to rename sheet based on cell value in another VBA dependent sheet name

    Hi there, I am a total noob at this so be gentle! I have a sheet that is essentially a calendar, with 1 week per sheet (i.e. Sheet 1 = 1st Jan, Sheet 2 = 8th Jan and so on). I am trying to make it so that all I have to do is type in to one cell the date I want the calendar to start from, and...
  6. X

    Pulling Specific Cell Value from Multiple Workbooks

    Hi guyz, Please excuse me if this question has already been asked multiple times. I am very bad with the VBA Scripting and would appreciate any and all help with my query here. So, what do I need help with? I have a folder in my C:\ Drive with the name "Acc". In this folder I have Multiple...
  7. H

    Hide/unhide variable number of rows

    Hi All, I am trying to use a code that allows me to hide/unhide x number of rows based on another cell value. I also need this to update automatically when the cell value changes. So for example if cell A1 is =1, I want it to show row 5 and hide rows 6-10, when the cell value changes to 2, I...
  8. B

    referencing a cell value that is populated from a vlookup

    Hi I require to reference a cell value using an IF statement. The issue is that the cell value is populated from a vlookup and when I try the IF statement, the desired result does not happen this is the VLookup : =IFERROR(VLOOKUP(IND_LOO_Builder_ENG!L9,Position_List_ENG!2:10004,18,FALSE),"")...
  9. W

    move a row to another sheet and separate workbook based on cell value with button

    I discovered another thread close to something I am trying to do. Automatically move a row to another sheet based on cell value I am trying to do pretty much the same thing but with a button and with the copied data from columns A-M only going to 3 places at once, another sheet in the same...
  10. J

    VBA to delete rows based on empty cell

    Hi. Brand new here and to the world of VBA and MACROS. I need help with a certain situation I have. I have a workbook with twelve worksheets, sheet 1 - sheet 12. A lot of data but what I need to concentrate on is column d. I would like assistance with a vba code that would delete the...
  11. K

    Filter two pivot tables in one sheet based on a cell value

    Hello, I'm trying to create a macro that will filter two different pivot tables in one sheet based on a value in cell A1 of the same sheet. I have some code earlier in this macro that's working fine, so I don't show it here. Below is what I've written to filter the first pivot table in the...
  12. P

    vba copy and paste number of times based off cell value

    I cant figure a vba code to do the following: --------sheet1----------- -----(A)---------(B)------ -----Qty.----Description 1]----3---------sofa----- 2]----1---------chair---- 3]----5---------table---- based on (sheet1 column A's value)......copy and paste (sheet1 column B's value) onto sheet2...
  13. G

    Using VBA to Make Sheet Name equal to Cell Data

    Good morning Everyone, I am trying to make my tab/sheet names equal to the cell values. I am using the formula provided by this page: https://excel.tips.net/T002145_Dynamic_Worksheet_Tab_Names.html This formula was created to pull values from a single cell. I need to pull values from two...
  14. 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...
  15. 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)...
  16. 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...
  17. 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...
  18. 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...
  19. 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 =...
  20. 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...

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