User Profile
stephanieporter
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Help with date sorting macro
DevendraJain Ok so not sure it's working. The code thats currently in my work book (for column a to have date and time pickers in it) is: Private Sub DTPicker1_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) With Sheet1.DTPicker1 .Height = 20 .Width = 20 If Not Intersect(Target, Range("A115:A120,A122:A131")) Is Nothing Then .Visible = True .Top = Target.Top .Left = Target.Offset(0, 1).Left .LinkedCell = Target.Address Else .Visible = False End If End With End Sub I now need something to sort all the rows by date should we decide to change the date on something, I want it to automatically move all the content and align them in date order (if possible). There are 17 columns of information that all needs to stick together. Am I making sense? I can't post a copy of the work book as it's confidential information. Thanks3.3KViews0likes1CommentHelp with date sorting macro
Hi all, Hoping to get some help on a macro in order to sort an entire worksheet by date. I have multiple rows and the first column is the date (using a date and time picker macro). People will be going in and filling out the spreadsheet, but with each row of information, the date of that item may change to a later date. I want to have a macros where by when the date of a row is changed in column A, it moves the entire row up or down to order it in the order of the date. Does this make sense? The one macro I found is below, but I'm not sure how to change it in order to read the entire sheet and move the rows. I also already have a date and time picker macro in the sheet, so wondering would I just paste this below it? Any help? Private Sub Worksheet_Change(ByVal Target As Range) 'Updateby Extendoffice 20160606 On Error Resume Next If Application.Intersect(Target, Application.Columns(1)) Is Nothing Then Exit Sub If Target.Count > 1 Then Exit Sub Range("A1").Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End SubSolved3.7KViews0likes4Comments- 3.7KViews0likes0Comments
Re: IFS Formula and time
Thanks so much! Do you have any idea how to make column A a time only picker? I already have a column which is a date picker. I want a second date picker for column a but I want it to be time only. I'm not sure how to code for 2 different time pickers in the same project. Doesn't seem to work. mathetes3.7KViews0likes2Comments- 3.8KViews0likes4Comments
- 3.8KViews0likes5Comments
Re: IFS Formula and time
Ive just tried it in my spreadsheet and I'm getting errors! I dont know what I'm doing wrong. I just copied your formula but applied it to the relevant cells. I actually should have a fourth option ANZ 0:00:00 LON 9:00:00 NYC 14:00:00 HK 2:00:00 I also have the formulas on another tab. Is that why? I selected the tab and the right area I dont know what Ive done wrong.3.8KViews0likes0Comments- 3.8KViews0likes0Comments
IFS Formula and time
Hi, I'm needing help with a IFS and time formula. Column A = Time Column B = Time zone (so will just be a drop down box list LON, NYC, HK, ANZ) Column C = Time So basically, I need a formula that says all of the following IF Column A = LON then Column C = Column A + 9 hours IF Column A = NYC then Column C = Column A + 14 hours IF Column A = HK then Column C = Column A + 2 hours Both A and C are formatted in time. How do I write this formula for Column B? It doesn't seem to be working with the cell being in time. Thanks!Solved3.9KViews0likes9CommentsRe: Date & Time Picker Help
Hi, nabilmourad Thanks so much for your reply, however I'm doing this on my work computer and my organisation has configured our systems to block ad ins. Do you have any other suggestions? Is there a formula I can use to achieve this? Or how I can use the macros to have 2 instances of Date and Time picker in the same spreadsheet? Thanks1.8KViews0likes0CommentsDate & Time Picker Help
Hi all! I'm looking for a little bit of help regarding Date & Time picker. I'm comfortable inserting a date picker and also how to do it as a time as well. What I'm looking to do is this: Column 1: Date Column 2: Time (with time zone selector IF possible) Column 3: Australian time zone equivalent to column 2 How do I do this? I know how to date picker on multiple cells, so that is all good. But I want to separate the date and time in separate columns. The ultimate goal is to have a time picker with a time zone and then another column which will automatically add hours to automatically generate the corresponding Australian time zone. I find when I go to put a second time picker in (for the time) I can't get the coding right. Anyone can help on this? I have the correct coding for the date, but the time just doesn't work. Hope i'm making sense. Also, is it possible to select a cell with a time plus a time zone in a drop down box of some sort? Open to other suggestions on what would be the easiest way to do this. Thanks 🙂1.9KViews0likes3Comments
Recent Blog Articles
No content to show