change cell value

Hello fellows. I have a doubt on Excel calculation. If I change the A1 value the B1 should automatically change to 1 the same if suppose I change B1 value the A1 should change to 1 Kind Regards

Hey guys! Thank you for taking time to read my post. I am stuck:confused:. I have some code that captures a cell's value on a timer, but I want it to capture the value only when it updates. It is for a live data connection to my stock broker. I want to capture the "last price" and record it on...

I want to change value of one cell (Cell D) depends on the value of others (A to C). Example: If any cell in A to C is "NO" then D should "Open". If all cells in A to C is "YES", then D should change to "Closed". Please anyone can help? Thank you, <tbody> A B C D YES YES YES Closed NO...

Hi experts, I have a spreadsheet that needs a rather complex macro solution, for someone like myself at least. I will try to explain as simple as I can and provide as much clarity as possible (please see the file in this provided link as you go over the below inquiry) Goal: Elimination Of...

Hi, Please help me. I'm trying to create a checklist. I need to change the value in cells K25 and K27 to N/A when the value of cell K22 is Correctly I used the code below before but it does not work Private Sub Worksheet_Change(ByVal Target As Range) If Target.Range("K22").Value =...

Hello, I have a system that generates a report in an excel file that has two columns “Services” and “Product” however the services against the product are not correctly mapped. Hence, I need a macro to map the correct service against the product. I have added two tables below 1) The data I...

Hey, I'm looking for some help with this I would like to set the value of any cell in column D to "Yellow789" where that rows column A value begins with (but may contain much more than) "red123", column B value contains (but may not begin or end with) "blue456", and Column C value is blank...

Hi guys, I have two columns and I am trying to find the best way to write a change driven code that will accomplish my goal. If a value is entered into column A, then that value is copy/pasted into column D in the same row if that cell in column D is empty. Column D should be able to be...

Hi Forum, I've had a tough time searching for a solution with Google. I don't quite know how else to phrase it. I have an Excel workbook where users input data. In two of the columns, D and E, users select from in-cell dropdowns (data validation). Each column has three selections to choose...

Hi guys, I need help which a vba code to make excel automatically run a macro when I change a value in any cell of a specific column. I have come up a modification of the following code which is not working: 19 = target column testing spreadsheet = spreadsheet in question Refreshfilter = macro...

Dear all, I looked up several posts within this and other forums but I cannot get my code to work. One of the reasons might be that I am absolutely VBA-naive ... Here is the simple problem: I have a drop-down (via Data - Data validation - list) in cell D8 of a Excel 2013 work sheet. I inserted...

Asking for help to have a macro to change cell C9 to customer name in cell T3, then print to pdf. Once printed, change cell C9 to customer name in T4 and print to pdf. I have the printind to pdf working, but changing cell value is messing me up. Any help would be appricated. Cell C9 currently...

Hi all. Question 1: I have an Excel Workbook that I use to record Health Assessments for a number of different companies, listed in a separate sheet in the same workbook. For each company, I then have quite a big number of employees. These are listed in a separate Excel file (all employees of...

Brand new to the forum and am in the middle of building a spread sheet to manage my class's progress (I'm a teacher). Our assessment levels are changing and for each different 'level' a child receives they also receive a 'point score' for example if a child is a level 5c say, that is the...

Hi all, please bare with me as my first time posting, I am a novice at excel and VB but know the basics, any help is much appreciated. What I am after is a macro, which once played, will check if the values entered in cell (A1) on the active worksheet (Sheet1), are contained in column...