Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Looping through a data set and retrieving values

    I wanted code so that it could slip into a large piece of work I'm doing. Vlookup I've been using for over 20 year but it doesn't fit here. I've pulled something together that works for me, so I'm...
  2. Re: Looping through a data set and retrieving values

    Hi

    I would do normally, but I will be looping through many thousands of rows, based on other conditions before I need to loop through this part of the data set.

    Thanks
  3. Looping through a data set and retrieving values

    <tbody>
    1



    Find
    Found
  4. Replies
    1
    Views
    80

    Comparing data in 2 text files

    I have written a piece of code that asks the user to open one text file and it loads it into an Excel sheet. Then asks for a second text file which it loads into another sheet. Then runs through the...
  5. Replies
    4
    Views
    135

    Re: If Function Turnaround Time

    Scrap my answer :)
  6. Re: Converting minutes and seconds as text to a time.

    Thank you both Gerald and tyija1995. Both perfect.

    Thanks
  7. Converting minutes and seconds as text to a time.

    Hi

    I have time in an Excel sheet showing minutes and seconds as text e.g. +08'30 and I'd like them to be shown (using VBA as there are thousands of rows) as 00:08:30 which is a number format. Any...
  8. Replies
    5
    Views
    216

    Re: Selecting sequential numbers only

    :) Cheers Footoo
  9. Replies
    5
    Views
    216

    Re: Selecting sequential numbers only

    Thank you footoo. I meant to say VBA, but I used your logic in the formula to create the code


    Sub Sequencing()
    Dim cell As Object
    Dim irow As Long
    Dim LastRow As Long
    LastRow = Cells(99999,...
  10. Replies
    5
    Views
    216

    Selecting sequential numbers only

    Hi

    I was looking for a way of moving sequential numbers from Column A to Column B. I.E. If column A had numbers 1,3,6,8,9,10,11,12,15,17,19,20,21,24,28
    Then numbers 9,10,11,12 and numbers...
  11. Re: Comparing columns of data between worksheets and returning value when matched.

    That works a treat Andrew. I'm going to wok through it and understand it as well. Thanks again.
  12. Re: Comparing columns of data between worksheets and returning value when matched.

    Thank you Skorpionkz. It will take a bit for me to understand it, but I am starting to learn about classes, collections and dictionaries so this will be great for me. Appreciate it.
    BTW The result...
  13. Comparing columns of data between worksheets and returning value when matched.

    If I had three columns in one worksheet and three columns in another worksheet to compare. How can I check the 2nd worksheet to find matching records to the 1st worksheet, then pull out the fourth...
  14. Replies
    2
    Views
    168

    Re: Simple Class module example required

    Thanks Marcelo

    I actually did have a look through that site. It was helpful, but I need something shorter to start with though Simple Class module, being looped through to had the values to a...
  15. Replies
    2
    Views
    168

    Simple Class module example required

    Help

    Can anyone provoide me with a very simple Class module example that captures for example peoples first names in column "A", Surnames in column "B" and loops through that column and adds them...
  16. Replies
    3
    Views
    468

    Re: Struggling to learn Excel VBA

    Thank you Hiker95.
    I will check out all those resources. Not sure if any of it will sink in though. I do think I'd need at least some Online training in 1 to 1 sessions.

    Thanks
  17. Replies
    3
    Views
    468

    Struggling to learn Excel VBA

    Hi

    I know this isn't a unique question but I've been dipping in and out of Excel VBA for over 15 years and not learned much.

    Most of the role I currently undertake uses Clas modules,...
  18. Replies
    1
    Views
    117

    Access SQL query to Excel output

    Hi

    I am running sql which prompts the user to select the directory where they want to save the result.

    It worked when I had it as csv, but when I change it to be xlsx as below, I get the...
  19. Re: Checking whether a date and time is in a cell rather than just a date

    Actually that does it, thanks


    Thanks
  20. Checking whether a date and time is in a cell rather than just a date

    Hi

    Is there some vba code that can check whether a cell has a Date and Time or just a Date?

    So 01/04/2019 is good, but 01/04/2019 05:20 should flag up to say "No".

    Thanks
  21. Tracking and logging changes to values within one column.

    I have a piece of code (Which I got from this site) that tracks changes to cells within the worksheet. It works great except I'd like it to look a changes just within one column only, not the whole...
  22. Replies
    3
    Views
    245

    Re: Printing Dictionary Values

    Thanks Fluff

    That will do nicely. Appreciate it.
  23. Replies
    3
    Views
    245

    Printing Dictionary Values

    Hi

    I can print Dictionary values to the immediate window by running the code below, but I wanted to know how I print "all" the Dictionary values into an Excel sheet?



    Public Sub...
  24. Re: Copying a button from one sheet to automatically run code when copied to new sheet.

    Many thanks DanteAmor, that does the job nicely

    Apprciate it.
  25. Copying a button from one sheet to automatically run code when copied to new sheet.

    Hi I am struggling with getting a macro to run when I create a new button on a sheet. I assign the On Action to the button and the macro runs without debug, but... the OnAction doesn't run the Macro...
Results 1 to 25 of 100
Page 1 of 4 1 2 3 4