title: How can I create a macro that find, select and cut columns, and paste them in another worksheet?
body: <p>Another day, another problem. I think it is easy to make this thing work, but I just don't know how to go further now.</p>
  <h1>The issue:</h1>
  <p>On work we get excel sheets from our customers. In this sheet, they put detailled information, organised in each column, e.g. the first column contains customernumbers, the second column contains names, the thirth column addresses etcetera. The first row contains the description of the columns, like: &quot;Customernumbers&quot;, &quot;Names&quot;, &quot;Addresses&quot; etcetera.</p>
  <p>The problem is, not every customer sents us this information in the right order or with the same description, e.g. some people call the column with Customernumbers, numbers or pupilnumber. Also, the columns are not always in the same order. Sometimes they put Addresses in the first column, sometimes they put names in the first column.</p>
  <p>We have to manualy cut and paste every column in our own excel sheet in the right order, so that our software can read everything and put it in the database (no not mysql, else i had made already a script for mysql).</p>
  <h1>The Question:</h1>
  <p>How can I detect what is written in every column and automatically cut and paste that column in the  right column of our excel worksheet. E.g. detect that the thirth column is about Customernumbers and paste them in the Customernumber column in our worksheet.</p>
  <h1>Ideas:</h1>
  <p>1.) I was thinking and making a solution with php en mysql, were the excel worksheet will be uploaded in xml format, so that a php script can run and read this xml file, so that it finally can be stored in a mysql database. After that, we can create a xml file, by writing the information from the database to an xml file, with the columns in the right order.</p>
  <p>2.) After long thinking and testing, i realized this would take to much time and is to complicated for something so easy. Instead, I tried to make something in VBA. I found useful scripts, and learned that VBA can do something I want. The only thing is, the web is to big to find what I exactly want and I only know the basics of VBA, however I would like to learn more about it, this is something that I need in a short time.</p>