Highlighting and moving rows within a spreadsheet after a date is added
Hi,
I have an excel sheet with 8 columns and about 200 + rows. When I add a delivery date in to the 8th column in an ideal world I'd like the whole row to become highlighted and then moved to the top of my worksheet in date order. Is this asking too much of excel?
I'd like all items that have a delivery date moved out the way so I can concentrate on what is left in excel. I hope this makes sense?
Many thanks for your help
Regards
Faye
Last edited by fayec; 06-30-2020 at 08:36 AM. Reason: Change of title
Administrative Note:
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hopefully my new title is ok now? Sorry about that
Regards
Faye
Yes, thanks.
This could be done, but you'd have to use VBA and a macro enabled file to accomplish it.
If that works for you then I could write some code for you.
BSB
Moved to the VBA section.
In the attached I've added the below worksheet change event code. See if this works for you as a starter for 10.
BSB
Please Login or Register to view this content.
That's super thank you. How do I transfer this rule to my work sheet with the 200+ apologies I'm not very good with excel and still learning.
Thanks
Regards
Faye
Hi,
This sounds interesting but I must be honest all this is new to me so I don't know what VBA stands for. Sorry
Regards
Faye
VBA = Visual Basic for Applications (aka code).
Copy the code from my previous post, open your workbook, right click on the tab at the bottom for the sheet you wish it to run on and select "View code".
Paste the code in the window that opens then click X to return to the sheet.
Save the file with a .xlsm extension and you're done.
BSB
Thank you, I've followed your instructions but its not sorted my deliveries to the top, do I need to do something else?
Thank you
Regards
Faye
Would it be possible for you to attach a desensitized version of the file? Easier to find out why it's not working that way.
BSB
Hi,
I've attached the excel sheet that I added the code to.
Thank you
Regards
Faye
Hello There!
I followed this thread and tried out the code that you mentioned. It worked for me provided that my data is entered starting at the top row of the worksheet. It doesn't seem to work for me if the data is entered randomly in the middle of the worksheet (see attached worksheet), even when I change the code to select the correct ranges? Can you please help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks