• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. P

    Use Save as to save one work sheet in a new work book

    Never mind I was able to figure it out and get it to work with this code 'Mechanical Engineering File 'Turning off Prompts and Stopping Screen Updating Application.DisplayAlerts = False Application.ScreenUpdating = False 'Remove Selected Formulas Columns("A").Select Selection.Copy...
  2. P

    Use Save as to save one work sheet in a new work book

    So I am trying to take the active sheet and save it to its own file when I run the following macro. Not sure why it is not running. I appreciate any help. Thanks, Petar Application.ScreenUpdating = False ActiveSheet.Range("$A$4:$AG$2001").AutoFilter Field:=4, Criteria1:= _...
  3. P

    VBA Transposing thousands of lines

    I have been working on this for a few days with no luck so any help would be appreciated. What I am needing is to transpose CC2:CS2 to CA2 then transpose Z2:AP2 to CB2. Then proceed to the next row CC3:CS3 transposed starting at CA19 then Z3:AP3 to CB19. That is where I am hitting a snag getting...
  4. P

    Determine if the Cell next to the next open cell is blank

    That worked perfectly thank you! Sorry I forgot to upload the file.
  5. P

    Determine if the Cell next to the next open cell is blank

    Hello all I am stuck and tying to figure out how to fix the code below. Basically the code finds the next available Cell in Column B then pastes certain text there. But I need to add an If statement that stop the Macro and alert the user if the Cell to the left is blank. Thanks for the help...
  6. P

    Combine like items Macro

    I tried using a pivot table but it will not keep the data organized in the same way that it currently is. And when I was talking about deletion that would not of been the best way to describe it. I was trying to say that if 24 items can be combined into 1 row sum there totals and then remove the...
  7. P

    Combine like items Macro

    Hello All, Since my last question was such answered so well I figured I would bring another question here. I am wanting to combine like items while deleting items that were combined. There is a few restrictions I need the format the data is in to remain consistent, and if the cells are to be...
  8. P

    WBS VBA Code

    Thank you Luke that worked perfectly!
  9. P

    WBS VBA Code

    I have been searching for a WBS numbering Code and have been unsuccessful so far. So I came here and I am confident I can get an answer. I am needing the WBS code to be based on Column G in my sheet. It will be based on "account code" length as follows for example: Column A Column...
Back
Top