table dynamic sort

https://drive.google.com/open?id=0B7X5e_N0aRshSUthVkNZdXZLUmc Hi all, Link above to excel file in question. The first sheet is simply a table of data - in this case business done with organisations, and the monetary values. Sheet two is an analysis sheet which totals the number of work...

Hello, I am looking for a formula to achieve this and can not be a macro. I have three tables with 3 columns each and different row lengths, need to group all columns by names and make sum of the values on the SUM table like the follow: [/IMG] Is it possible without macro? Thanks in advance...

Good day sir/ma, I have an excel sheet that has about 5000 companies in 52 USStates. In my existing sheet, I have only s/n, company, state. I need to insert the US codes for their corresponding states into the sheet. See the tables below for better illustration. How can I implement this? I think...

I have a table that can be sorted with formulas that reference rows above/below a formula. As I sort the table, using absolute references or not, I cannot get the formulas to stay with the correct row as it is sorted. I also have formulas in the row that refer to other columns of that row so the...

Hi All, Is it possible to create a master table and then build another table off of the master table by defining a dynamic range of cells that fit a specific criteria like the Tutor column below? I have an example of my master table that contains school, tutor and date. To the right I want a...

I am trying to shortlist a table by matching information from a list, and would appreciate your help. The list and the table are variable in size and content, the location in the table where the list members can be found also varies. Below is a simplified example of what I am looking at and what...

Hi I’ve got quite a complex problem to solve and I’m not even sure if this can be resolved with VBA? Maybe some of you can look at it and give me some ideas. Unfortunately I’m not really familiar with programming I will however try to modify certain codes if necessary. <?xml:namespace prefix = o...

Hi All, I am trying to create a dynamic macro to sort a table in excel 2007. I have created the code below. I am hoping to be able to replace the specific table names to the 'active table #' if possible. Can someone point me in the right direction? I appreciate the help. Sincerely. Pancho...