shift=xltoleft

Have data that is being extracted from another source. I need to make it usable by a variety of people (hence idiot proof) so they can just create the data and copy, than open excel and single keystroke to paste etc. as below. User opens excel, Ctrl+Shift+R; •Paste copied data - working...

Hi Everyone, I am hoping someone can help me with my issue. I am trying to create a macro but there is one part where I am stuck. I need to insert a column, enter in 0 and convert to number with 2 spaces. I am having two issues. 1. if i select the whole column it will add 0.00 all the way to end...

I have this code and its not working, can anyone explain to me why? sub test() Dim lastCol As Long with activesheet lastCol = .Range("A1").SpecialCells(xlCellTypeLastCell).Column Columns(17 & ":" & lastCol).Delete Shift:=xlToLeft end with or sub test() Dim lastCol As Long with...

Hi, So i am working on a macro that will allow me to open a window in workbook 1 to find an excel report file and then format that report. Once the format is complete it then copies and pastes to workbook 1 to the specified tab so that the original file is not touched or modified. I have 3...

Hi All, Can you please help me by adjusting this VBA for autofill until empty and not until cell "C346"? Thank you very much!! ' Keyboard Shortcut: Ctrl+y ' Columns("A:A").Select Selection.ColumnWidth = 8.57 Columns("A:A").EntireColumn.AutoFit...

Hi good people!, This is my code: On Error GoTo a: Windows("Patron_Actives_Extract.csv").Activate Rows("1:3").Select Selection.Delete Shift:=xlUp Cells.Select Cells.EntireColumn.AutoFit Columns("C:C").Select Selection.Delete Shift:=xlToLeft Columns("E:G").Select...

Hey Everyone, Looking for some VBA help here. Basically I have this disgusting looking output from one of our management systems. I have created code to clean the data up into a presentable table format that can be utilized to draw some analysis. However, in doing so I have brought certain...

Gurus I have a data from Column A to Column BB. The data can go up till 500,000 lines or more. I have record a macro for the changes that I've done. The macro works pretty well but it run really slow which I believes due to it has a lot of redundant code that can be simplify to make it faster...