vba macro

I have two columns A & B and have data from A1:A20, B1:B20 I am using the following code 1.Column C =IF(ISERROR(NOT(MATCH(A1:A20,$B$1:$B$20,0))),A1,"") 2.Column D =IF(ISERROR(NOT(MATCH(B1:B20,$A$1:$A$20,0))),B1,"") In column C I am getting the missing numbers which I have there in Column A...

I want to copy my data of "Sheet 1" and "sheet 2" to "sheet 3" I have the following code Sub sbCopyRangeToAnotherSheet() Sheets("Sheet1").Range("A1:P100").Copy Sheets("Sheet3").Activate ActiveSheet.Paste Application.CutCopyMode = False End Sub 1. Now I want the copied data of sheet1 in...

<tbody> I have Three Sheets in excel Sheet1 - Details of collection done in different heads as per user ID with receipt number and date, heads are sports pack, entertainment pack,regional pack Sheet2 - Dues of different users with their user ID...

Sub Button3_Click() Range("B19", "B22").Copy Sheet4.Range("B" & Rows.Count).End(3)(2).PasteSpecial xlPasteValues Sheet4.Select Application.CutCopyMode = False End Sub I need only to copy the value of B19 and B22 on "Sheet4" B & C Cells respectively but when I use the above formula, it copies...

I dont have much knowledge about VBA codes I have a particular cell B19 where I put texts and the cell text changes repeatedly according to the input. I want to copy the text from the B19 to other sheet named "Print" when I click the click button. for example, now in the cell B19 the text is...

Hello, I've recently created this macro that opens, one by one, all excels in a designated folder and copies the rows from worksheet 2, to a new workbook. Every new excel rows are copied below the one before. Well, now i want to paste only the values which contains formulas. I've tried to...

Hi, Here is a code: Private Sub CommandButton1_Click() Dim varNames1 As Variant Dim varNames2 As Variant Dim lngArr As Long Dim wb As Workbook varNames1 = Array("FIRST\GRAND EVALUATIONS.xlsm") For lngArr = LBound(varNames1) To UBound(varNames1) Set wb = Workbooks.Open(ThisWorkbook.Path...

I have a simple macro to loop through worksheets in a workbook and look for the last/largest ID number (Column A) in the entire workbook. This code works periodically when running and always works when stepping through in debug mode. BUT other times when running it (even in the same...

Hi all I need your expertise in modifying/tweaking a little bit in the below mentioned code to make it work in a better way. <tbody> For Each myCell In TheRange If Trim(myCell) <> "" Then Sheets("Cover").Cells(myCell.Row, 66).Copy Range("M31").Select...

Dear All, I would request to kindly look into this issue and revert at your earliest convenience. INPUTS(Sheet name) Problem#1 Please refer Column " BN" in Inputs sheet whereas formulas are updated as Text values , below is the code that i have used : Sheets("Inputs").Select...

Hi All, I am very new for this need help. I have one excel (assignment) in assignment I have Raw data as sheet name. Raw data sheet have lot of data I need to assign individual to all employees and employees have different different naming excel copy the data from Raw data sheet and open...

Hello ALL,I have two sheets-Sheet1 has Last name,First name in one column and email address in one column.Sheet2 also has Last name, First name in one column, email address in one column and Employee id in another.I want a macro to match names from sheet 1 with two columns - Last name, First...

Hi I had a client access data transfer add in for excel 2013 that was working perfectly. Then I got a spreadsheet with a macro that I had to enable and add the Developer add in. When I went to run a data transfer, the add in tab was gone. I went to options/add ins/COM add ins and the data...

Hi, i have the below macro which takes a range of cells in a single column and concatenates the values into a single string. The string is then passed via an ODBC connection to SQL to be used as the variables the "Where" statement. My problem seems to be related to how long the string i am...

Hi All I am desperately looking for a Macro that would allow me with the click of a button to go through all the sheets of my workbook and do the following to every sheet: - ungroup columns and row - unfilter - refresh - re filter - re group from the first sheet after the sheet that contains...

I've been trying for a couple weeks to create a vba that will fill out my project calendar for me. First thing i am trying to do is have the vba find the intersection between two variable and insert a string into the intersecting cell. I have tried various things such as match, vlookup and find...

Hello I Am Looking For VBA macro to create a table. The cell Address's though for the range of the table is bassed on the text in the cells. For Example A2 = "First Word" and D21 = "Second Word". I need a macro that will look up the cell address of each of those words and then create a table...

Please help me to correct the code. the programs run and gives the correct value but it over write the previous values of other cells. please see at the bottom the input. thanks. Sub SumItems_V4XX() Dim w1 As Worksheet, w2 As Worksheet Dim a As Variant, o As Variant Dim i As Long, j As Long...

Just need a code to autofilter across selected worksheets. Already have the autofilter code just require the code to repeat the autofilter across a selected array of worksheets. Please Help!!

Hello, I am looking for some assistance with a VBA macro that will convert the text in columns "A" and "B" of my active sheet to upper case. If you can assist that would be greatly appreciated.