exist

I need my macro to be modified. Right now it: Copies range from 'Order Type vLookup' tab Opens files from folder i choose (when prompted) Adds new tab to each opened workbook Paste the information Rename new tab: Order Type vLookup' Save and Close Workbook Loop for each file in folder I...

Good Morning/Evening everyone, I have the following code which works fine IF the directory is present but I want it to create the directory if not present Dim thisfilepath As String Dim fin As String fin = Range("A21") & ".xlsx" thisfilepath = Application.ActiveWorkbook.Path & "\orders-copy\" &...

Hi, I have two list. I need to check if value from one list is existing in second list. If not existing I should add on the end of the list the value. If exist I should in column B add "YES". Function X() Dim ws1 As Worksheet Dim ws2 As Worksheet Set ws1 =...

When trying to move or copy a sheet within the same workbook the following message pops up: "A formula or sheet you want to move or copy contains the name 'daffdd', which already exists on the destination worksheet. Do you want to use this version of the name? To use the name as defined in the...

Hi, I have developed some fairly complex spreadsheet workbooks for my employer that monitor buying patterns for each day of each week. There is a workbook for each week with references for each day and each workbook is linked to the previous week for live reference. It is taking a while to...