created

Hello all! I'm trying to write certain cells to a text file. What I have it doing is allowing me to type in the name to which a folder and file will be created. The file naming works and folder is created but I can't seem to get the bolded part to work. Any suggestions? Thanks...

Hoping you know of a solution to my Excel/merge problem! I am trying to figure out a way to automate our EDDM shipment forms at work because they are currently a huge waste of time to fill out manually in the current PDF format that we have. I think I have most of it figured out, but am hung...

Hi, I'm trying to figure out each month what new customers we have. I have a table called tblCustomer what has a date created. I have a table sale with sales dates. I would like to create a measure that will let me know the sales for the period I've selected, how many are new customers. IE I...

Hi, I hope someone can help, I have two spreadsheets which have loads of tabs on them and I created an index tab to help manage them, however, new tabs I have created don't seem to want to show up on the index tab. This is the vba code used in each of them, which appears to have worked fine up...

in my spreadsheet I have a column, B, with a series of numbers thats start with 0001 and sequential ascend upwards. These numbers reference file names etc 0001.xlsx. Each line of the spreadsheet will contain figures which have been extracted from the particular file name mentioned in column B...

I have an advanced filter that runs on my Excel VBA application which is suppose to filter dates in the data base, I created the advance filter on the worksheet and it works fine except for when it comes to filtering dates this is the formula I'm using: =IF(C5="",">1","<=" &C5) start date...

Hi my macro currently creates a new sheet within another document called Analysis_v3.xlsm and gives it a name of yesterdays date Workbooks.Open Filename:="filepath Analysis_v3.xlsm" Sheets.Add After:=ActiveSheet ActiveSheet.Name = Format(Date - 1, "mm-dd") however I would like the name of the...

Hello all, I've created some VBA that does the following: creates new sheet in existing workbook opens file containing SAP derived order book copies data and pastes into previously created new sheet When this happens the date format is changed for about 25% of lines from date to general...

Hi Where you usually write the comment about the sub you are writting? I created macro by recording steps and under Descrition: I wrote testing to my surprise excel created this code Sub Macro3() ' ' Macro3 Macro ' testing ' ' End Sub I was expecting this ' Macro3 Macro ' testing Sub...

Is there a formula for extracting certain words/phrases in a cell no matter where they appear in the cell? For example, I need to know if the cell has Not Needed, Need Created, Not Created and populate the result in the cell when found. Any help would be appreciated

Hi i have a macro code that creates a folder by what i specify in a cell. i woud like this code to incorporate a message box telling me what folder has been created Sub MakeSubFolder() Dim lngCount As Long lngCount = 2 If Len(Dir(Cells(1, 20), vbDirectory)) = 0 Then MkDir Cells(1, 20)...

Hi, I have a sheet with column 'Created" and dates inserted to it in the format "1/8/2019 14:58 ". However, when I do a pivot , I want the created to be read as 'Jan' , Feb etc based on the dates without changing the date format in the data sheet. Is this possible, please help. Regards, Nik

I need help suppressing zeros on my worksheet. I created a formula =IF(ISBLANK(B8),"x",IF(OR(D8<>0,E8<>0,F8<>0,G8<>0,H8<>0,I8<>0,J8<>0,K8<>0,L8<>0,M8<>0,N8<>0,O8<>0,P8<>0,Q8<>0),"x","")) , then a macro that would apply the filter. Sheets("Forecast Detail").Select...

Hi, Thanks for reading. I am trying to connect a table using connections.add2 after a running a macro to create a table for a user to input data on to. On another hidden and locked tab i am attempting to then link it to the first table created. My code is naming the table that is originally...

Hey Guys, I've figured out how to create a bunch of sheets based on some source cells. Now I'm trying to copy the data in the column from each source cell to the page that was created. This is what I've got so far. Sub AddWorksheetsFromSelection() Dim CurSheet As Worksheet Dim Source...

I am using a spreadsheet as a form which many persons may have to sign. The worksheet that would be used for signatures is locked, and must be unlocked when the signature cell is entered. Some signature cells are fixed in their location, others will be created by the form itself. The code for...

Hi All, Apologies if i'm not posting in the correct section. I tried to find the most appropriate discussion thread. This is quite a complicated one (well for me at least) so i'll really be impressed if this can be solved. What i'm trying to do is calculate and populate the SLA Deadline cell...

hello, I am created a Userform with some VB code that do some operations that i need for my work and save the WB as an addin ( elam file), when I add it to my Excel and try to run it but the Excel first Open the WB where the Addin was created and than the Userform popup. How can I stop the WB...

Hello Everyone, I have been working on a spreadsheet created by someone else, however I cannot figure below formula. Can anyone help explain it? Thank you. =XIRR(INDIRECT("R"&MATCH(B4,A:A,0)&":R"&MATCH(K4,A:A,0)),INDIRECT("A"&MATCH(B4,A:A,0)&":A"&MATCH(K4,A:A,0)))

Your help with this issue is much appreciated... I'm sure there is a simple solution but,I am stumped. I have created a workbook with a Summary worksheet and a macro to create worksheets that are named with a Date (e.g., 27Jan2019). Dates are selected from a drop-down list and the macro is...