title: Creating a Macro that copies a date from one spreadsheet and moves it into another
body: <p>I have no experience with developing macros but hope you may be able to help.</p>
  
  <p>We have 12 excel spreadsheets that monitor the distribution of documents.</p>
  
  <p>Each time a document is distributed, the date that document was distributed is entered into its relevant excel spreadsheet.</p>
  
  <p>What we would like to do is create a seperate excel spreadsheet that finds the latest distribution dates for each of those 12 documents and list each date in one sheet.</p>
  
  <p>The dates in each of the 12 documents are listed across the row. 
  i.e | MAR-10 | JUL-10 | SEP-10 |</p>
  
  <p>The macro will have to find the last date in the row and then move it to the new document.</p>
  
  <p>The new document will hopefully look like this:</p>
  
  <p>| Sample 1 | SEP-10 |
  | Sample 2 | AUG-10 |</p>
  
  <p>Really hope you can help!</p>
  
  <p>Thanks,
  Nathan </p>