list

Hi All, I have a data analysis sheet that Im currently working on. I have a drop down list with different entries and I want my code to a copy specific cells (C102:G105) and depending on the drop down menu selection change the paste location of cell in different sheet. I have some of the code...

Hi all ?:) I am seeking some help with a Data Validation dropdown that is not functioning properly after VBA does its thing. An answer to a question I posted recently to resize some rows and clear a cell (and a little bit more) was provided by steve the fish, and his solution works brilliantly...

Hi, I'm brand new to VBA but I have some C# experience; I have done quite a bit of research but I'm curious how I might accomplish the following: I have a large excel file with the names of counties in column A and I want to create a list of ranges so that I can sort the data in related columns...

Hi all, Ive been searching the web for a while looking for a solution. I’m fairly new to this so could be missing a simple solution that I just don’t understand yet. I am creating a form which needs to auto-populate both simple data and other lists from a large amount of data. No issues...

Hello everyone. I have a parent folder with about 50 subfolders. I'm looking for a way to create a list in Excel of the names of those 50 subfolders (not the names of the files inside the subfolders) with hyperlinks to those subfolders. Any help would be highly appreciated.

Hi guys, I'm sure this is pretty basic question, but I seem to be struggling to make it work. I have my work schedule which automatically populates and changes the cell colour if I am working on a particular date. I would like to have a list of dates for my leave outside the calendar and the...

Hello- Trying to create a formula that randomly selects a tracking ID for each associate. In addition, make an alternate selection, but it can't be a duplicate of first random selection. Was thinking a VLOOKUP & RANDBETWEEN combo, but stumped. Not sure if I have to go through VBA route? Any...

Hi Everyone, I have some tables that show information and availability of products. e.g., List of colours then columns that show what finishes they are available in. (Pic 01) Firstly I am not sure if I am doing this in the best practice, but this is what I have so far. I then have another table...

Hi there, I have a sheet named Workers with 2 columns. Each column has around 1000 rows. Under the column Shift (B clomun) there are only 3 options: mornig, evening, afternoon. Under the column Name (A column) are names of workers (example below). Name Shift John morning Paul evening...

Hi All, A user on this site kindly provided me with the below code. The code done exactly what I wanted at the time: "I have a dropdown list on column AY with 'In-Scope' & 'Removed' as the options. If a user selects 'Removed' I want to force them to enter free text in column AZ to explain why...

I have a workbook with several sheets. I have a power query that consolidates the values from those disparate sheets into one consolidated view. On each of those sheets is a column "Pass / Fail", and the values of that cell are derived from a dropdown data validation list. When the query runs...

Hello, Hoping for some help/point in the right direction. I have searched this forum, as well as Google and YouTube. I have a filter enabled, and rather than having to select every specific value each time, I want to be able to point to a list of values that I would be filtering by...

Hi all, I have the following list: Does anybody know how I can sort this alphabetically? :) Kind regards, Jyggalag

Hey Everyone, So I've been looking online for this, but nothing seems to work. I have a dropdown list in cell B21 in sheet named CERTDELEGATES that pulls data form another sheet, Delegates. What I need is a macro that will print all the names in that list to a single PDF in the same folder as...

Hello all, I'm looking to enter the below query from a sql server database. However, in the Enter Connotes section, rather than entering in a list of connotes into the code, I would like for it to refer to a list of connotes in the excel workbook. I would appreciate it if someone could advise...

I have a data sheet that I would like to make a pivot table or another sheet off of with a specific customer number and then day of the week. Below is an example of some of the data. Column E is customer numbers. I would like to make a table or sheet using specific numbers from column E and...

I have searched everywhere for this answer. I am sure it is out there but I feel like I am going in circles. So I came here to you awesome people for help and direction! I do apologize that I am not very savvy in VBA but occasionally I do have to create some crude macros and then come to you...

Hello Guys! I am really new with VBA, i hope You can help me with this. My girlfriend got a task at her workplace, to create 400+ excel files. I think this could be easily done with VBA. I tried many codes, but unfortunately i don't have the knowlege to modify them at the moment, but i really...

Alright, so a company that I work with makes racks for a large company to use. They are new and I go in every day and watch the racks when they get placed and make note of the rack number, time in and out, any issues that come from the robot etc. So we are trying to figure out now, an easy-clean...

Hello community, Excel/macro noob here. I have a question. currently i am working on a 'barman list' in excel where the barman can click the + and the - to increment or decrement a value. For examle, "john" orders a drink, the barman clicks the + button behind his name and a 1 will appear. I...