merge records

  1. E

    Macros to append/merge records

    Hi - Fig. 1 below shows what I am trying create in Excel using a marcos. Rows that are populated in Columns A-D are primary records. Rows populated in Columns E-H are the secondary records appended to the primary. A row/space is added under the primary records starting with the 2nd secondary...
  2. S

    Comparing two lists to find missing fields or duplicates

    Hi, i have a two list of say phone types which i want to merge into 1 list. in 2003 is there any formula i can use to highlight phone types that appear in the two lists?
  3. B

    'Merging' 10 Workbooks - HELP

    I have 10 Excel Shared Workbooks, all in the same format, but with different result information. Each workbook has 16K rows of information, the basic information is the same. For reporting purposes I thought I could just 'merge' the workbooks into a master report so that I could monitor the...
  4. S

    VB Code to merge records by groups

    I am very basic in VB coding so appreciate if you can provide more details I have a table with records with a group ID. So a group ID can have more than 1 records. I want to merge these records in 1 row such that other values of the records are combined in one row only. Example of table T1...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top