Previous Topic Next Topic

Rollup or summary sheet

Closed
JagMan Posts 2 Registration date Thursday January 27, 2011 Status Member Last seen September 30, 2013 - Jan 28, 2011 at 10:51 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 8, 2011 at 05:46 PM
Hello,

i am quite a 'newbie' at VBA and have run into something that i can't seem to get started. i have sheets by month that have the same amount of columns every month. however, the amount of rows will be different each month. there are duplicate items in each column differentiated by one or more of the other columns. it's probably best to give an example of what i have then of what i would like to see. i hope this is enough info. all help is greatly appreciated.
here's the link to my spreadsheet. thanks again.

http://www.editgrid.com/user/jagman/Book2TEST

4 responses

Answer 1 / 4
rayh
Jan 28, 2011 at 01:36 PM
have you tried using a pivot table?
0
Answer 2 / 4
JagMan Posts 2 Registration date Thursday January 27, 2011 Status Member Last seen September 30, 2013
Jan 31, 2011 at 11:13 AM
yes, i did, but i must say that i don't quite understand them. i had better luck with putting this all into a database and running a query on it. but i ran into problems there as well. duplicate records and such. may i ask how you see using a pivot table to get what i want?
0
Answer 3 / 4
RayH
Feb 4, 2011 at 11:50 AM
Sorry, I thought I emulated your requirement, but now I cannot replicate it. Its close but not a perfect match.
0
Answer 4 / 4
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 8, 2011 at 05:46 PM
What makes a record unique ? is it TDM code
0