created

  1. S

    wName for folder?

    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...
  2. K

    How to create number sequence based off of calculated value?

    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...
  3. S

    Count of new customers

    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...
  4. F

    Index tab not updating

    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...
  5. G

    New files not created yet

    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...
  6. W

    filter dates formula using advance criteria.

    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...
  7. I

    Help naming a sheet from a macro

    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...
  8. H

    Date Format Change in VBA

    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...
  9. L

    comments location in vba -opinion not question

    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...
  10. B

    extracting certain words in a cell

    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
  11. S

    Message Box

    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)...
  12. N

    Date format in PIVOT

    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
  13. A

    Suppressing Zeros Macro

    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...
  14. S

    Making Connections.Add2 Dynamic Trouble

    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...
  15. K

    Activate New worksheet based on cell text

    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...
  16. W

    Using Mod function to trigger event

    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...
  17. S

    Calculate and populate duration (days) into cell 3 from cell 1 & 2 that contains specific words

    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...
  18. J

    problem when running my addinn

    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...
  19. A

    combination of XIRR. Indirect and match

    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)))
  20. S

    vlookup Not Working After Source Range is Created

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top