excel-vba excel macro

Hi Team, I am pretty novice in vba coding and trying to learn in by recording macros. I have come across a situation where macro recording is failing to fetch me the outcome. Scenario: I have data say in Sheet1 in column A,B & C. Now I want the data of A1,B1,C1, to be pasted in Sheet2 cell C3...

<tbody data-remaining-comments-count="0" data-canpost="true" data-cansee="false" data-comments-unavailable="false" data-addlink-disabled="false"> <tbody> </tbody> I have a series of check boxes on a sheet called "Resource Estimator." The user clicks the boxes that apply and based off the...

Hello I have a formula which is returning me #NAME? The code is: Range("FJ2:FJ" & LR_CompID).FormulaR1C1 = "=VLOOKUP(RC[-2]," & ("FQ" & LR_FP + 1 & ":FR" & LR_FQ) & ",2,FALSE)" and the formula appears as: =VLOOKUP(FH2,'FQ13':'FR15',2,FALSE) Question: how do I paste without the ' either side...

I have limited experience with vba. I know how to create variables and print out a few things, but what I am looking to do is slightly more complicated than that. I was able to create an excel formula that looks at a list and returns the value for a corresponding row, column by using the index...

I hope you can help. I have a piece of code. Essentially what it does is, it opens a dialog box that allows a user to select an excel sheet, then it goes out to the country column (11) filters it, then copies and pastes that country into a new workbook, names the new workbook after that country...

I have a user form that accepts user input and is supposed to put it on a worksheet. The form control has 2 textboxes, and IngredientName and Percentage. The user enters info into these boxes and clicks "Add Ingredient". This is supposed to place IngredientName in Cell G10, and Percentage in...

Hello, Please help me in modifying the below code. I have a code that will help me in renaming tabs based on values in 2 cells (drop down list). Now, I have to replace drop down list with Combo Box. I m not sure how to modify the code that will help me to do same task I used to do using drop...

Good morning, I am building a macro that will find a certain text from cell A2 sheet named Committees withing the range of P2:CP5000 in sheet called database, and return data of column A:O in the same rows from all the rows that contain this text string, and print it out on the sheet called...

Hi, everybody! I am very new to excel vba and macro. Here is the situation I have now: I created a data validation drop down menu that contains a list of names, which I expected to summon an unique macro that is linked to it. The data validation code is as below: Option Explicit Private Sub...

Hi Guys, I have the following string: <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space...

I have a folder with 5-6 workbooks and each workbook has multiple worksheets. I am trying a code to loop through the sheets in each workbook in that folder (which ever is selected on running the macro) copying the data from B:H and pasting the data in Mastersheet with Sheet1 name as...

I would like to compare rows in two different sheets, highlighting the differences, and counting the number of differences. I'm using Windows 7, Excel 2013, and am new to VBA. First worksheet is like this : The second worksheet is like this : The second worksheet's name matches a string...