Hi, I have read through the related posts but failed to find what I am looking for - I sense it's a very simple solution :-)

When I use column filters in Sheet 1, I want the data from the first record only to be passed into Sheet 2 not in the same row formation, but into different cells .

Example:

Sheet 1 (filters applied on 'name', 'age', 'colour')

Name Age Colour
Rory 10 Green
Tim 11 Red
Janice 10 Red

.... when I select the red in the colour filter, 'tim, 11, red' appears as the first record.

Meanwhile, in Sheet 2, I want the name to appear in cell D3, age to display in E8, colour to appear in B1. Does anyone have a VBA script template out there that will help? I shall pray day and night to the VBA script lords for an answer....