bloodybrit90
Board Regular
- Joined
- Jul 18, 2011
- Messages
- 111
Is it possible to do the following more easily.
Sheet1 is a summary sheet that pulls basic information for each vendor from 8 different sheets. The 8 different sheets have the exact same layout and contain more detailed information. I need to be able to change the order of vendors on the summary sheet without having to copy and paste values. Each vendor is listed directly under the other. The only way I know is by referencing a cell that has the order of the vendors that I want.
sheet 'Summ_order' will have all the vendors B2:B12
Name:'summ'B18='summ_order'B2
All other info for 1st vendor:13R x 24C =if('summ'B18='CMA1',do this formula, if('summ'B2='CMA2',do this formula...........)))
I would then need to add this to all cells for each vendor. Does anyone know of a faster way to do this? Can you name the range of cells and use one =if formula to select the order?
Sheet1 is a summary sheet that pulls basic information for each vendor from 8 different sheets. The 8 different sheets have the exact same layout and contain more detailed information. I need to be able to change the order of vendors on the summary sheet without having to copy and paste values. Each vendor is listed directly under the other. The only way I know is by referencing a cell that has the order of the vendors that I want.
sheet 'Summ_order' will have all the vendors B2:B12
Name:'summ'B18='summ_order'B2
All other info for 1st vendor:13R x 24C =if('summ'B18='CMA1',do this formula, if('summ'B2='CMA2',do this formula...........)))
I would then need to add this to all cells for each vendor. Does anyone know of a faster way to do this? Can you name the range of cells and use one =if formula to select the order?
