cell value

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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),"")...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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)...
  13. 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...
  14. 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...
  15. 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...
  16. 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 =...
  17. 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...
  18. 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...
  19. 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...
  20. 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...
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