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?

Does this work?

Please Login or Register  to view this content.