Results 1 to 5 of 5

Auto insert of rows

Threaded View

jhelliar Auto insert of rows 08-18-2008, 02:17 PM
VBA Noob Maybe Sub InsertRow()... 08-18-2008, 02:26 PM
jhelliar Many thanks for that. Can ... 08-20-2008, 03:23 AM
VBA Noob With the data provided you... 08-20-2008, 04:21 AM
VBA Noob Or with code Sub... 08-20-2008, 04:31 AM
  1. #1
    Forum Contributor
    Join Date
    09-21-2007
    Posts
    196

    Auto insert of rows

    What I need is a simple macro that looks down one column in a page and if the content of the cell is different from the one above it inserts a row. So say column B reads 1,1,1,1,1,2,2,2,3,3,3 it would insert a row between the 1s and the 2s and the 2s and the 3s. This is so I can group together sdimilar data. I have given a brief sample sheet of what I would like. Could someone please give a rough idea of how I can do this?
    Many thanks,

    Jack
    Attached Files Attached Files

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