copy based on a condition

  1. A

    Copy cell that contains values other than zero using macro in excel

    Hello everyone. I'm a new Excel 2007 user and desperately in need of help regarding macro programming. Right now, I have one worksheet that consists of several columns (A to J) with quite a number of rows as well. I desperately in need of help in building a macro that would enable me to...
    • Azrin
    • Thread
    • copy based on a condition copy cell from one sheet macro excel paste cell paste to another sheet
    • Replies: 6
    • Forum: Excel Questions
  2. C

    Copy rows based on criteria

    Hello, I've been looking for something quite simple, but cannot seem to get my head around this. I would like to copy a row of data from one worksheet to another, based on there being an 'x' in the first column, i.e. Column = A, B, C, D, E Row 1 = _, NL , Shop, £3m, 5Yr Row 2 = X, DE, CRM...
  3. WERNER SLABBERT

    vb to check one sheet against another and copy a field from the third.

    ok lemme Try and explain this. sheet1 has a formatted layout. cell colour functions and so forth. sheet2 has the data table. sorted according to column "A" sheet3 has a blank formatted "template" for data on sheet1 say for argument sake. sheet1 has 190 "pages" of these formatted layouts. each...
  4. C

    copy several sheets in workbook and move to one workbook

    Is there a way I can grab multiple sheets that contain the same name (in this case "*Dec*") and copy into a new workbook? This is what I have so far but it copies the sheets into separate workbooks. Please help! Dim i As Integer Application.DisplayAlerts = False For i = Worksheets.Count...
  5. J

    Selective copying macro

    Hey Im completely stuck, I need to do the following, If any cell in a range contains the word "TRUE" then the macro copies 4 cells in that row and paste special "values" on sheet 2 starting at A1 and then moving to A2 if there is something already in A1. Hope someone can help!!
  6. B

    Copy only non-blank cells

    I am looking for some vba code to help me copy the non-blank cells in the following section (small exert of the total list) and copy them to a new column WITHOUT BLANKS with the accompanying date. I am having a tough time doing that... <TABLE style="WIDTH: 104pt; BORDER-COLLAPSE: collapse"...
  7. J

    Summarising several classes of data based on condition of each class

    Hi, I have several sets of data and would like to summarise all the No's in the "Acceptable?" column (in G, L, Q... and so on) and copy the relevant rows including the first two columns (dates and days) not just for Class 1 but 2, 3... and so on, to another sheet. However, where there is no...
    • Jen C
    • Thread
    • copy based on a condition summarise data
    • Replies: 14
    • Forum: Excel Questions

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