Need Macro that arranges data from one sheet onto other sheets based on criteria

I need either a macro or a formula (preferably a macro button) that will take the information on the data sheet and organize it onto the destination sheets (sheets2,3,4,5). I want it to check if the data says "prepare",if it is true to than I want it to sheck if the date is equal to or less than 4 days from the date in cell B3 on the destination worksheets if it is copy the data from the matching row cells 1,2,3,4 and paste it on the table starting with cells A6:D6 on the sheet that matches the desk# in cell B3 on the destination worksheets. If not I want it to check for any other data that has a date matching exactly the date and then copy and paste that info as well. PROJECT1.xlsx

Your post is rather confusing. Try this:

Please Login or Register  to view this content.

Yes this works for prepare and gives me those values if the value equals prepare and the date is within 4 days of the date... This is great that works. Now where I may have been confusing you is I now need it to return the same type of info on any other type of cell that has the SAME date. So, in essence I'm looking for accounts to prepare to show on the sheet 4 days prior to the date given every thing else i want it to show on the exact date given. Sorry if my explanation is confusing I just dont know how else to explain it... But part 1 works to a tee it's just now I need to return the values for everything other than "prepare"

How would that work? On your example workbook all the destination sheets have the same date?

all the destination sheets will have the same date... it's the date on the original data page that has the differing dates. So anytime anything on that sheet matches the date on the destination sheet it puts it on the correct sheets table...

So 1 row on the data sheet may go on all 4 of the others? Even if it says Submit or Delete in column D. Example; Row 25 would be copied to all the other sheets.

No, row 25 would go on sheet SHH bc the date matches exactly. they still need arranged by desk# it is just that ones marked as "prepare" need to show up on earlier dates, which is the part that is working great it is the "row 25" example that is not showing up

Try this:

Please Login or Register  to view this content.

Yes!!!! Thank you this works to a tee!!

You are welcome and thanks for the rep.

I have just fixed the typo, so copy the code again....

Okay, it was working and somehow I broke it by changing things... However, it was working fine and then it stopped somehow. I made it to where I am pulling my individual sheet data from a primary table so that changes to # can be made quickly if need be. I am getting an error13 and it highlights the problem code. I'm sure this is probably an easy fix PROJECT2.xlsm