1. W

    Reorder Hidden Sheets

    I have inherited a file with 200+ hidden sheets, linked and summarized on a "Summary" tab. Every so often I need to unhide 1 or 2 sheets to review, and then re-hide. My problem is, when I right click to un-hide the list is not in numerical order. Does anyone know how to reorder this list? Thanks...
  2. C

    reorder point

    how do I send an excel email when reorder point is met
  3. R

    Excel Reordering Textbox

    Hello There are about 50 textboxes in the userform i created. Everytime time i added a new textbox, I have to re-order the textbox to textbox1, 2,3,4...and so on. I have to do it each one everytime i added a new one. Is there an easiest way to set the textboxes in reorder all at once? Thanks
  4. K

    List Names in Chronological Order With Duplicate Dates

    Hi everyone! I hope someone can help me get to the final step. Using a formula, most likely an array, I would like to reorder my list of names in chronological order (by date). I have already created columns of data that I believe would get me to the final step, but I can't seem to finalize...
  5. S

    Reorder cell contents in reverse order - YIKES!!! quick resolution required!!

    Hi all, Got a sticky situation that is stressing me out, so need expert help!! I need to change the cell contents in reverse order - kind of sorting the cell Z-A but by line. I want to reverse the cell layout so that the latest comment is at the top. ie Comment 5 followed by 4,3,2,1 (the...
  6. A

    Reorder columns by their letter (not column header)

    Is there a way to use VBA to reorganize columns by the column letter? I've looked through the forumn and found plenty of posts on how to do this by the header, but nothing by letter. example: I have a spreadsheet that goes to column GZ I only need these columns and in this order- CQ,CP, A...
  7. K

    using macro to reorder and combine

    I'd like to create a macro that will take the information from the first two columns reformat and create the third column as shown formatted. Any help would be appreciated. <TABLE style="WIDTH: 180pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=240 x:str><COLGROUP><COL...
  8. G

    I need to change "Jane S-Doe" to "S-Doe, Jane" in the same cell. Help appreciated.

    I have a bunch of names in the following format. Each name is in it's own cell All of them have {First name> S- > Last name} Example: Jane S-Doe I would like it to be: {S- > Last name, > First name} Example: S-Doe, Jane Is there a way to do this automatically with a formula or macro?
  9. A

    Reorder rows on a predefined sequence and copy to new sheet

    Hi, I need some VBA help in copying ranges from one sheet to another and pasting them on a predifined order. I have one worksheet that contains a large number of ranges with data on alphabetical order. Each entry on this sheet contains several rows of data and is identified by a name (e.g...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...