Forum Discussion
Data reporting with main sheet and divisions
Hi all!
I want to connect data and information regarding staff from the main sheet into tabs that separate them into divisions. Until now, I've been copying and pasting the row starting with the division number. Is there any way that this could auto populate with the corresponding information into each division sheet from the "Main" tab? I pulled a few lines into each tab to show what I'm trying to do.
I also have a sample spreadsheet of this data, but not sure about how to attach.
Much appreciated!
Julie
- What is a fix around if a formula displays .xln and I have a 2016 version of excel instead of 2019?
- depends on the function and formula. For example if the formula uses XLOOKUP then you could replace it with VLOOKUP or INDEX( MATCH () ) depending on the conditions. I suggest submitting a new thread/post, describe the problem and include the formula and attach the sheet if possible.
- Thank you! This is in regards to the same sample sheet you helped me out with last week. The formula for the filter function on Div 5 is not carrying over to other tabs on the spreadsheet. I was wondering if it's my version of excel that is causing this filter function be to be invalid.
- Almost certainly it can. If you have OneDrive or SharePoint you can share a link to the sample worksheet. If not you can share using a private message (click name then click message). i would consider using pivot table or power query is possible but dynamic arrays and functions like FILTER() can also work. It is just hard without seeing what you have and what you need to give you a better answer.
- Thank you!! I messaged you the sample worksheet.
