Sep 17 2017 11:27 AM
I wonder if anyone can help me with the following, i have a summary supplier sheet with rows of supplier information, then i have 7or 8 other supplier sheets e.g. Supplier a, supplier b, supplier c etc. i want to link the various supplier rows of data from the summary sheet by supplier name into the individual supplier sheet e.g. Supplier a, supplier b etc. Whats the best way of doing this? I have tried using 'if' formula although it becomes very messy on the individual supplier sheets; e.g. In 'supplier a' sheet say row 8, 10 & 11 link through ok from the summary sheet, however all the other rows on 'supplier a' sheet have 'false' in all the other cells. So looking messy and difficult to see the data. Does anyone have any ideas? Or a better formula i could use?
Sep 18 2017 07:53 AM