Copy Information into a template

Hi All,

I hope I am posting in the correct place.

I know exactly what I want to do, just no idea how to do it.

Please see Tab 1 shown here:tab1.jpg. This tab holds all the data needed. As you can see, there is 2 command boxes (Let1 & Let2) on each line of data. My data runs up to 400 rows at any time, I have cut the info down for this demo.

When the Let 1 command box is pressed, I would like the relevant information feed into Tab 2 from that row. So for example, if i press Let 1 situated in A3, information for Emma will pull through to Tab 2. Tab 2 is shown here:tab2.jpg.

Tab 3 works in the same way, but i would like that to populate when Let 2 is pressed on a row. Tab 3 is shown here:tab3.jpg.

I hope this makes sense.

Any help at all on this would be appreciated.

Thanks in advance,

Emma x

Hi,

Does anyone have any ideas on this please?

Thanks

I want to be able to learn the answer and apply it myself, rather than someone doing it for me. It also has lots of other data on that is not fit to be shared.

Im guessing no-one has any ideas?

Never mind, I will try and get an answer from somewhere else.