cell value

Hey Team, I am trying to change a cell value based on the value of a drop down. For this example it essentially building Microsoft project functionality into Excel. If drop down is set to Manual, start date is manually input. If drop down is set to Auto, then a formula populates in cell to...

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...

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...

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...

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...

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...

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...

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...

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),"")...

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...

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...

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...

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...

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...

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...

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)...

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...

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...

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...

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 =...