vba - help

I have a list of names (starting in C21), column B is empty. I am trying to find a macro that will copy value of the selected cell in to the first empty cell in column B (starting at B21), then clear the original cell. To make it a little more clear see example below. Lets say I selected C22...

Hi All, As im sure youve all heard a million times I new to VBA and I am self teaching myself VBA for work and self betterment. I set myself a personal project for home rather than always stuff for work to keep a stock of what we have in our multiple freezers. The problem i have is exactly what...

I have a set of contact data that has been extracted from our CRM system and needs to be imported into our ESP for marketing purposes. The two systems can't talk directly to one another. I have extracted the data necessary, but it is formatted in a way that will not allow direct import. The...

I am trying to write code which changes the color of text added to a string through an input box. It works great if I only have to add colored text to the cell once, but when I try and add any more information through the input box it resets the color of all the text. What I want to do is keep...

I’m not sure if this is possible but I’m curious to see if anyone has a solution or recommendations. I have a month end accounting checklist with various tasks assigned to different people. We have a consistent problem of people not completing their tasks on time. What I’m after is something...

I'm attempting to create a worksheet that could act as a test prep. I have the questions in column B in cells 2 to 400 with corresponding 4 multiple choice answers in C2 to F400 and the and the answers in the corresponding rows in column H. My goal would be to have people able to click on the...

This is the 1st time I have posted, so if this is a duplicate I apologize. I am new to VBA and I have the coding below. What I am trying to have happen is, if cell p5 contains "CONSOL" to name the tab one name and if does not, name it something else. I am doing something wrong as all of the...

Hello, I'd like to place a macro button on sheet1 but the macro should run/perform on sheet2. What do I need to do in VBA to make this happen? I'm relatively new to VBA so not sure where I would put my sheet reference. Here is my current VBA code. If you need any other details, please let...

2Hi All, Hoping that someone can point out where I am going wrong. I'm trying to adapt some code I that I had come across quite some time ago - I can get it working to an extent but not 100%. I do have a sample sheet but can't for the life of me find where to upload it... So I'll post both code...

Hi guys, I guess I have a slightly silly question, but I am not too advanced with VBA, so bare with me :rolleyes: I have a data set with text in column C, which contains striked words at random places within the paragraphs. What I need to do is to fully delete those strike-through phrases...

As I scroll down my excel sheet is there any way that I could have a command box scroll down with me. This would be really helpful so I don't have to go all the way back up to the top of the page to run my command button again. Thanks :laugh:

I wanted to make a drop down userform with 3 levels. (Level 1 decides Level 2 decides Level 3). The goal is to have the users of the form be able to select from drop downs to get to level 3 instead of having to look through all the level 3 items. I was able to get 1 and 2 to work however...

Hi, I have a column that i am calculating based on another column values so it has some default values and formula in it initially but i am want to make this column editable by making user enter their own values but i dont want to delete the formula. With the help of VBA?

I need a little help with vba if possible! So I need some code that can help me insert a value into a varying range of cells, based on what the user selects. So they could pick cells A4 though to B14 and when they select a button I want it to insert a set value. I've managed to insert the...

I am new to VBA and MACRO's Can anyone give me help on writing a code to email a number of contacts automatically for when cells G5:G55 changes from 0 to 1? thanks

So i've gotten my code to work and it works great BUT it's going to be VERY long. At the end I'll have like 80+ Case indexs (I have to copy the code about 80 times and change the range.) Is there a shorter way to do this? I can change the data on the sheet into tables or something and name...

I'm creating a dependent drop down box using ComboBoxs. I have a total of 3 boxes dependent upon the previous. I've written the below so far but it's not working. When I select the item in the 2 drop down it doesn't appear in the drop down. Or (If i take out the .clear from below) the list...

I know the easiest way to do a dependent drop down is with Data Validation. However, the options in my lists are too long to use this (unfortunately, I cannot make them shorter.) I need to be able to create a 2 dependent drop downs (total 3 that cascade depending on the selection.) I was...

Hi Everyone I need a big help. It is a task which involves extracting values based on matching dates. On my sheet1 of activeworkbook, I have dates in column B and the required data values in Column d I need the codes to extract the required data values (i.e.in Column D) from the master...

Hi everyone, I have a single column of data in Column A that looks like this: Joe Joe Joe John John Josh Josh Josh Josh Can someone please provide me with code that would sum the number of Joes, Johns, and Joshs and put the sum for each name in the adjacement column. Thank you in advance...