Filter issue (I think)
I have a spreadsheet that has 365 rows (one for each day) detailing sales activity (4 columns). I want to be able to filter and display the last 14 days of data, each of the 14 days being a separate row displayed below the original 365 rows.
The spreadsheet is manually updated each day.
The "rolling" 14 rows will dynamically change each day.
Possible?
Thanks in advance.
Mgalloway
Copy and paste this code into the ThisWorkbook object of the VBE. Then everytime the workbook is opened, Sheet1 will be autofiltered to display the last rolling 14 days.
Please Login or Register to view this content.
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
I get the logic of the code, but don't understand your instructions. I am a medium level excel user at best. Can you dumb-down how to implement this code into the spreadsheet. I have no idea what "ThisWorkbook object of the VBE" means.
Thanks.
No problem.
- Copy the code from the post above
- go to your workbook that you want to paste the code into
- Right click the excel icon next to the file menu item in the upper left hand corner of the screen and select "View Code"
- This opens the VBE (Visual Basic Editor) to the "This Workbook" object
- In the blank space towards the middle of the screen below the word "General" paste the copied code.
That's it. The code will do the rest when the workbook is opened the next time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks