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 and records it into the sheet in the 2nd workbook.

Is this possible? I am a VBA novice when it comes to this coding so any input will be grateful thanks!

There are some restrictions when logging the sheet with the new data but first I want to be able to get it going.

 

[sdhutty]

Maybe this will make it clearer:

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