Lads,
I have 2 worksheets on excel spreadsheet both are linked to the same MS query. 1st sheet (Called: MdProductDataList) contains only data linked to query and 2nd (Called: Data) contains data linked to query plus added comments manually.
This would require 2 step refresh: Firstly I would refresh data on 1st sheet (Called: MdProductDataList) then I would run Macro to avoid my manually added comments shifting to different row and then I would refresh 2nd sheet (Called: Data)
Issue I'm having is when row is deleted by query Code works OK, but when 1 Row is added by query after refresh my comments wont follow.
How can I alter code below so it does what I want? Thanks.
Bookmarks