I have a code that works partially and wonder if someone can figure out how to fix this.
1) should sort the data in sheet "Due"
3) Find the lowest 3 and paste them "Upcoming"
3) Should overwrite the previous ones on "Upcoming" Upcoming should not ever have more than 3
Currently it collects the data and puts it the correct sheet but doesnt overwrite the data and does not sort the data prior to copy and paste.
assignments-2 ver 1a.xlsm
Thank you for looking
Hi Mr_Bill
In your Sample File will the results look like this?
Upcoming Assignments Writing Essay Writing Essay Writing Essay
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Yes, but one thing I forgot to mention is the results will be in E2:H6 instead of A2:D6
Hi Mr_Bill
That's a pretty critical "forgot".
In an attachment, show us the Structure of your Actual Workbook and the Structure of your desired Results.
okay assignments-2 ver 1a.xlsm I moved the upcoming area to E:H It is going to change when you open it since it keeps adding data
Here is screenshot of how it should look. Upcoming.PNG
I am going to abandon this idea. Was able to edit the columns which was rather easy but no clue how to make it show only three results and over write the old ones when the sheet is opened again. Seems this is a tough one to do. So marking this one solved for now maybe someday I will pick this project back up and try to get this fixed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks