Rollup or summary sheet

Closed
JagMan
Posts
3
Registration date
Thursday January 27, 2011
Status
Member
Last seen
September 30, 2013
- Jan 28, 2011 at 10:51 AM
rizvisa1
Posts
4479
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 replies

have you tried using a pivot table?
0
JagMan
Posts
3
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
Sorry, I thought I emulated your requirement, but now I cannot replicate it. Its close but not a perfect match.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 8, 2011 at 05:46 PM
What makes a record unique ? is it TDM code
0