This macro is useful in case you have a data table in the following format and you want to transform it to a single cell separated by commas. 43680 43681 43659 43677 43578 43522 Preferred Results: 43680;43681;43659;43677;43578;43522 Excel Macro: Option 1: Sub ConcatColumnValues() Range(“B1”) = Join(Application.Transpose(Range(“A1”, Cells(Rows.Count, “A”).End(xlUp))), “;”) End Sub Option 2: Public […]
This formula is useful in case you have a data table in the following format and you want to transform it to “Preferred Results” format. A-Data-1 B-Data-1 C-Data-1 D-Data-1 A-Data-2 B-Data-2 C-Data-2 D-Data-2 A-Data-3 B-Data-3 C-Data-3 D-Data-3 A-Data-4 B-Data-4 C-Data-4 D-Data-4 Preferred Results: A-Data-1 A-Data-2 A-Data-3 A-Data-4 B-Data-1 B-Data-2 B-Data-3 B-Data-4 C-Data-1 C-Data-2 C-Data-3 C-Data-4 […]
This VBA code will add a new worksheet in your Excel project. Sub AddNewWorksheet() Dim NewWorkSheet As Worksheet Set NewWorkSheet = Sheets.Add End Sub
If you work with databases and regular data tables you probably had a situation when someone gave you a regular Excel 2 dimensional spreadsheet that is not that useful if you need to use the data within a database and run some queries or just make PivotTables in Excel. The Macro code below will transform […]
This VBA code can help you delete all hidden columns and rows from your excel sheet with a click of a button. Sub hiddendelete() For lp = 256 To 1 Step -1 ‘loop through all columns If Columns(lp).EntireColumn.Hidden = True Then Columns(lp).EntireColumn.Delete Else Next For lp = 65536 To 1 Step -1 ‘loop through all […]
Locations Serving: Chicago, North, North-East, North-West and West Suburbs, including Northbrook, Schaumburg, Hoffman Estates and Naperville IL.