Hi There,
All / any help or tips are really appreciated.
Log example.xls
I am looking for some help to equate certain details that need to be populated on Sheet2 and Sheet3. These sheets are currently printed and then manually filled out.
The data for this can be found 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 is exactly what I am asking)
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.
I am not very experienced with Excel 2003 (nor later / earlier versions). The solution must work in Excel 2003.
I need a need a function that allows me to select any full row, when I like, to populate the info required on Sheet2 and 3 (on Sheet2 and 3 I have highlighted the the main areas in yellow and have also included some notes which may be useful) these sections are what needs to be populated from the info on Sheet1.
The end result is would like is to be able to print Sheets2 and 3 with the fields required populated automatically. Perhaps a column can be added vertically at the end of the data on Sheet1 with the idea in mind that when whichever row is selected it will populate Sheet2 and 3.
Although the out line of what I require is long I hope it helps clarify my issue. Thank you for anyone who can take some time to help.
Alan
Bookmarks