rng.offset0

I', still really new to the coding aspect of excel and need some help. I have created a tracking sheet, what i want is when someone enters their name via a drop down menu in column A that a date and time stamp would appear in column C. i want this code to repeat for when something is placed in...

Does anyone know how to keep the undo along with worksheet change event. Here is my code that I am using. Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range 'TRACKS DATE ENTRY WAS MARKED AS COMPLETE AND WHO UPDATED IT If Target.Column = 21 Then...

Hi everyone! I found a code on google that automatically generate date and time when a cell changes. It is working, but I want the date and time to be recorded next to the cell with the old date and time and so on whenever the cell changes. Can somebody give me a hand on this? Thanks in...

When this code was originally established, the requirements provided to me were to identify instances where the data in columns A, B, C, D & G matched; and place a Y in a particular column. If the data across the same columns did not match, create a new record. Now, the requirements have...

Would like to make a VBA private sub that runs a column of data on change and combines in another column the time from the cell + current DAY + AM/PM (value from a matching cell in another column) If it makes it easier it can also pull date from a third column. code below is what I started...

Hello the below code I hope you can help, I have the 2 codes below that need to run simultaneously, but at moment they don't, this is to work on a cell value change, the last code only works if you press play. hope you can help please. thex2 codes below are placed in sheet 8 (SMART Locate)...

Hi all, good morning, I have the code below but the workrng intersect doesn't work it comes up with a yellow background can you help please. this is the line with the error Set WorkRng = Intersect(Application.ActiveSheet.Range("I:I"), Target) Below is the full code Private Sub...

I'm trying to interrogate the data on mMD, and compare it to the data on mTP. If a range exists on both sheets, I want to update column J on mTP with "Y". If the range doesn't exist on mTP, then I want to add the info to mTP (this part works). The code below works, except for updating column...

I have 2 workbooks. Each workbook has a sheet called Active_Inv. I'm trying to update the main workbook (Deposit Application) with specific cell values from the second workbook (Chelsea_FLP), where the values of column V and AE are equal. I have googled and googled for over a week, but have...

Hello, I would like to have the below code run twice within the same worksheet. As seen now, it's set to place a timestamp in a cell four columns to the left of column "S". I would like to run this a second time and it would need to be 7 columns to the left of column "U". Thanks in advance...

hello ,i am having trouble making a small vbs sript to copy data in an excel file. Sorry ,new at this. I want to copy data from column B or C to column D(byscript) .The condition to chose between column B or C is that column A is 0,00 or 20,00 result should look like this: <tbody> <tbody> 0...

I need assistance merging the two macros below together. The goal is to have a date/time modified displayed in column K when data is entered in column J, as well as a date/time modified displayed in column M when data is entered in column L. I already have to two setup independent but am unsure...

I have other codes on other sheets and my issue is the set "set WorkRng = Intersect(Application.ActiveSheet.Range("B:B), Target)" Is the issue because I need to make this code specific to one sheet and not just "ActiveSheet?" <tbody style="border-radius: 0px !important; background: none...

Hello, New to this forum and could not really find an answer for some reason related to this, but hopefully someone could help on this one. I am sure it is an easy solution, but I am not getting any luck. I am trying to get these two codes to work simultaneously but only work when when they...