There are many ways to achieve the same objective in Excel, in this instance copying a range of cells to a new spreadsheet location. The spreadsheet above represents the situation after the code has been executed. Before execution the range "F1 through "H6" would not contain any data. In this example I will copy the cells in vba by creating a range … [Read more...] about How To Copy A Range Of Cells In Excel Using VBA
All Articles
How To Backup, Mirror And Run Your WordPress Website Locally
In this tutorial I show you how to download a wordpress website on your local computer and run a mirror copy of it there. This gives you the the ability to test out website ideas privately or ensure that you have a plan B if your website get's hacked. The video below gives you a "look over my shoulders" view as I walk you through the steps. … [Read more...] about How To Backup, Mirror And Run Your WordPress Website Locally
Export Table Data From Libre Office Base
In this tutorial we are going to export the contents of the table below to a text file in csv (comma seperated values) format. LibreOffice Base is the free database application that is packaged with LibreOffice, I use it all the time and in my opinion is the only option for quick and dirty database analysis on the Apple Mac platform (which i use). LibreOffice base is also … [Read more...] about Export Table Data From Libre Office Base
Python Create CSV Text File From Tab Delimited
In this tutorial video, I take a file downloaded form a website that is tab delimited and convert it to a comma delimited csv file using a python program that can be called from the command line.This csv file will be imported into LibreOffice base (Free database software for Mac, PC or Linux) for further processing. If you program or write macros in a … [Read more...] about Python Create CSV Text File From Tab Delimited
How to Make A Table In OpenOffice or LibreOffice
In this tutorial I will explain how to create a table in LibreOffice base, a free database application that is available on windows mac and linux. This simple table could be used as a generic table for importing data into your database. Further queries in the database could then transfer data from this table to other parts of the database while changing … [Read more...] about How to Make A Table In OpenOffice or LibreOffice