excel workbook pulls data from another excel workbook

[sdhutty]

Hi there,

I currently have two excel workbooks.

The first includes data on a worksheet.

The second workbook - I want it to update and log the data from the first workbook:

So for example, I have a command button in the 2nd workbook and when pressed it searches for newly updated data from today in the first workbook sheet and records it into the sheet in the 2nd workbook.

The first workbook is labelled "ROStatus Log" - the worksheet with the data is called "R&O Closed". It has 5 columns of interest which I want logged into the 2nd workbook. These columns are:

Column A Log Number
Column B: Document No.
Column C: Document Type
Column D: Unit Affected
Column E: Issue/Revision

The 2nd workbook is called "MasterRegister" with the worksheet of interest called "Register"

I want the above columns - recorded in columns:

Column A for Log Number
Column B for Document Type
Column C for Document No.
Column I for Unit Affected
Column G for Issue/Revision

This is a bit of a stretch but is it possible?

Bear in mind I am a complete novice :)

Thank you!

[p45cal]

cross posted http://www.mrexcel.com/forum/excel-questions/972452-excel-workbook-pulls-data-another-excel-workbook.html

[sdhutty]

Double the chances of a reply haha

[p45cal]

Have a read of http://www.excelguru.ca/content.php?184
MrExcel are a bit more draconian with people who don't bother with rules. Ultimately it will be you who loses out.

haha