2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to confront multiple sheets against each other?

English is not my first language, if anything doesn't make sense pls ask.

I am currently trying to filter a bigger excel for a conference programm, their file was divided as such sheets:

Day 1, Day 2, Day 3, Day 4 -> this containes, for each day in the title of the sheet each conference title for a given room at a given time.

I created other sheets, which i named as the main topic.

for example: Hybrid if the sheets containes mentions of hybrid as a word in the session or title of the conference.

I am now stuck, since I only searched my main interest and created new sheets only for the word I choose. I now have a incomplete subdivision, since I didn't copy each and every conference.

I would like to create a new sheets named OTHERS in which I import any conference I don't have in the specific sheets I created.

So for example if in Day 1, row7 column 15 never appear in each new sheets I created (hybrid, liquid, ...) I want that row imported in the sheets OTHERS.

Is there a way to do this, even only by finding the single row# column# and then I can manually create the table for the new sheets OTHERS. Or I just need to filter manually or use an AI (which i don't like to do since I want to use excel if possible)

submitted by /u/Candid-Note6320
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#google sheets
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#row zero
#rows.com
#real-time data collaboration
#real-time collaboration
#natural language processing
#Excel
#conference
#sheets
#Day 1
#Day 2
#Day 3
#Day 4
#filters
#import