1. P

    how to create pivot tables for all existing tables dynamically using VBA

    suppose I have three data tables in same worksheet, I need to create their corresponding Pivot tables Is it possible EX:- tbl1 -> Pivtble1 tbl -> Pivtble2 etc also I am notsure what is table range and table name can I create pivot table for such scenario using VBA ? Thnks
  2. S

    Combinations and permutations

    I have some work, in an Excel spreadsheet. Create an excel where there are 22 players list and create all the possible combinations for 11 players team. The conditions are as below :- Create your Dream11 team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget...
  3. N

    Worksheet that Mirrors a Table

    Hello, I was hoping that you could help me. I am trying to create this Employee benefit and vacation sheet which encompass all 12 months. Is there a way that I can create a table or something that will take the employees name and mirror to each worksheet (12 month), and if i add or delete an...
  4. gheyman

    Adding Username to Append Query

    Is it possible to add the User Name to each record that's being added to a table? I am using an Append Query to add the new record(s). I thought I could create a field in my query to do that, by what I am trying doesn't work CreatedBy: Environ("Username")
  5. Z

    Linking Forms to another Forms

    My Boss asked for a hard task ( for ME) which requires To create a form and inside the form create a Combo Box where i can open a drag down menu and select an option and this option Automatically fill another form Linked to this one. For an example: Form 1 Contains the city, if i choose a...
  6. T

    Create a macro to unprotect sheet, refresh pivot table, reprotect sheet

    Hello! I am trying to create code that once a user click on the tab “LeadershipSoftwareOverview” the sheet will be unprotected, the pivot table on that tab (labeled “ResourceSummary”) refreshed and then the sheet reprotected. Below is what I have and it is not working. TIA!! Private Sub...
  7. P

    Problem with duplicates

    Hi All I'm using the code below to create template copies, how can i adapt it to avoid duplicates please and only create unique worksheets. Sub NewDays() Dim i As Long, LastRow As Long, wksht As Worksheet Sheets("Tides").Activate LastRow = Cells(Rows.Count, 1).End(xlUp).Row For i = 1...
  8. L

    Form from Options--> All commands vs VBA form

    Hi I just found that I can create a table then Ctrl+T then I can go to Options-->All commands-->Form and use that command to create a data entry form. My question, what is the advantage/disadvantage of that form compare to a one that I can create using VBA? Thank you very much.
  9. B

    Create new workbook from Pivot Table Drilldown (Show Details) action

    Hello everyone, I'm currently working with a few Pivot Tables that will be double-clicked on by a few people on the results, which by default, Excel will generate a new worksheet with the data within those same results. What I would like is, instead of generating a new worksheet, to generate a...
  10. T

    VBA - create new sheet from a template

    Hi I am asking for your help for a VBA code which create new sheets from a template sheet. I have already found and modified which works well : <code class="hljs vbscript">Sub CreeOnglets() Application.ScreenUpdating = False supOnglets Set bd = Sheets("bd")...
  11. R

    Pivot Table from Multiple Sheets

    Hello there, Can we create pivot table from multiple sheets? I have 5 sheets in a workbook and their column orders are identical. I need to create one pivot table using all 5 sheets as source data. I can't combine the 5 sheets into 1 due to the volume of data. Thank you!
  12. E

    Excel VBA replace duplicates for large formula

    Hi All, I have some percentages for 3 weeks for 3 different Areas in Area 1) B1:V100 Area 2) AB1:AV100 Area 3) BB1:BV100 now what i want to do is get the 5 largest values for each day 5 largest for each day ie B1:B100 C1:C100 D1:D100 etc Now i know i can rank them and use a countifs...
  13. G

    Create a string based on three textbox values

    Sorry for the dumb question, but how do I create a string that pulls from three separate strings? I want the string to format so if TB1=AA, TB2=BB, TB3=CC, the string will be AA BB CC. Using Dim doc As Stringdoc = TB1.Value I can get it to return the first textbox, however when I try to add...
  14. T

    Creating Varied Pivot Tables based on a Range Name

    I have developed a Macro for my work, and it's going brilliantly. Thanks to everybody on here so far who has helped. The next stage is for me to create pivot tables of the data. I have a table called "Final" data which contains the data for the pivot table, however the format of the pivot...
  15. N

    Create a honeycomb pattern with the hexagon shape

    Hi, How can I automatically create a tessellated honeycomb pattern on a sheet, using the hexagon shape? Ideally, I want to be able to use 2 variables for row & column and create a honeycomb based on those values I hope this makes sense!
  16. R

    Macro - Print sheets between two marker sheets

    Hello, I have multiple files with varying working and backup sheets but I would like to create a macro that will print the main group of tabs which will always vary in actual names. My initial thought was to create marker workbooks named 'start' and 'end' for example that would mark the...
  17. T

    VBA to create pdf thats 2007 compatable

    Hi Everyone, I need a macro to create a pdf of active sheet but it needs to work on 2007 version as well anyone remember the code to do this? please help if you can Thanks Tony
  18. N

    Check file name in foder and remove similar

    Hi all: I want macro to check all file name in folder, if file name similar (different one or two charactor) will create new folder "OLD" then remove file with number smaller to folder "OLD" Example: Folder have: G03144-99201001-01201001-201906-BI-M-01.xlsx...
  19. Y

    Create concatenated list of unique IDs from multiple ranges

    I have several lists named as ranges and want to create a single list of all the unique combinations of items on those lists with a formula ideally: For example, if I had three lists with the following values: List 1: A, B List 2: 1, 2 List 3: X, Y The formula would create this list: A1X B1X...
  20. A

    VBA to create MapInfo Table & Points

    Hi, I'm new to vba. for my work requirements I need to create a vba to create a MapInfo Table and Points. so far I know is only "CreateObject (Mapinfo.Application)" :( please guide me for this.

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...