selection

Hi I have the following code in the sheet where the target cells (H20 & N20) are Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$H$20" Then DespatchAddress End If If Target.Address = "$N$20" Then ReceiptAddress End If End Sub The expectation is...

Hi, haven't been able to find an answer to this anywhere so here goes: I want to shade alternate rows in a selection when a value in another column = 1. So, for selection H11:T37, where the value in cell $D11 (through $D37) is 1, I want to shade alternate columns. The reason for this is I...

Hello, What is the formula to conditionally format other cells based on the selection from a data validation cell? What I want to do is to fill cells with a colour based on a data validation selection. Then as the second layer of conditional formatting fill cells based on the "start date"...

just looking to sort column D in ascending order, but I need all the columns to sort as well. When I use this code, its just sorting column d and the rest of the columns are mixed up and my data is now incorrect. I do have a header in row 2 that I don't want included in the sort. I just want...

Afternoon, I am very sorry, this is a from scratch question as i'm not even sure if it's doable! i am doing a spreadsheet based on UN transport numbers, the best example to get across what i am trying to do is 1950 <tbody> 1950 WASTE AEROSOLS, asphyxiant 2.2 1950 WASTE AEROSOLS...

Hello, I am looking for some help with lists or for an answer if this is even possible. I would like to create a "home page"(tab 1) with 3 drop down lists. The tricky part is that I would like list 2 to pre-populate based on the selection in list 1, and then list 3 to populate based on the...

I have created a tracker which allows mutliple selection of items for a given cell. However when I run a pivot on that worksheet What I require is for these items to be displayed independently. However they appear clubbed together in the pivot. Makes it difficult to create a dashboard and...

Hi Experts, I need VBA coding which could perform dynamic selection instead of range specific Range("B2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],'AUC bal '!R2C1:R10000C1,1,0)"

Will someone please help me with this? I have been trying for a couple weeks on and off and I keep giving up out of frustration. I am trying to sort by column T, by cells colors for the rows I have selected which changes. I recorded a macro and tried applying solutions from similar questions Ive...

Hello All, Seeking some assistance, thanks in advance to anyone that can assist ! I placed 5x Radio Buttons to use for filtering the ranges of data i have. Range1 = 14-33 Range2 = 37-56 Range3 = 60-79 Range4 = 83-102 I also have a header range of 1-13 which must always be visible. When i...

I want a user to ctrl-click cells on one worksheet, and from that selection I will find corresponding information on another worksheet. I know how to set the range to what has been selected and I know how to get the count of what is selected. But what I don't know is how to go through those...

Hello, Does anyone know if there is a way to hide a selection from a selection list in a Pivot Table? Thanks, MJ

Hello, I am trying to create a weekly calendar from a data validation list which will populate cells with users based on the selection. I have a list of 15 users with different names, and I want it to be able to populate in order and be able to "wrap around" to the next week selection...

Hello again everyone, hate to be so annoying, but I really am trying. I have come across another issue I can't seem to resolve. I have a worksheet ("Production Sheet") that has 5 columns of information ranging from "A:J". The the first column, the information is centered across Selection from...

Hey excel gurus, I want to know how to change the font in column A and Row 1 of the selected column and selected row respectively. The following is a code that would highlight the entire selected column and row, Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As...

Hello, I'm trying to make a spreadsheet for the family reunion that can be shared and answered by the recipients. I have a list of names, and a box where they can select which food they want. What I wanted is when I click a name(that has already been filled in by that user, that the box with...

Hi all Is the following at all possible? I have data in a crosstab format, containing dates and values in groups. My idea was to present the data for a specific week based on a user selection from a drop-down list. I attach a sample file - please look under the Adult tab. Ideally, when the...

Hello, I need some help on a macro I am attempting to create. I am completely new to VBA so am struggling a bit with the proper macro to make my desired outcome work. I created a formula in Excel which adds 0s to cells when a condition is met. Ultimately, I need that cell clear of the 0 in...

Hi guys, I have a form I created for our department that has dependent drop down lists that I have cobbled together that is barely held together with spit and duct tape :) But I am having some issues creating another set of dependent drop down lists. I have three section with dependent lists...

Have been stuck on this for ages and all the searches I ask do not seem to be able to help. I am using a CONCATENATE formula to build an exact text string to use in a metadata template for bulk uploading to a database (Aconex) I have to have Metadata that exactly matches the Aconex database to...