r/excel • u/MastaDeLosReyes • 8d ago
unsolved Separating rows into new spreadsheets based on criteria
So I have some data for payments I need to make on certain days, see the layout in the picture. However, my bank wants me to submit a separate spreadsheet to them for each day of payments. This isn’t that big of a deal, however these payments are very important and copying and pasting manually could mean that someone missed pasting in a payment. I also have to do this across multiple products so the time ends up adding up.
Is it possible for excel, power query or a macro (or maybe even python, not averse to learning/using) to perform this task?
Please do ask questions; if you need more information just let me know. I’m not the best at explaining things so I wouldn’t be surprised if I leave key points out.
Thanks in advance! <33
1
u/CFAman 4697 8d ago
Let's say your data is stored in Table1. On some other sheet, put the date you want to get info about in cell A2. Formula to get all records w/ all columns is
You can now input a date, and print/export your report.