exist

Hi, Sample of 100+k rows data: DEFGHIJKLM1MaxBIBexpected result :231.207021.207024Max Exist41.207021.2067551.207021.2088961.207021.2030271.207021.2070281.207031.207031Max X91.207031.20701101.207061.207063Max X111.207061.20702121.207061.20705131.207061.20702141.207021.20699151.207241.207246Max...

Hi, I have a code that works fine with all conditions accept the one and need your help please My code says: Check if the name is exist or not If not, then GoTo new_item (it works great) If exist and the BarCode is exist for the same name then just add the quantity (This is what I need) If...

I need my script to detect if worksheet(s) exist based on some critera and if 1 or more does, ignore the entire script. I want to add this part at the start of a current script I'm using. If any sheets already exist, it is causing me trouble... Of course this might not be the ideal way to...

Hello, I have the following code to add the input BarCode and it's related details to the next available raw in sheet2 column ("P") Here is a piece of my code that works fine: [CODE]Dim ws As WorksheetSet ws = Sheet2 nr = ws.Cells(Rows.Count, "P").End(xlUp).Row + 1 ws.Cells(nr, "P") =...

Hi, When I load my Excel file I keep getting the following error message: "Sorry, We could not find 'Path/Week_xx.xlsm'. Is it possible it was moved, renamed or deleted?" When I click OK, I then get: "Microsoft Excel can not access the file 'Path/Week_xx.xlsm'. There are several possible...

Hi, I have a macro that uses multiple arrays and after use I have a reset button which clears these: erase MyArray1 etc... However in some cases not all arrays are initiated so when I attempt to erase those I get an error as they don't exist. Is there a way, when erasing them to check if they...

I have a report with links to files that might not exist and to tabs that might not exist (but are in files that do exist). I'd like my report to be the same every month requardless so the same file works every month whether or not certain files or tabs are missing. How can I do something...

Hi all, I would very much appreciate your help with the following: Description of problem: I have 1 tab in my Workbook ('File Names List') which has a list file names and the corresponding path listed. File Names are listed in Col. A starting row 3 and File Path are listed in Col,B also...

With ws_data .Range("J:J").Clear For t = 2 To nwb_LastRow rn_1 = .Cells(t, 3) temp_fac = .Range("H" & t) & .Range("I" & t) If Application.WorksheetFunction.CountIf(ws_rd.Range("A:A"), rn_1) = 0 Then...

I'm trying to execute this line of code: DoCmd.TransferText acLinkDelim, "TheUploadSpec2", "ltUpload", upPath & upFileNm, True I keep getting Error '3625' -- Specification Does Not Exist. But I swear it absolutely does! When I go to External Data>New Data Source>From File>Text File...I click...

Hi. So, i got a code for checking if a file exists from google. The problem is with it, even tho the file actually exists, it keep skipping it, as it didn't exists. Code: Sub CFF() Dim fso: Set fso = CreateObject("Scripting.FileSystemObject") If fso.FileExists("Desktop\SkjKa.xlsm") Then...

I'm trying to find out how to use a formula to search cells containing multiple values against an array of values and either extract those values to another column or just return some identifier (not exist v exist, etc.). Is this possible? ex: target cell values are in this format 860032011...

Hello I am hoping that you are able to help please I have a worksheet which receives a feed into "Sheet 1". If an item in column "F" of sheet1 does not exist in column "H" of sheet 2 then our team need to add it on to Sheet 2. They then set column "R" of sheet 2 with how many instances there...

I am using the formula below and it works great. SUMPRODUCT(SUMIF(INDIRECT("'"&REF!$C$2:$C$26&"'!$B$10:$V$10"),K$1,INDIRECT("'"&REF!$C$2:$C$26&"'!$B$17:$V$17"))) My only challenge is that some of the tabs in the range $C$2:$C$26 don't exist yet. So to get around this I have just adjusted the...

Hi Everyone, I have a document thats going to go out to over 200 people. I have set it up with loads of macros stopping anyone from editing, changing and playing around with it, however there is still the possability that someone might think they know what they are doing and change things as...

Dear Sir I am using following code and it copying my file It is copying my file to current folder where original file exist, I just need on amendment to send this file to a folder name PDF, if folder not exist then VB need to create it Thisworkbook.path/PDF

Im having trouble finding the syntax to correctly define a range variable. I am receiving an error on the lower of the two lines. These lines both exist within a with statement. If .Cells(bb, "A").value = sampleVar Then Set TblRng = .Range(Cells(bb, "A"), Cells(bb...

Hello I'm trying to write a macro that will copy an entire row from sheet2 and paste it to the bottom of sheet1 if the cell value in column f sheet 2 doesn't exist at all in column f on sheet 1. For example if column f sheet 2 = 123456 and 123456 doesn't exist anywhere in sheet1 column f then...

hi, i know how to: Dim WorksheetExists As Boolean WorksheetExists = Evaluate("ISREF('Graficas'!A1)") and work But i am work with some workbooks.... and then i need evaluate if exist sheets on each workbook. this: WorksheetExists = Evaluate("ISREF('Graficas'!A1)") Evaluate in the last opened...

Hi all. Exist more type of Graphs/Charts? more moderns? Thanks