Hi all,

so I've posted about this before on reddit and other forums with no avail but I'm really up against it now so I'm hoping someone can help me or at least point me in the right direction as I'm totally out of ideas and as much as I try I don't have the knowledge to get this to work myself.

so I'm trying to figure out a macro that would automatically move data based on two separate cell values in the same row, cell G representing the day of the month (1st, 2nd, 3rd etc.) and cell F representing the REG of a vehicle.

a little bit of data about my workbook, the sheet I'm trying to move data from is called BACKING DATA 1

then I have 31 sheets labelled 1st to the 31st which are the destination sheets for the data I'm moving

using these cells the macro would move that row (just cells A-G) to the relevant sheet in the relevant area on that sheet, so lets say cell G was the "1st" and cell F was "YSK" then that row would be moved to the sheet labelled "1st" and to the next available row starting at AG48 (I've attached a screenshot of what a sheet for each day would look like for cell references of each REG)

again if any one can help me or point me in the right direction i would be extremely grateful

backing data 1

1st page