Forum Discussion
Match across sheets formula help
Looking for some help on this formula, been through a myriad of options but just can't figure it out. I need to duplicate the rows from B4:G4 in Master tab that corresponds with Name of tabs (just Sun:Fri). The days are in a drop down, and will change periodically.
Any help would be appreciated!
6 Replies
- This sounds do-able but a sample workbook would help. I don't speak for everyone but some of us who volunteer solutions pop in every now and then when work allows to help out. If there's a workbook setup already it makes providing a solution easier because we don't need to arrange the data.
Thank you. Please see the attached. FILTER formulas added to each sheet (Some sheets don't yet have a pull).
- What help do you need? You screenshot doesn't make sense. Attach a sample file and explain what you want.
To clarify:
This is the page that will receive the data (Master), but I'd like the row information from this sheet to populate in the tab with the corresponding Text ("Sunday" goes to the "Sunday" Sheet, "Monday" goes to the "Monday" Sheet and so forth). So You'll see Master!A3 matches with "Sunday" (see 2nd screen shot) on the "Sunday" Tab, the data from Master!B3:G3 is moved to Sunday!B6:G6 because "Sunday" is the selected day. I need that for each of the tabs, synced up with the dates in Master!A3:A100.
The day tabs (Sunday:Friday) should be the landing pages for the data and correspond with the text in Master!A3:A100.
To clarify: This is the page that will receive the data (Master),
To further clarify, when you use the word "receive" does that mean that the Master sheet is where "raw data" will be first entered. That is, is it the Input sheet? i.e., ALL data entry will be to this sheet?
I'd like the row information from this sheet to populate in the tab with the corresponding Text ("Sunday" goes to the "Sunday" Sheet, "Monday" goes to the "Monday" Sheet and so forth)
Such that these daily Activity Log sheets are solely Output sheets?
If that's the case, if both of my assumptions above are correct, then it's entirely possible that the FILTER function will serve your purpose. That hyperlink takes you to a YouTube video that introduces the FILTER function and explains it very thoroughly. It does require Excel 2021 or newer (or Microsoft 365 subscription).
If you'd like further help, though, may I suggest that you post a copy of the actual workbook on OneDrive or GoogleDrive, with a link here that grants edit access to your workbook.
