User Profile
MPulse4
Copper Contributor
Joined Dec 25, 2022
User Widgets
Recent Discussions
How to create master database with separate worksheets?
So a weekly spreadsheet is created with a list of dates, names, times and notes. I have finally added all separate sheets (copied & paste) onto one workbook however seek to find an efficient way to add the information onto the master workbook without copying manually. I also seek to gather all information from the separate tabs together onto a master sheet. I like to apply a filtered formula that also distinguishes duplicate names and remain aligned with new adjustments/information over time all onto the master sheet. I currently use microsoft 365 - I am open to use formulas / vba as an option. See images attached here of my current layouts - any help much appreciated.Can I use Filter based on drop down list?
Hi, would there be a function I can use to summarize an overall list of selected names from the drop down (red highlighted area). I would like to create a overview and eliminate possible duplicates from the row of drop down names. (currently using goog spreadsheet)Re: Summarize list based on value?
Thank you for the assist. I am using 365 - the filter formula works great on the row with the names and notes however the notes are not appearing in the section next to the filtered names. May please advise. Thanks so much again for the help. (img is attached) OliverScheurich
