Hello,
I currently have 2 excel workbooks.
One called "NewMasterRegister (PRACTICE)" and one called "RO Status Log - Practice Copy".
Within the MasterRegister workbook is a worksheet called 'Register' and within the RO Status Log workbook is a worksheet called 'R&O Closed'.
R&O Closed worksheet is regularly updated with information. The information is updated in reverse order. With new data being entered from row 4.
R&O Closed worksheet has the following format:
Column A: R&O Number
Column B: Document Number
Column C: Document Type
Column D: Unit Affected
Column E: Issue/Revision
I currently have a VBA code which pulls data from the RO Status Log and inserts it into the 'Register' worksheet, entering it into specific columns. However I have 2 problems which I can't figure out:
Here is the code first of all:
Problem 1:
'R&O Closed' worksheet in 'RO Status Log - Practice Copy' is constantly being updated with new data inserting from row 4. Now the code imports the data to "MasterRegister" workbook, however it doesn't import all the latest entries - reading from new entry of rows.
As you can see from the code, 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 'R&O Closed' worksheet.
(Maybe programming the code to pull data from according to last saved/updated on R&O Closed worksheet). If no new updates it will not import.
Problem 2:
When it runs it states "4 new entries found in range of A4:E4". This I do not want. This problem links back to problem 1. What I want it to do is read from column A R&O Numbers in "RO Status Log - Practice Copy" and read the R&O numbers corresponding to the new entries and state "4 new entries, numbers: 154768, 1575, do you wish to import?"
Any help will be much appreciated Note: I am quite new to VBA
Thanks a lot!
Bookmarks