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

Want to copy data from master sheet to seperate sheet

Hi,
I am an excel newbie and I would have added a screenshot but it is all in Dutch.
I am in charge of the guestlist for a big company multiple day event in October.

Right now I have everyone in one sheet with their names and contact information and also a column (M) which is the day they will be invited for the event. it's either on the 30th of september, 1st of October or the 2nd of October.

I do not know if it is possible but I would like to have the whole row copies to a different sheet when I fill in the date they would be invited on.
So if person A gets an invite for 30/09, I would like the full row of their information to be copies to my different sheet that is specifically for all the guests of 30/09.

This way I have my own sheet with everyone that is invited from 30/09 until 02/10, and then different sheets per day.

Is this possible to do this with a formula or something more automatic instead of copy pasting the lines myself?

Thank you

submitted by /u/Necessary_Fennel581
[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
#generative AI for data analysis
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#Excel compatibility
#row zero
#Excel alternatives
#big data management in spreadsheets
#rows.com
#big data performance
#AI formula generation techniques
#google sheets
#formula generator
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#data analysis tools
#data cleaning solutions