paste based upon criteria

  1. S

    Matching values between sheets and then replacing VBA

    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...
  2. L

    Excel formula or VBA to paste list of data from reference worksheet if specific text is selected in data worksheet

    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...
  3. S

    Macro for Copying and pasting pivots but how do i format?

    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...
  4. A

    Find and copy corresponding value to another cell on another sheet

    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...
  5. T

    paste cell in another sheet in a specific range based upon criteria

    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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top