+ Reply to Thread
Results 1 to 3 of 3

Macro to Search Cell on Sheet1, find on Sheet3, paste other data

  1. #1
    Registered User
    Join Date
    02-13-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Macro to Search Cell on Sheet1, find on Sheet3, paste other data

    Hi all,

    Been using this forum for guidance for a quite a while and probably owe a lot of thanks to certain members so thanks hehe. Could really do with some help on this if possible.

    I am helping out a former colleague and trying to put together a Workbook for him. What i need to do (see attachment) is search by the date in Sheet1 and then find it on Sheet 3. Everytime i've done it it always keeps the date from when i created the macro so when i change the date in the box it still searches the original date and not the date i have just entered.

    Once its found the date i need it to cut the data from column G cells 15-20 and paste them in rows B-G on Sheet3 next to the relevant date.

    Is this actually possible?
    Attached Files Attached Files
    Last edited by Lennie; 02-13-2011 at 01:11 PM.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Macro to Search Cell on Sheet1, find on Sheet3, paste other data

    Does this work?

    Please Login or Register  to view this content.
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Registered User
    Join Date
    02-13-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Macro to Search Cell on Sheet1, find on Sheet3, paste other data

    Awesome, It works like a charm.

    Thanks so much for your help its very much appreciated.

    Len

+ Reply to Thread

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