LinkBack URL
About LinkBacks
abdo meghari 
I don't want to comment for post#80 obviously all of mistakes you have found out because I copied data manually badly . so I will try clean file and attaching tomorrow .
I think I will choose option2 but if there is big difference for running speed then I will choose option3So which option is your favorite ?
An advanced 'tt' Change event procedure as described above (detecting if only a cell must be updated).
A lighter 'tt' Change event procedure updating all the relative result worksheet
even when only a cell is necessary to be updated …
No Change 'tt' worksheet event so no automatic update when a 'tt' cell is changed,
just needs to launch the main procedure …
last thing : could be file name in column A like this
PURCAHSE_MAR.PDF
PURCAHSE1_MAR.PDF
PURCAHSE2_MAR.PDF
or you don't want extension at all?
Register To Reply
Bookmarks