Hello,

I currently have a excel workbook labelled "MasterRegister" with a worksheet in there called "Register".

I have a vba code whereby it pulls data from a closed workbook called "RO Status Log - Practice Copy" and inserts it into the "Register" worksheet. Here is the code:

Please Login or Register  to view this content.
There a few problems which I cannot solve:

1)

"RO Status Log - Practice Copy" is constantly being updated with new information. The new information is entered in reverse - so information starts from row 4. Thus if 1 new entry is added, the current row 4 will push down to row 5.

Now the code imports the data to "MasterRegister" workbook, however it doesn't import all the latest entries - reading from new entry of rows - (I want it to import according to last saved or last updated from R0 Status Log).

I currently have the code to only pull from range A4:E4. I do not know how to program the code to pull all the latest data from different rows in the sheet.

2)

When it runs it states "4 new entries found in range of A4:E4". This I do not want. What I want it to do is read from column A in "RO Status Log - Practice Copy" and read the numbers corresponding to the new entries and state "4 new entries, numbers: 154768, 1575" etc.


Any help would be appreciated!

Thank you.