Looking4sum1
09-25-2017, 07:37 PM
Im a Newbie here. I saw a post about the above mentioned title by arkusM (w w w.vbaexpress.com/kb/getarticle.php?kb_id=1074) and I've adapted to my workbook and it works.
However, for the other workbooks that I have...is there a way thru vba to track only the specific sheet/s with specific range/s (e.g. Sheet2'!$A$1:$H$5, Sheet4'!$B$4)? and is there a way also to delete the sorted specific sheet/s in the Cell Changed of the "Tracker" Sheet (e.g. all Sheet2'!$U:$1 & Sheet4'!$D$3:$G$8)? May I know the code if there is? The reason is to record only the important ones and not to get flooded.
KB Link (http://www.vbaexpress.com/kb/getarticle.php?kb_id=1074)
Many thanks in advance.
Arvie
However, for the other workbooks that I have...is there a way thru vba to track only the specific sheet/s with specific range/s (e.g. Sheet2'!$A$1:$H$5, Sheet4'!$B$4)? and is there a way also to delete the sorted specific sheet/s in the Cell Changed of the "Tracker" Sheet (e.g. all Sheet2'!$U:$1 & Sheet4'!$D$3:$G$8)? May I know the code if there is? The reason is to record only the important ones and not to get flooded.
KB Link (http://www.vbaexpress.com/kb/getarticle.php?kb_id=1074)
Many thanks in advance.
Arvie