Hi
I have one spreadsheet which lists the name of schemes and various project attributes and another spreadsheet which has the name of the schemes repeated several times as it involves different information. I need to add the info scheme info from spreadsheet 1 on to spreadsheet 2 but the info is on 1 line per scheme on spreadsheet 1 so needs to be duplicated on spreadsheet 2.
Sorry, found this difficult to explain but have attached examples of what I mean if this helps. I know I can filter and drag across the information but this is going to more time than if I can just use a formula.
Many thanks
Bookmarks