cell value

Apologies for the noobiness, I'm a CAD technician who's been roped into helping with some excel stuff. I'm trying to accomplish this using functions as I haven't used VBA before (although I'm open to trying it out). Problem: I have a 'master' workbook that contains hundreds of sheets, each...

Hi There, Can anyone help me out here I'm just getting started with formulas in Excel. I have an Equipment register containing particular information but this equipment gets moved around. I would like to know how I can get an entire row to copy into another worksheet if I enter the...

Hello! I am really hoping someone would be able to help me out with this request. I'm working on a project plan with a gantt view. The last thing I need to include are tasks that have not been formally added to our system. I've created a table (OustandingTasks) that calculates the number of...

I am looking for some options. If I were to Type in the characters APP in a specific cell such as L719 in column L I need the cells in that row from say A719:N719 to turn Green or If the characters were RFC I need those cells to turn Red. Thanks for any help.

Hello :) I am putting together a skills matrix that is to be used by other managers across the organization. There are three parts to this: 1) Identify a skill or competency required (sheet 1) 2) Score current staff skill level for each identified competency (sheet 2) 3) following, the...

Hello everyone !! This is my first post ever in this forum, im really new into vb so my question may be easy to solve but not for me. Im triying to do this : Check value of cell A1, if it is 0 , hide columns (H and I) , if not, unhide same columns (H and I). Check Value of Cell A2, if it...

Hi guys, hope you can help me out here as I'm new to VBA. I'm trying to forecast tenant rent rolls for a property and have set for a max of 50 tenants. But based on a numerical value in a cell, which denotes how many tenants there are, I would like to hide the unused rows in the worksheet. E.g...

Hi there, This is my first post, so hopefully I provide enough information and not too much. I'm also quite new to excel and VBA. I have a workbook with about 50 worksheets. In each sheet, in column A, there is a cell with the text "CA1111". Currently, I'm manually going into each sheet...

Hello Everyone, Here's the code for my excel macros, what i want to happen is to copy the values from column AG to another sheet (c1), but every time I run my code it returns #REF because it copies the formula and not the cell value. I need help regarding this TIA...

Hi Forum, I am trying to link a value in a textbox to a specific cell. I.e. value in textbox 1 needs to be displayed in cell A1 sheet 1 for instance. I ahve tried below code : Sub Copyvalue() Sheets("Sheet1").Range("A1") = TextBox1.Value End Sub But this gives me the error : runtime error...

Ok... so I have a simple piece of code that works fine. Basically it is checking the ActiveCell to see if any part of the cell contains the word "Cat" and if it does, it returns "True" in the cell one column to the right. 'Checks the activecell value to see if any part of the cell contains the...

Hi, I have this VBA to display the cell A1 in the header of the active worksheet. But how do you display the value of cell A1 of sheet 1 in the header of all worksheets? And how do you display multiple values? For example I want to display A1, B4 and C6 in the header (of the whole workbook)...

Hello I need help on my macro - it doesnt seem to work. I need to define Array of Sheets based on cell value from A1. thank you very much in advance 'Part of the Code A = Activesheet.Range("a1").Value 'where Range ("A1") contains the name of Sheets to be chosen e.g. "P001", "P002", "P003"...

Hello, So until now I have only viewed answers on this site, but it has helped me sooo many times! I could not find an answer to the question below, so hopeful one of you awesome people can help! So I have few versions of what I have tried, but I think that a command button would work best. I...

Hi guys, I've seen people post how to change a Tab name based on a cell's value/name using a macro, but what I'm looking for is the exact opposite. I need to have a cell's name/value change based on a tab's name. Would appreciate the help. Thank you

Hey everyone, I have a macro which hides cells based on cell value "0". The program is a calculator with a variety of options. Depending on the option the user selects, it will be "0" or "1" so when the copy command is clicked, it will hide the unnecessary rows. However when it switches...

Good Morning, I have been searching for hours for the answer to this question. I have ZERO experience with VBA, but am trying to make an idea come to life. I have an excel sheet which pulls a bunch of data from an Access Query. I want the user of this spreadsheet, specifically tab/worksheet...

Hi All! I am new here to the forums, but certainly not excel, although I am no genius. I am looking to have text displayed in one cell, based on the value of another cell. I understand this has been asked before, but I have tried all suggestions and cant seem to ket it working. This is what...

Hi, I need help with a macro to insert 'x' amount of columns based on a cell value entered, and then copy formulas over to the right for all of the new columns created (should copy the entire columns formulas over, i.e. not a range within the column). It should also always insert columns -...

Hi, I would like to know if it is possible to have a formula where the search field of the array is dependent on the number I put into a cell. As an example: <tbody> A B C D E F 1 7 4.5 7 2 9 5 5 3 6 3 10 4 8 0 </tbody> I want to perform a calculation on the above...