I'm trying to creat a summary sheets for all the weeks in a year that fall between a certain number say 1.5M and 2M units. My spreadsheets has 52 weeks Sunday through Saturday. Based on the volume for the week I want to be able to break the weeks up on a new sheet so I can compare weeks by weekly volume. Can I do this with a macro (I'm not great with code), conditional formatting?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Create a separte worksheet for a range of cells based on one
- Thread starter afs24
- Start date
Similar threads
- Question
- Solved
