Years ago I created a database of my boss’s clients. I always add a new client when we open a new file. It seems that in the last several days, any new clients I enter are saved out of sequence. I need to give you some specifics to explain this, I think. I use columns … Read more
I’m struggling on how will I sort the sheets after combining all workbooks into 1. here’s my code: Dim wbDst As Workbook Dim wbSrc As Workbook Dim wsSrc As Worksheet Dim mypath As String Dim strFilename As String Dim saveFolder As String Dim i%, j% Application.DisplayAlerts = False Application.EnableEvents = False Application.ScreenUpdating = False Application.AskToUpdateLinks … Read more
Using Windows 7 I have a folder with several thousand sub folders. Each sub folder may have subfolders of files. A Music Library Might be a good example. I need to sort the top most subfolder and its contents to another location and group by first letter. Example. source d:\Music\Abba d:\Music\All-in-one d:\Music\A Artist d:\Music\B.B. King … Read more
I have a column like this RA1 RC4 RJ9 RA3 RA2 RA10 RD14 RA11 and I want to get RA1 RA2 RA3 RA10 RA11 etc.. Not RA1 RA10 RA11 RA2 etc… There’s any way to change the behavior? Answer Sorting a column or row that contains content that is NOT pure numbers. The vastly easiest … Read more
I am struggling to group cells together in excel and sort by a different criteria. I work for a telco company and look at repeat trouble tickets. I would like to group the rows together based on account number in column C while sorting column A which is the technician who completed the ticket. I … Read more
I need to print a list of files to a text document in the same order they show in the windows explorer alphabetic sort, but I can’t find any method of sorting with ls | sort that shows the exact same order. Files that start with brackets show first in the windows explorer, followed by … Read more
I want to create a list which shows the latest date that someone sent me a message on Linked In. I have exported the data, in the following format, and there are multiple entries for individuals who have sent me messages in the past. I want to get the latest message date from each person. … Read more
For security-reasons I want to decompose PDF-files and put them back together (like printing them and scanning them back in). I want to offer this for my users, so I would like to script a kind of hotfilder-solution. While writing this question, I almost figured it out myself. There is just one glitch: convert (the … Read more
I have 2 data sets A-Q (left) and U-AA (right) I am trying to match the rows on the (right) U-AA with the rows on the (left) A-Q Once a record on the right matches the first like record to the left then it would skip to the next one to find. I manually inserted … Read more
Is there a way to sort a list by the first LETTER of a cell rather than the first NUMBER. I need to sort a list of addresses by the street name not by the street number so I can see the multiple properties on a specific street. Instead of the numerical sorting: 123 Smith … Read more
