target

Hi All I am using this code and the target range represents 1 layout of 72 cells. I need to include 23 more layouts. My question: should I cram it all in 1 target range or should I duplicate this code for each layout? If Not Intersect(Target...

I want the date in column F to update when I update information in column G. This piece of VBA isn't working for me...any ideas on how to rewrite it? Case Is = 7 If Target.Offset(, -1) = "" Then Target.Offset(, -1) = Date Here is entire code on sheet. Option Compare Text...

good morning , Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A:A")) Is Nothing Then If Target.Count > 1000 Then Exit Sub For Each c In Target If LCase(c.Offset(0, 1).Value) = LCase("Matched Assets") Then...

Hello all, first time posting here! How can I modify this code to always look for the next available line? when I run this it just overrides whatever is already there. Any help would be GREATLY appreciated! TIA Sub add_diagnosticdeliverable() ' ' add_diagnosticdeliverable Macro '...

Hi Everyone, I have the macro below which I use to treat my own tick boxes in cells "a" = tick It works great except you have to click away before it will change again. I was woundering if there was a bettter way i could do this? Basickly I want a macro that gives me an "a" in the cell i click...

Hello, Have the following code which works except it highlights the entire area it posted the data after doing the macro instead of just staying where the cell originally was. How can I get it to stay on cell B2 after running this code? Private Sub Worksheet_SelectionChange(ByVal Target As...

Dear Friends, Calculating Commission: Main sheet: Cells A1 to H5 <tbody> SALESMAN SALESMAN NO BILL NO BILL DATE SOLD AMOUNT PAYMENT RCVD BALANCE DAYS JOHN 20 AF-001 02-04-2018 1000 1000 0 10 JOHN 20 AF-042 14-04-2018 2000 2000 0 20 JOHN 20 AF-050 29-04-2018 3000 2500 500 12 JOHN 20...

I have a question about reading & setting the zoom level of a worksheet, but I need to explain exactly what I'm trying to do. In my workbook, I'm writing code to allow the user to import data from another workbook of the same type. (This is in case the version they have been working on becomes...

End goal: To enter a numeric value in a cell, and according to the value, it will hide all rows based on different values in a set column. Example: Enter 4 in cell B2 and it will hide all rows which contain values "AB5, AB6, AB7, AB8" in column P. What i've tried: VBA code, but i can only get...

Hi All, I have two lists of customers. One is a list of target customers with Names in column B and Target type in column A. e.g A, B or C In the second Sheet it is a list of all customers in the country. with names in Column A I am trying to get the Target type added into Column B of the second...

Hello all, I don't think my issue is as complicated as some of the ones I've seen on this site but i think my lack of understanding in the formula is causing me problems. I was instructed to gather some metrics using data from out ticketing system. This is where i am running into problems, I...

Hi, Checked a bunch of threads and am not able to get more than one intersect statement to run in my workbook. Each statement runs perfectly as seperate statements. I want an entire row to be move to a tab of the same status name when a dropdown status is chosen on any sheet and I want the...

The code below is doing almost everything I need it to do, but I can't figure out how to sort the column by color instead of alphabetically, and allow me to set which color is on top. I've been working this problem for several hours and would sure appreciate a hand! Private Sub...

Hi, I have a KPI dashboard where I have data from 2016 onwards. Each KPI data is organized in each row. KPI name is placed in A column and it's target in B column followed by monthly achievements. I would like to know for how many consecutive previous months the target is not achieved for...

Hi, I hope you can help. I’m trying to conditional format a colour for A2 based on its percentage to another. For example, If A1 if the target (20%) and A2 is the result (15%) that would be 75% of the target. I would like A2’s conditional formatting formulas to calculate If less than 90%...

Hi, I will explain.See the table below <tbody> a b c TOTAL TARGET VARIANCE R1 1 1 2 3 -1 R2 1 1 2 2 0 R3 1 1 2 1 1 TOTAL 3 1 2 6 6 0 TARGET 2 2 2 6 VARIANCE 1 -1 0 </tbody> The total target of the rows and columns will always equal each...

When using Worksheet_Change event, I see that if the user pastes a range of cells at once the values are input as an array. How can I loop through the values of the array, but also catch if a single cell is changed? What I have right now, this works for single cell changes but not pasted lists...

Hi I have two sheets that I'm trying to paste between; my source sheet and my target sheet. My VBA is working with the copy / paste however I want to offset the paste so it starts on a specific row. The source rows start in cell A1 and I want the pasting in the target sheet to start in B5...

I have two worksheets, ws_source and ws_target. The basic idea of what I'm trying to do is to copy a range of data from ws_source to ws_target. Normally it would be simple enough to copy the range and paste it to the same range in ws_target. However, there may be rows of data in that...

Hi Excel-experts,i find this code on internet: Private Sub Worksheet_SelectionChange(ByVal Target As Range)Is it possible to run anything like this, but then for 'Colour change in cells'? I would like my sheet to react on change of backround colour in some specific cells. Thanks in advance, Johan