this is because I copy data manually . in realty will filled numbers 1,2,3 as in BS Q 4286.pdf file in last column ,Next question : according to your post #36 last attachment for the PR-2023-00003 data is it normal the empty 'Sr' column ?
Neither this nor that . will auto fill when import form original PDF file contains numbers and the word is ITEM not SR as in BS Q 4286.pdf fileif you want to manually correct the 'tt' worksheet or if you prefer a 'Sr' automatic numbering.
this is not problem to update data , then I will delete whole data in tt sheet and re- import again from PDF files to do that .In the last case, as 'Sr' is like an ID for each data row so the 'tt' worksheet Change event VBA procedure
can not update anymore just the result worksheet relative cell to be changed but must reload all this worksheet data.
Bookmarks