Results 1 to 7 of 7

Copy range and paste to next empty row in a defined row or area

Threaded View

  1. #1
    Registered User
    Join Date
    06-04-2012
    Location
    Sheffield, UK
    MS-Off Ver
    Excel 2003-2010
    Posts
    56

    Copy range and paste to next empty row in a defined row or area

    I've been looking in various forums to help with this however there isn't anything exactly what I need.

    I have a report that I need users to enter information into, cells b3:f3. once all the data is added I need them to click a button to add that information to a report that is contained on the dame sheet. The tricky part is I need the macro to copy b3:f3 and paste it into the next empty row, however it needs to be within a range depending on what "Typ" is entered. In the example book attached, if the type selected was "General" I want the data to be copied and pasted into the "General" or rows 8:17. If the type is Specialist then it needs to be copied to the Specialist section or rows 20:29.

    I am trying to update a report that was created by someone else however they are no longer contactable and the book they created where this macro works is password protected so I cannot view their code to see how it was done.

    Thanks for any help, and please contact me if you need more of a description of what I am trying to achieve.
    Attached Files Attached Files
    Last edited by JimmyG.; 10-09-2013 at 05:59 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Paste a value in the next empty cell for a defined range
    By aadeshgandhi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 08:53 PM
  2. copy and paste to defined area
    By twofootgiant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2011, 08:28 AM
  3. EXCEL 2003 copy paste a defined range in a cell
    By EXCELNOOB123 in forum Excel General
    Replies: 1
    Last Post: 03-07-2011, 10:01 PM
  4. Finding a defined range of cells then Copy & Paste
    By bernborough in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-11-2010, 06:45 PM
  5. Replies: 0
    Last Post: 02-24-2005, 04:06 PM

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