(without the rows 5:7 stuff - that was me testing).
This is needed because Excel does not like using table ranges for data extractions, but the good news is that your range name will automatically expand with the table rangeģ. Highlight the whole table and give it a range name - I've used 'People_Data'.
Make your data a Table as this allows auto-expansion of the data references as you add new entriesĢ. I'm hoping there's a formula or some sort of process to have it transfer!ġ. Please let me know if I need to provide more information. The other three tabs are exactly the same only that's where I want it to auto generate based on who it's assigned to. I'm pasting it in here of the main tab/spreadsheet and a copy of the tab section Hopefully this makes sense.I have a copy of a 'fake' one that I can share (I've never posted a question on here so I'm not 100% sure of the format process to attach it). It's actually all done alphabeticallyīy the client's last name.so it'd be even better if I could just say something to the effect of if the client's name (column B) starts with A-I paste whole row into this tab, if client's name starts with J-R, paste whole row in to this other tab, etc. I created an extra tab that has their first initial and was thinking of somehow using a IF column M has "L" paste whole row to this tab, if column has "A" paste whole row to this other tab, etc. Individual tabs can pull the information from the main tab to theirs? Is it possible to create a formula where the I'm wanting to create individual tabs where they can look at just their own information (versus sorting the main tab by individual). I have a main spreadsheet that has several all my employees caseloads on it.
0 kommentar(er)
