Selective data transfer

Hi,

I am looking for some help to transfer data some data from one sheet to another. These sheets are currently printed and then manually filled out.

The data is on Sheet1. The info on Sheet1 will continually increase. I am therefore trying to find a solution where I can select any given row to populate the details on Sheet2 and 3. (I am unsure if this is possible but am trying to find out)

Rather than completing each individual (horizontal/row) line manually to a printed version of Sheet2 and 3 I am trying to find a way to get them to populate automatically.

The solution must work in Excel 2003.

Log example.xls

I need a need a function that allows me to select any row on Sheet1 to then populate certain cells on Sheet2 and 3 (on Sheet2 and 3 I have highlighted the the cells in yellow that are to be populated and have also included some notes which may be useful).

Perhaps a function can be added into a cell at the end of each row of data on Sheet1 with the idea in mind that when a row is selected it will populate Sheet2 and 3.


Any ideas or solutions are appreciated

Hi,

Hopefully this attachment can be opened.

Thanks

Hi thanks for your replies.

FDibbins; I like the idea of the drop down filter that then populates the other cells. I do not understand the formulas as I am not very experienced. It maybe a little difficult to find the right customer as the data grows though. If you can develop this idea at all I would really like to see it.

protonLeah; I am struggling to open your attachment properly. It will only open in "read only". I have no managed to make it print anything yet but can also see how this could work well. If you can still help or provide solutions that would be great.

Thanks

I'm sorry, I can not see where you have edited.

Thank you very much. I can't see too well what you have done for me at the moment as I am on my smartphone .

I shall however check it out as soon as I can.

Thanks once again for the time you have invested helping me.

Kind regards,