As a newbie here apologies for asking what’s probably a basic question but to date I can’t find a solution and hoping someone can help. Briefly I’m transferring ships arrival data from old WW2 books (for our local port) onto a spread sheet with cell headings for Name, Built, Where Built, Length, Grt, Callsign and so on. There is a lot of regular traffic each month so, where a ship has been before,I want to be able to auto populate a new line with all the data already entered by simply entering the ship’s name? At present I can only auto populate the name cell, then search, highlight the entry I want, copy and paste it into the new line. With 5 years of data to enter this is obviously time consuming and I’d like to speed the whole process up by being able to auto populate the whole (horizontal) line of data by simply typing in the ship’s name (obviously this only applies to the vessels that have an entry, with detail, already).
Hoping this can be done in Excel and that someone on here can point me in the right direction!
Many thanks
Hoping this can be done in Excel and that someone on here can point me in the right direction!
Many thanks