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
Bookmarks