coding

Hello I am new in Excel and I would thank a lot if someone can help me. I wrote this code with linked dropdown lists in cells: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$S$4" Then Range("$T$4").Value = Empty End If If Target.Address = "$S$5" Then...

Hi all, I currently have this graph here: I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know: 1) is this possible, and if so, how? 2) if it is possible, is it also possible to make it do this coloring without pasting the orange...

I have a excel sheet with a series of random numbers, for each cell in this series I need it to create a series of numbers in a second sheet based on a single cell in the series in the first sheet. For example if a cell in first sheet is 144;I would like to create 144 new rows on second sheet...

Hi, Could someone please help me fix this issue, so I did a VBA code that is below but I just want the VBA code to ONLY take affect in column's D, E, and F but the VBA code is affecting every column. How can I fix this? Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String...

Ok this might be a bit tricky, but I am curious if it's possible. So this is what I am looking for: Sheet 1 (Order List) - Name of Order - This will be inputted by the user and will only be the name of the order Description - This will be inputted by the user as well Progress - This will be a...

I'm running into a unique situation dealing with duplicates. I have the following sheets: Sheet1: Sheet2: Sheet3: My current macro included in the workbook will compare any two columns within individual sheets and delete them. Sub delete() Dim x As Range Dim lstrw As Long Dim sh As...

Hi all, I am having a huge issue at the moment with some macros i created (through record macro). Basically, I have this excel sheet: I tried to record some macro's, where once I press unfreeze, they post this formula: =IF(ISBLANK(B9),"",TODAY()) for the left one...

Hi all, I currently have the following setup: The macro will send out an email to the 1st contact and BCC with this VBA code: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t865934\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As...

Dear all, I currently have this VBA code (please note the part highlighted in bold): Option Explicit Private Const FilePath As String = "\\COMPANY.SSSS.COMPANY.NET\userdata\t5382304\home\Documents\TEST folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i...

Hi all, Does anybody have a nice template, structure or similar wording for a table of information with data being pulled in from a large master data sheet (I imagine through an INDEXMATCHMATCH / VLOOKUP formula, those tend to be the best options in my experience)? The nerdier the better :D...

Hello everybody. I want to do something rather large, but I am very inexperienced in VBA and would really appreciate some assistance. Please note that I want to do a bunch of things, but if you can just help me with one of them, it would be immensely appreciated!! - Wishlist: @Fluff ? :) So I...

Hi All, I currently have a setup similar to this: I want to create a trendline for the 2022 bar charts. My issue is that no matter which one I pick (exponential, linear, logarithmic etc.) it doesnt touch the top of the bar charts for 2022 and it seems to just go through them. Does anybody...

Hi, I have just got a hang of macro but need some help with coding in VBA! I have a calendar with a lot of different activities placed in different cells. Let's pretend that my activities are A,B,C. The cells in the calendar (workbook A) will be externally referenced with data (dates) from...

Hello all, I hope you are doing well. I'd like some help in making a macro that copies specific data from multiple workbooks simultaneously and copies them into one sheet. So: 1. I have these cells: All of which can change values. For example the jumbo can be ZJ2 or ZJ3. Then the user can...

Hello, 1. using VBA, i am trying to think of a way to copy values from a whole column in workbook1 worksheet "sheet2", starting from column F on sheet2 and X number of columns to the right and paste the values into another workbook, lets call it workbook2, and the worksheet the values will...

Hi, Hopefully someone on here is able to help, i am not familiar with VBA . i have a leave spreadsheet with 12 tabs for that calculates staff leave, their name in column B and the date in row 2. This workbook is read only for staff and only editable for managers. what i would ideally like is a...

Hi Everyone, i need support to write a excel vba code on vlookup of all sheets with different name from first sheet name"Sheet2" and put the information accordingly. number of sheets can vary. number of rows in every sheet can also vary. master sheet"sheet2" cloumns detail can also vary. all...

Hi all! I currently have a large worksheet that is similar to this: With the master data looking like this: I want to create a sort of IFERROR(IF(INDEX=0, ,MATCH and MATCH formula (with an iferror that returns "" (blank) if there's an error)) for every column with [] such as [DATE]. So...

I am trying to make a code that makes the program write data in a specific excel spreadsheet according to the value of the variable "MachineName" declared as public What happens is that the program does not allow me to do it because an error is detected on line 96 The error: The code...

Hello everybody, I currently have something similar to this: Linking to this: It should return the date 21-06-2019 for XG10, but it does not. Can anybody see what I did wrong and how to fix it? Would be greatly appreciated! :) Thank you! Best regards, Jyggalag