Search Results for ‘tables’

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...

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.

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...

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...

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...