paste based upon criteria

I need to search the 2nd column of the DATA tab and see if it matches the first column of the INDEX tab. If so I need to replace the 2nd column in the DATA tab with the value in the second column in the INDEX tab and then scroll through all rows of the DATA tab and do the same thing example...

Hi, hoping someone can help as I cannot find a solution at all. I have a workbook with two sheets. One is the active data sheet (sheet 1), the other is a reference / list (sheet 2). Sheet 2 details across the columns (C:E) the 'Types', and below each type, lists the Tasks for that type (used...

Hello, I have created a macro that pulls numerous pivots into a new tab - in the new page the values seem to be coming across as paste 123 ( no formatting). I want to add some colors so i was going to color the pivots and let the macro pull across the data and formatting. To do this i thought...

Hi, I need assistance with my code as I am struggling to find a solution. I eventually split the array in two as I was getting an error. I am searching for words in sheet "ServiceType_SubType_Item_byComp" and copying the offset value to sheet "Charts", but often there are two cells with the same...

Hi, I am new to VBA and have a question. I am using sheet 1 as a General Journal and sheet 2 as a summary showing each entry that matched each category. Sheet 1 will have journal entries in column F (Rent, Cash, Accounts receivable etc.) Column J will have the debit amount (integer) and K will...