Hello,
I was wondering if someone may be able to help me. I have been looking through the forums but all the macros i can find are quite basic and only work for singular columns. I am extremely to using VBA so please treat all responses as if it's my first time using VBA. Conditional formatting is not an option due to inconsistent information in every cell.
I have a workbook that has 3 sheets in it (1- Master, 2- Unique ID No Allocation, 3- Data). What I need to do is when I paste the new information in the "Data" tab to be able to run a macro what will transfer the 3 comments from the data tab to the master register against the unique ID. It needs to only update the IDs stated in the data tab and leave all other information as is against all other IDs. This is a large register with almost 10,000 unique IDs.
TAB 1 (MASTER) - Master Register
Column A - Unique ID No. - inserted via Vlookup from Tab 2 which has the ID list =IFERROR(VLOOKUP(M6,Sheet2!A:B,2,0),"")
Column M - Document Number
Column AB - Comment 1 - Vlookup =IFERROR(VLOOKUP(A6,Data!A:C,3,0),"") - need to replace this formulas function with the macro
Column AC - Comment 2 - Vlookup =IFERROR(VLOOKUP(A6,Data!A:D,4,0),"") - need to replace this formulas function with the macro
Column AD - Comment 3 - Vlookup =IFERROR(VLOOKUP(A6,Data!A:E,5,0),"") - need to replace this formulas function with the macro
TAB 2 (Sheet 2) - ID Register
Column A - Document Number
Column B - Unique ID Number Allocated
TAB 3 (Data) - Updated information is pasted in here
Column A - Unique ID No. - inserted via Vlookup from Tab 2 which has the ID list =IFERROR(VLOOKUP(M6,Sheet2!A:B,2,0),"")
Column B - Document Number
Column C - Comment 1 (new comment)
Column D - Comment 2 (new comment)
Column E - Comment 3 (new comment)
If anyone can solve this for me I would be forever grateful.
Thanks
Bookmarks