Results 1 to 14 of 14

Find and match cell text value on another sheet and paste row on correct row number

Threaded View

  1. #1
    Registered User
    Join Date
    09-11-2015
    Location
    England
    MS-Off Ver
    Excel 2010 and 2013
    Posts
    13

    Find and match cell text value on another sheet and paste row on correct row number

    Hi all,

    I'm looking to refine the macro below I have recorded to find the value on "Sheet6" in cell H3 (the name of the person) on the "Availability" sheet and paste it across from column B. However, being new to VBA in the main I am unsure how to do this. I recorded the macro using the basic "find" option but of course this only finds the name of the person I specified. Hopefully you can help.

    The info I want pasted from Sheet 6 is contained in cells B6:M6 and I want it pasted from columns B:M across the row on the Availability sheet where the corresponding name of the person is in column A. Hope this makes sense. I've attached the workbook so hopefully this will make sense.

    It's a work in progress I inherited from someone else, so eventually parts are going to be hidden, which is why the vba needs to be fired from a submit button rather than using vlookup etc.

    Sub Macro5()
    '
    ' Macro5 Macro
    
        Sheets("Sheet6").Select
        Range("B6:M6").Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Availability").Select
        Cells.Find(What:="Ullmann, Linda", After:=ActiveCell, LookIn:=xlValues, _
            LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
            MatchCase:=False, SearchFormat:=False).Activate
        Range("B38:M38").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
    End Sub
    Thank you,
    Smash.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find the row number with a partial match to text in column A
    By zookeepertx in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-10-2014, 01:39 PM
  2. Replies: 1
    Last Post: 03-03-2014, 08:45 PM
  3. [SOLVED] find text match amount and paste from sheet1 to sheet2
    By visha_1984 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 12-12-2013, 04:08 AM
  4. [SOLVED] Find match, find related cell and return that number
    By HelpHelpHelp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-17-2012, 06:46 AM
  5. Find text then paste to different sheet
    By jpthelpguy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2009, 02:52 PM
  6. Merging the correct number of cell rows to fit a string of wrapped text
    By iterature in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2007, 02:15 PM
  7. Replies: 1
    Last Post: 11-10-2005, 09:10 AM

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