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 author has not written his bio yet.
But we are proud to say that admin contributed 32 entries already.
Entries by admin
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 […]
Chicago Computer Classes by Chi Brander Inc
200 W Madison Street
Chicago, IL 60606
For Excel Training Call (312) 818-5503
- Google Sheets Apps Script – Dynamic Dependent Dropdown Data Validation ListsFebruary 15, 2018 - 7:52 am
- Google Sheets Apps Script – Combine Multiple Tabs to a Master Tab When Column Positions Don’t MatchFebruary 13, 2018 - 6:58 pm
- Google Sheets Get Distance & Time – GOOGLEMAPS FunctionNovember 23, 2017 - 7:10 pm
- Google Sheets Import JSON – IMPORTJSON FunctionSeptember 4, 2017 - 8:25 am
- Average Salaries – City of Chicago Fire Police Department EarningsMarch 21, 2017 - 1:56 am
Locations Serving: Chicago, Loop, Downtown, North, North-East, North-West and West Suburbs, including Evanston, Northbrook, Schaumburg, Hoffman Estates and Naperville IL.