insert sheet into files

  1. F

    Insert new worksheet by using Loop

    I need to insert 10 new sheets in a workbook, base on the value in Column B. I want to get it in a way that whenever the value of Column B change, it insert the new sheet and rename the Sheet Tilte same as Value in Column B. I dont want selection technique and only want to use loop as some of...
  2. C

    Rename multiple files in a folder macro

    I have 400ish departmental budget files in a folder that I need to upload to a Sharepoint doc library. The files in the folder will have to exactly match the files we already have set up in sharepoint in order to upload them to the sharepoint site. As it stands now there is only one...

Some videos you may like

This Week's Hot Topics