Excel list base
Hello everyone, I need some help preparing some spreadsheets. So I have two workbooks, one has
Room #Item NamePropertyaaaaaaaaabbbaaacccbbbdddccceeecccfffcccgggdddhhh
And my other workbook is split into sheets so there is the master sheet and sheet aaa for room aaa, sheet bbb for room bbb and so on. The sheets are all prepared and there is also a cell with the room name on each sheet so the room can be referenced from there.
Room:aaa ItemPropertyaaabbbccc
How can I make this list in my second workbook that lists all the items that are in the same room? Any ideas?
Hello everyone, I need some help preparing some spreadsheets. So I have two workbooks, one has Room #Item NamePropertyaaaaaaaaabbbaaacccbbbdddccceeecccfffcccgggdddhhh And my other workbook is split into sheets so there is the master sheet and sheet aaa for room aaa, sheet bbb for room bbb and so on. The sheets are all prepared and there is also a cell with the room name on each sheet so the room can be referenced from there. Room:aaa ItemPropertyaaabbbccc How can I make this list in my second workbook that lists all the items that are in the same room? Any ideas? Read More