Search:

Type: Posts; User: =ODIN=; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    76

    Re: Search a substring within a text string

    Sorry I might be misunderstanding here. But I think what would help you is Microsoft's fuzzy lookup addin.

    https://www.microsoft.com/en-us/download/details.aspx?id=15011
  2. Replies
    2
    Views
    57

    Re: Pulling data from multiple .csv files

    The free to use Nutilities addin can help with that.

    This page would tell you how: http://www.iwishexcel.com/authors-favorites/generic-consolidator/
  3. Replies
    2
    Views
    88

    Re: Filtering Excel Data with VBA

    If you research advanced filters, I think those will manage what you are looking for. In your example though, you would have to enter "Place" and "Wolves" into 2 cells of your sheet first, then use...
  4. Replies
    1
    Views
    93

    Re: Macro to allocate line item data

    If you were to unpivot your allocation sheet, you could setup a sql left join of your data and allocation sheets using MS Query in excel. Then with a simple formula in the resulting table, your...
  5. Replies
    6
    Views
    153

    Re: Sub is this possible

    After a bit of googling it seems like there is no way in vba to programitcally get thisSub.name. The great Chip Pearson’s website even has a page about it:...
  6. Re: PivotTable.TableRange is returning the wrong value!

    You are misunderstanding what those properties do. They either include or exclude the page filter of a pivot table when telling you where the pivot table sits on a worksheet. If you have no page...
  7. Replies
    6
    Views
    153

    Re: Sub is this possible

    It seems like that might miss the point Alpha. It seems like they were trying to figure out if there was a way to programatically figure out the sub name so they could just use



    Sub One()...
  8. Re: VBA Transform Data into Excel Table(No Repetitive Header and Future Expandable)

    It seems like what you are asking for could be done with a pivot table. Try putting your data from 1) into a pivot table then putting type into rows and supplier into columns
  9. Re: Help needed to make VBA loop more efficient - needs to handle a lot of data

    Not sure if you still care, but assuming you are still working this issue, this code should be significantly faster. You will just need to update the findNamesAddress for each run.




    Sub...
  10. Replies
    4
    Views
    147

    Re: active workbook name - new workbook name?

    I went ahead and setup an add-in file that will function like your first post described -- msgboxing name of any workbook that is opened.
    You can download it from the link below.
    To get it to...
  11. Replies
    4
    Views
    147

    Re: active workbook name - new workbook name?

    It looks like your code is functioning like it should.

    The below event only fires when the workbook it is located in is opened (it is a workbook level event). Since yours is in personal.xls, it...
  12. Re: VBA to find rows with specific text and count the zeros

    Does it need to be a macro?

    You could use an array formula to do this in a helper column.


    If your data has sub-total in column d, and you wanted to counted the zeros in columns e-h you...
  13. Re: Run many large update queries in the right order one at a time possible?

    You absolutely can do that.

    fast foward to 3:40 in the below video
    https://www.youtube.com/watch?v=WPBYxh4WuXE
  14. Re: VBA to copy data from multiple workbooks into one sheet if condition met

    I'm not sure how comfortable you are with coding, but my advice would be to code it this way (pseudo code below)



    dim pasteRow as long 'will keep track of next unused row on main sheet for...
  15. Re: extracting data from Multiple tabs into a table by matching text in column

    One way you could do it is to use a free tool called "generic Consolidator" to consolidated the data from all 50 tabs to one tab. Then apply an auto-filter to the consolidated data and filter on...
  16. Replies
    11
    Views
    428

    Re: Rearranging Data in Excel

    It looks like what you are trying to do is called unpivot. If you have excel 2016+ you can use the built in power query to do this I think -- I've never done it, but you should be able to google it....
  17. Re: If Chip Pearson's website ever helped you, please jot a note...

    I never new Chip, but he and his work were a good influence on my life. I'm sorry for my late condolences -- I've managed to recently visit his site before ever even reading this sad news.
    ...
  18. Replies
    1
    Views
    274

    Re: Run Access Macro from Excel

    In order to rule out whether it is a library reference issue, try late binding the access app.

    Just change your one line of code:

    Dim AccDB As Access.Application

    to


    Dim AccDB As object
  19. Replies
    5
    Views
    415

    Re: Speed Up Formula for +3000 rows

    Have you worked with arrays in VBA yet?

    If not, that is what you should start researching.

    Since excel 2007 and beyond, cycling through cells in a range has been extremely slow, so the best...
  20. Thread: userform help

    by =ODIN=
    Replies
    2
    Views
    244

    Re: userform help

    I feel like i'm missing something here. Is there anything stopping you from using vlookup in your code to get the email associated with comboBox1's value?
  21. Re: combining texts (many many cells) in a smart way. Guidance needed!

    If you have excel 2016 the textjoin function might do this -- I'm not certain because I don't have it.

    I use the Nutilities addin for this myself. If you have excel 2007 and up, you can use it...
  22. Re: Pause or stop VBA for a manual edit to the sheet

    It looks like your code was deleting one row at a time. Have you tried applying an autofilter and then deleting all the rows at once?
  23. Re: Pause or stop VBA for a manual edit to the sheet

    While you guys are technically correct in that you can’t stop and start a sub while you edit a sheet, you can use a mode less userform with a single button and sub that will simulate the effect. The...
  24. Re: Pause or stop VBA for a manual edit to the sheet

    What you are describing can’t be done with a standard excel msgbox. You could manage it with a modeless userform though.
  25. Replies
    2
    Views
    199

    Re: Copy and Move files and folders

    I don’t have my computer in front of me to test this, but this might work.

    Try fixing the from path line to this:


    FromPath = “A:\*”
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4