Results 1 to 3 of 3

vba macro - search ID, copy, paste

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-28-2011
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    114

    vba macro - search ID, copy, paste

    Hi All

    The coding for my macro button does not seem to work properly, I have the following worksheets:

    - SiteDetails - this worksheet acts like a user form
    - SiteRecords - This is where the information is to be saved based on the Site ID

    The code currently pastes some information based on the correct ID but does not paste all the information...I have attached an example to illustrate my point.

    The highlighted yellow cells is the information I would like to macro to pick up, also would be helpful if the information in the check box (at the bottom of the worksheet) could also be copied through.

    Much Appreciated!
    Attached Files Attached Files
    Last edited by sgp; 10-31-2011 at 11:43 AM.

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