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...
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:= _...
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...
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...
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...
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...
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...