Results 1 to 9 of 9

Macro to copy and paste values in a selected row

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Question Macro to copy and paste values in a selected row

    I have a database of customer details and people can use a data form to browse through to look for ID numbers. You then click on another button that has the macro i have pasted beneath and you type in the ID and it finds and selects the row it is in, i then want to copy certain values in that row and paste on another sheet in specific cells and i need this to work each time the row is different, can anyone help please???

    Here is the macro


    Sub findvalue()
    Search = Val(InputBox(prompt:="Enter Customer ID"))
    
    Columns("A:A").Select
    For Each cell In Selection
    If cell.Value = Search Then
    cell.Select
    End If
    Next cell
    
    End Sub
    Last edited by marianov; 03-05-2012 at 05:34 PM.

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