Results 1 to 13 of 13

Populating info from one row into another row within a range if certain data exists

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2012
    Location
    Everett, WA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Question Populating info from one row into another row within a range if certain data exists

    Fellow Excel Users,

    I'm having difficulty coming up with a formula for this issue. It may be I need a VBA?
    Here's what I need to do: (Please reference attached Excel workbook)

    If "LV" appears in Column I (in this case row 3) then I need a formula to copy the information in A through G of that row, search for an empty row in 9 through 13 and paste the info in one of the available blank rows. I cannot have any existing data in rows 9-13 erased.

    Any help would be appreciated as I've racked my brain trying to come up with something that will work but have had no success.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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