Search:

Type: Posts; User: Kyosti; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thread: Macro Help

    by Kyosti
    Replies
    2
    Views
    46

    Macro Help

    The following macro is designed to split several tabs within a sheet into individual files. What I would like to do is get this part of the macro: Format(Date, " BOB mm-yyyy" to prompt a dialog box...
  2. Thread: VBA Help

    by Kyosti
    Replies
    13
    Views
    349

    Re: VBA Help

    The file has 5 starting tabs, and the macro creates 14-15 new tabs. In my other code on the older file it is built in to create the new tabs at the end and in alphabetical order. I just thought the...
  3. Thread: VBA Help

    by Kyosti
    Replies
    13
    Views
    349

    Re: VBA Help

    So it seems that the error was being caused by N/A Values. Once I reconciled for that it works just fine. But it is not creating the tabs at the end or in Alphabetical order. I thought that was part...
  4. Thread: VBA Help

    by Kyosti
    Replies
    13
    Views
    349

    Re: VBA Help

    The file has several different macros, but they are not connected to each other.
  5. Thread: VBA Help

    by Kyosti
    Replies
    13
    Views
    349

    Re: VBA Help

    Correction the new error is in this line

    Ws.Range("A1:R1").AutoFilter 16, Ky
  6. Thread: VBA Help

    by Kyosti
    Replies
    13
    Views
    349

    Re: VBA Help

    I swear I tried that code too, but I must have been off somewhere! Thank you so much @Logit, however I am still getting an error on the same line. But it did create half of the tabs.
  7. Thread: VBA Help

    by Kyosti
    Replies
    13
    Views
    349

    Re: VBA Help

    It would be in P Fluff
  8. Thread: VBA Help

    by Kyosti
    Replies
    13
    Views
    349

    VBA Help

    I have tried to adjust a VBA Code that was built for me by Fluff and I thought I was close to getting it to work, but I was mistaken.

    Sub Kyosti()
    Dim Cl As Range
    Dim Ws As Worksheet
    ...
  9. Replies
    1
    Views
    70

    Re: Macro Pivot Table Help

    I had to rework the file and I managed to get this done without relying on the pivot table, but still including the pivot in the file. Thanks for looking
  10. Replies
    1
    Views
    70

    Macro Pivot Table Help

    Hello all,

    I hope you all can help as you always have. I have the following macro that currently filters a data table and separates the data into different tabs based on a field. I would like to...
  11. Thread: Macro Help

    by Kyosti
    Replies
    3
    Views
    172

    Re: Macro Help

    You are the man as always!!!
  12. Thread: Macro Help

    by Kyosti
    Replies
    3
    Views
    172

    Macro Help

    So you guys helped me before, need it again. I built this Macro based on help from you guys, but I only understand half the language. I need to have the macro work exactly as it is, however when it...
  13. Thread: Excel cursor

    by Kyosti
    Replies
    4
    Views
    170

    Re: Excel cursor

    I was hopeful, but no
  14. Thread: Excel cursor

    by Kyosti
    Replies
    4
    Views
    170

    Excel cursor

    This is the most ridiculous that I have to ask but do any of you know how to get the hovering cursors back? Meaning the plus icon at the bottom of a cell, or the width arrows between columns!?! They...
  15. Replies
    9
    Views
    326

    Re: Several Tabs in a workbook

    I was sooo close, I thought it would be something like that but I did not know the language. THanks again
  16. Replies
    9
    Views
    326

    Re: Several Tabs in a workbook

    JLGWhiz

    Last question if possible, I am sure it is possible, but I don't want to mess it up. Is there anyway to add the month and year to the name of the file when processing the Macro?
  17. Replies
    9
    Views
    326

    Re: Several Tabs in a workbook

    Worked like a charm!!! Thanks so much!!
  18. Replies
    9
    Views
    326

    Re: Several Tabs in a workbook

    Also I am getting a compile error on the macro you provided.
  19. Replies
    9
    Views
    326

    Re: Several Tabs in a workbook

    @JLGWhiz so would I replace an area of the code, or add this to the code that is existing?

    Existing Code: Sub VendorSplit()'
    ' VendorSplit Macro
    '
    Dim Cl As Range
    Dim WS As Worksheet
    ...
  20. Replies
    9
    Views
    326

    Several Tabs in a workbook

    I have a file that I was assisted on by Fluff in the past. I am looking for a little bit of help. The macro that was created works perfectly and will split one table out into several tabs based on a...
  21. Re: Split one table into multiple sheets based on criteria

    Ok, thanks
  22. Re: Split one table into multiple sheets based on criteria

    Fluff, You helped me before I hope you can help me again. I have listed below the macro as it stands today. Is there anyway that the macro after splitting the tabs out, can create its own individual...
  23. Replies
    4
    Views
    132

    Re: Leading zero in CSV

    Yeah the only problem is that in reopening the file after making it a text format, Excel in its infinite wisdom drops the 0 again!! I truly hate CSV formatting anyway, but thankfully the automatic...
  24. Replies
    4
    Views
    132

    Leading zero in CSV

    So I have tried so many different ways before reaching out to you guys. Is there anyway to have a CSV file with leading zeros in a number field that will not drop the zero when reopening the file?!
  25. Re: Split one table into multiple sheets based on criteria

    Fluff

    YOU ROCK!!! THANKS AGAIN!
Results 1 to 25 of 82
Page 1 of 4 1 2 3 4