stevetodd400243
New Member
Hello, I am searching for a way to have any rows of DATA copied from one Report Sheet to another Sheet to showcase the totals for the week selected. For example if a user selects Week# 20 from sheet1 Cell B2 on the attached Example any rows with a Ship Date between May 08 - May 14th, Column H from "Data" Sheet on the attached would copy over to showcase the totals for that week. Then Clear when another week is selected and show that Weeks Data. Sound Possible? Please let me know if this explains what I am Looking for.