tables

  1. C

    Excel seperate data into a Matrix

    Im looking to transform data output into a matrix. The data - continous table: Date Names Topics 1/1/01 Tom;Dick;Harry topic1;topic2;topic3 7/1/01 Dick;Harry topic1;topic4 The matrix required: Topic1 Topic2...
  2. E

    Lookup Sum of Table by Week

    Hi All, I'm trying to look up / match the weekly sum without putting in a summary column per week. e.g. return the sum of ('John'!)B5:H5 into cell ('Weekly Summary'!)B4. Look up value column A. I've attached an example of what I'm trying to do.
  3. L

    merge/join/combine multiple tables into one master table

    Hi, i'm new in using excel macro and vba. In my workbook, there are large amount of uncluttered data in many table in one worksheet. I need help how to combine/merge/join multiple table in one worksheet into one master table into another worksheet using userform? i'm sorry if my explanation is...
  4. L

    multiple table in one worksheet into one master table

    Hi, i'm new in using excel macro and vba. In my workbook, there are large amount of uncluttered data in many table in one worksheet. I need help how to combine/merge/join multiple table in one worksheet into one master table into another worksheet using userform? i'm sorry if my explanation is...
  5. R

    Create Form to Update Table

    Hi All, I'm looking to create a form that will update rows in a table. The form is a user entry form so X person can fill in the necessary information and then hit "Save" which will add a new line into the table. I'm not particularly well versed with Forms, I've historically avoided doing...
Top