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
[link] [comments]
Want to read more?
Check out the full article on the original site