Search:

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

Search: Search took 0.00 seconds.

  1. Thread: VBA List Data

    by hshone
    Replies
    5
    Views
    209

    Re: VBA List Data

    Yes it did work, but spat the results over columns not rows.
  2. Thread: VBA List Data

    by hshone
    Replies
    5
    Views
    209

    Re: VBA List Data

    Thanks;

    This is what i have so far, but its a little clunky and keeps referring too/ recalc excel cells, Ideally want to keep the random numbers the same to speed it up a little hence using...
  3. Thread: VBA List Data

    by hshone
    Replies
    5
    Views
    209

    VBA List Data

    Hi all,

    I have a list of data:

    Apple 580
    Pear 245
    Orange 867
    Cherry 870
    etc.
  4. Replies
    2
    Views
    86

    Multiple Column Index and Match

    Hi all,

    I'm trying to get a multiple column index and match. The data set is much larger but looking to find who has had sales in what region.

    I have the below data: (Stating in Cells A7)

    ...
  5. Paste array data alongside copied data from other worksheet.

    Hi all,

    I have a piece of code that opens, copies and pastes multiple sheets into one sheet in my work book. However, one problem i can’t identify the dates of the data.

    At the moment I have...
  6. Replies
    0
    Views
    160

    Copy multiple files via vba code

    Hi all,

    im looking to copy multiple files into one file.

    In column a:b I have date and unique file path starting at row 5 respectively.
    the excel files I want to open the data starts at a5...
  7. Replies
    5
    Views
    1,519

    Re: Index Match Wild Card

    Hi,

    It doesn't seem to work when there are multiple 'line items' i.e when i have multiple people with the surname smith.
  8. Replies
    5
    Views
    1,519

    Re: Index Match Wild Card

    Worked like a treat, many thanks!!! :)
  9. Replies
    5
    Views
    1,519

    Index Match Wild Card

    Hi all,

    I'm trying to have an index and match formula which wild cards a last name against the date they attended.

    At the moment I have this formula:

    =INDEX([Date...
  10. Replies
    5
    Views
    817

    Re: Index Match Multiple Rows

    Hi Sorry I had a space behind the letter making it not work.

    The next problem I'm facing is that is it possible to extend this over a whole col. at the moment I'm having to enter the array...
  11. Replies
    5
    Views
    817

    Re: Index Match Multiple Rows

    Hi,

    Many thanks for getting back to me. I can't seem to make it work, even when setting up as an array formula. Any reason why it might not be working, i'm using excel 2010 would that make a...
  12. Replies
    5
    Views
    817

    Index Match Multiple Rows

    Hi all,

    I'm trying to get a formula that can return multiple data across various rows.


    <tbody>
    Id

    Room
Results 1 to 12 of 12