Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Extracting text from a random string and matching to a list

    I have a csv file which I have downloaded to Excel. The name of this worksheet is 'Tickets'. This contains text strings of random length which include standard 'labels' of random length. The text...
  2. Replies
    5
    Views
    43

    Re: Date / time conversion to dd/mm/yy

    Genius!

    Thank you very much!

    HT
  3. Replies
    5
    Views
    43

    Date / time conversion to dd/mm/yy

    I have a column of dates and times downloaded from a CSV file formatted as text as:

    2019-10-10T08:30:47+00:00

    Please could you generate a formula that converts the first part into:

    10/10/19?...
  4. Replies
    1
    Views
    57

    Text to Columns with multiple delimiters

    I wonder if you can help.

    I have been tasked with extracting text from a CSV download from an app of a list of standard responses. As a download these contain multiple strings of characters such...
  5. Re: VBA for Advanced filter copy to another location

    Perfect!

    Thank you very much!
  6. Re: VBA for Advanced filter copy to another location

    Yes, exactly that.
  7. Re: VBA for Advanced filter copy to another location

    Sorry to come back to you, but when I run this it deletes the filters on other worksheets. Is it possible to prevent this happening?

    Many thanks

    HT
  8. Re: VBA for Advanced filter copy to another location

    Thank you so much!

    Works perfectly!

    HT
  9. Re: VBA for Advanced filter copy to another location

    Apologies! (Got the boss breathing down my neck)

    Criteria is on the sheet called 'Lookup'. The filter range is C3:C4. C3 is 'Issue no' which is the same as the header for column B in the Lookup...
  10. Re: VBA for Advanced filter copy to another location

    Many thanks, but unfortunately this did not work because I did not explain properly.

    The data is in a sheet called Data with the header in row 4 and the data in row 5 onwards.

    The filter is to...
  11. VBA for Advanced filter copy to another location

    Apologies - not a VBA Ninja! I have found the code below to perform an advanced filter in place so that a user can enter the filter criteria and the data will update automatically, but could someone...
  12. Advanced Filter not updating automatically

    I have set up an advanced filter but it won't update automatically, but then again maybe it's not supposed to!

    I have a data entry worksheet to which random part numbers are added against known...
  13. Replies
    11
    Views
    201

    Re: Extract data from a list using criteria

    Thanks, I think I have discovered the problem.

    Trying to make things simpler for users (or being too clever by half!) I had used a formula to make Tab Name = Cell Name (which would be the fault...
  14. Replies
    11
    Views
    201

    Re: Extract data from a list using criteria

    Many thanks for this, it's incredibly helpful! Which leads me to another problem...

    The data sheet has data about faults. Column A is the fault number (multiple instances), column B is the...
  15. Replies
    11
    Views
    201

    Re: Extract data from a list using criteria

    Sorry to ask another question. Due to the design of the spreadsheet I have had to move the columns of data across and down a bit. I have amended the formula to reflect the changes in the Data...
  16. Replies
    11
    Views
    201

    Re: Extract data from a list using criteria

    Thank you so much!

    HT
  17. Replies
    11
    Views
    201

    Re: Extract data from a list using criteria

    Very many thanks! How would it work if I wanted the data in columns A and B in a worksheet called Data, and the results in a worksheet called Lists? I have tried fiddling around with the formula...
  18. Replies
    11
    Views
    201

    Extract data from a list using criteria

    Has me stumped.

    Column A: Fault codes (3 digit, multiple instances in random order)
    Column B: Unique serial number of part that has the fault in Column A.

    Data is continuously being added to...
  19. Replies
    10
    Views
    467

    Re: Aligning randomised worksheet columns

    Thank you so much for your responses.

    Some genius has now rejigged the latest version so it has 41 columns! Within this, there are multiple variants of what is where, so chaos now reigns.

    As...
  20. Replies
    10
    Views
    467

    Re: Aligning randomised worksheet columns

    Wow! Thank you very much!

    I think I will stick with the formula version because this has to be repeated by someone who doesn't understand VBA.

    For clarity, what are the column letters? As I...
  21. Replies
    10
    Views
    467

    Re: Aligning randomised worksheet columns

    Truiz

    Very many thanks, but I couldn't get it to work. I see that you said that it assumes that all sheets have the exact same header rows but in a different order. The problem is that there are...
  22. Replies
    10
    Views
    467

    Aligning randomised worksheet columns

    I have to combine several worksheets originally based on standard columns into a single worksheet, but users have randomly included extra columns. So for example if the original headers were:
    ...
  23. Replies
    0
    Views
    539

    Conditional Format Colour Scale RGB values

    Embedded Conditional Format colour scales have preset colours so that a range from 1 to 10 would be coloured from green through amber to red (unfortunately I can't post an image).

    I want to create...
  24. Replies
    0
    Views
    136

    Copy / paste Visio to Excel

    A colleague has created a lovely Visio table created from text boxes in columns and rows .... and now wants to be able to filter and sort it!

    It is possible to copy and paste an individual Visio...
  25. Replies
    94
    Views
    8,489

    Re: Extract multiple keywords from text string

    Dear all

    Very many thanks for your continued help, and apologies for my absence. I have been out of the office for most of the past two weeks and unable to catch up. I will look at your kind...
Results 1 to 25 of 76
Page 1 of 4 1 2 3 4