Hi all,
I work in the transport industry, and am trying to create a database of movements carried out by specific vehicles. What I need to do is transfer all data in the related row to the relevant sheet, if the column with the vehicle registration on sheet 1 matches the sheet name. I have alread inserted formulaes to do this, but it is very tedious and not very neat (leaving spaces between each movement). I also find that if I insert or delete rows on sheet 1 all the formulaes on the related sheets are changed.
Please help!
Bookmarks