macro code

Hello, The below macro is assigned to a button on the ribbon and works on the "current 6 months" sheet. It looks down column B for "terminated" and deletes the row. It's currently restricted to only work on "current 6 months" sheet. Is there any way to add another sheet "Previous 6 months" to...

I have a excel sheet where in Sheet 1, data start from B3 and in B3, the data are like 7, 131, 221, 222, 223, 224, 225, in a cell and in C3 and D3 a value is assigned against them, the cells are not merged. I want to separate the data 7, 131, 221, 222, 223, 224, 225 etc into individual cells in...

hi i have made a macro code to accept an array from an excel cell. but right now i am not able to accept a value. for ex "Series 1, Episode 4 Including the 1980s story of a campaign for a hospice to be built in the Highlands." from the above example i need to accept series 1 in an array. and...

Hello All, I have a code which is working fine for couple of files but crashing when trying to open a particular file. Workbooks.Open (UserFolder & Left(FileObj.Name, InStrRev(FileObj.Name, ".") - 1) & ".xlsm") Workbooks.Open (UserFolder & Left(FileObj.Name, InStrRev(FileObj.Name, ".") - 1) &...

Need VBA code to cap only select words that will be found throughout columns A-F and a list of the select words that the code would look for would be on a separate worksheet named “words2” in column A so that additional keywords could be added on an ongoing basis.

I have been using a code that had been working fine but with the new data I'm using it has a flaw. Below is first the actual code I'm currently using followed by an explanation of the flaw I am now encountering. Sub ConvertSelectionUpper_V4() ' hiker95, 08/27/2014, ME800718 Dim c As Range...

What i need to do is - 1. I have a base data sheet(Data) with user id(col D), Username(col F) and Reports to(col I) data of all employees. 2. i have a set of unique managers and their ids in a sheet X. 3. In sheet Y i have a list of selected managers and their ids which are not in sheet...

Hi all, I have a macro running in which I am using a UserForm with a dropdown list. The list has three options (pulled from sheet called "Daily"). The operator is required to select one from the list and then continue or cancel. The command button to continue is required to copy the option...

I Need Macro Code To Make A Button To Uncheck All Checked Boxes ... None Of The Checkboxes Are Named Please Help - Thanks :)

Hello guys, I have this macro code in Sheet1 assigned to a button named Combination. I copied the whole sheet twice and moved to end. So they have the same data content and hopefully the macro in sheet1 will work as well in sheets2 and 3. But it's not. I just copied the code from VB codes Excel...

I am trying to get a macro code to have an email generate everyday on it's own, with data that changes every day. Basically this is for work, this tracks the dates of employee's corrective action and after 91 days, the corrective action "falls-off" and I need it to generate an email with the...

<TABLE class=tborder id=post2776275 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt1 id=td_post_2776275 style="BORDER-RIGHT: #ffffff 1px solid">I need to insert 10 new sheets in a workbook, base on the value in Column B. I want to get it in a...

I recently followed the following tutorial listed below to create a "userform": http://www.contextures.com/xluserform01.html I need a simple macro to add a "previous" and "next" button(s) in the userform that I have created. The data is currently input into the userform interface, and copied...

hi there, I have read through several threads on the use of macro to assist in extracting data from different workbook to a master file. But I can't seem to find a solution that is able to assist me. I have a total of 100 files where I will like to extract selected cells from individual file...