condition copy paste

  1. A

    Copy Data from One sheet to another based on the condition column

    Hi, I need help, please. I saw a few options but nothing worked so far. My problem is this: I work with two sheets on the same file, "RawData" and "FinalData" RawData is summarized data from PowerBI and it varies in the number of rows. I added a column on that sheet with a condition, with Copy...
  2. N

    Copy/transfer rows to multiple worksheets based on a condition

    Hi, I have a similar issue to the one in this thread: <VBA> Copy rows to multiple worksheets based on a condition Only I have a different condition: I don't want it to copy the same rows from the master sheet and paste it at the first blank row. So either it has to: Not copy over the same...
  3. M

    Copy specific cells based on input value in another sheet, and paste values to another sheet via VBA

    Hello, I have an area of calculated values for 7 areas in columns from V7:AC7 on sheet "LastMilePOBoxSummary." U7 is "Week" with the corresponding weeks of the year listed in each row. So, each RC contains the Last Mile % data point for each area for each week. I want to, using the...
  4. N

    VBA - Copying part of a row to matching column headers

    I have code to copy rows of data to another sheet if the cell in column L equals "High" or "Extreme". I'm unsure how to copy only certain columns of that row to the new spreadsheet, which has matching headers in place. I'd like to either copy columns 2, 3, 6, 12, 14, 18, and 21, or have the code...
  5. R

    Inserting excel tables into specific locations in a word document using VBA

    Hi, I have been trying to insert four excel tables into a single page in a word document; to be placed at specific locations. The issue I'm facing is that the code until the selection of summaryVal works fine; but nothing after. In spite of setting the right table from excel when I paste it in...
  6. O

    Copy rows to current sheet if condition meet

    Hey guys, I am wanting to copy certain rows (which meet a condition) to the current selected sheet in an excel document, to create a daily report of current jobs. My work flow is: I have a register which each work request goes in. Each request is assigned a status, whether it is an "Open"...
  7. L

    Copy conditionally and paste conditionally

    Hi Guys, I want to copy a range conditionally and paste conditionally and hoping that some1 would kindly help me outta er, Condition to copy Match the value from CopyTo sheet in ColA with the CopyFrom in ColA. Condition to paste Paste if the value is true See Example below <tbody>...

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
Back
Top