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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top