+ Reply to Thread
Results 1 to 4 of 4

Merging cells from next rows, then deleting the rows

  1. #1
    Registered User
    Join Date
    08-03-2010
    Location
    Fife, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    2

    Merging cells from next rows, then deleting the rows

    My spreadsheet has a header record, then 3 rows per record set,
    with 7 columns per row.
    The first 4 columns are constant within each group of 3.
    I would like to append cell E3 (text) to H2, and then cell F4 ( a date) to I2,
    giving the 1st row 9 columns.
    I then wish to delete the 2nd and 3rd row of each set.
    I can do all this manually, by concatenating, copying and pasting special (values),
    and then sorting to identify and delete the necessary rows,
    but would obviously rather automate the task.

    I have never written a macro before, and suspect I need one to accomplish my task.

    Can anyone advise this novice how to go about this ?

    Many thanks

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Merging cells from next rows, then deleting the rows

    Why 3 rows per record? All records should be on one row
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    08-03-2010
    Location
    Fife, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Merging cells from next rows, then deleting the rows

    Hi Roy
    I have no control over the data : it is coming to me like this from an external application.
    Best Regards

  4. #4
    Registered User
    Join Date
    08-16-2010
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Merging cells from next rows, then deleting the rows

    Hey Grinder, this would be no problem to do in Excel, but would you be able to attach an example of your file so that I can reference everything correctly, I do not want to work blindly on this only to find out your sheet looks different and the referencing doesn't work.
    If you can do that then we should have this sorted quickly.
    Lemme know,
    Dan.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1