• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel to check file name which is open from different excel.

jitendra6872

New Member
Hello Experts.

Vba to check file with their name in different excel sheet if filename found on the coloum
then take some values form their and paste on the same open file on the top row with some changes.

this process continue every time when second file open.


Actually issue is i want to add certificate number to the files a specific code and their serial number will continue one by one .It will submit to somewhere so every time i copy from some where and add and vlookup .
very tizy and time taking
plz do needful
plz help if you need sample file i will add on here
 
Last edited:
Back
Top