Hey all,
Pretty n00bish at vba but I'm pretty well acquianted with vb. Basically my goal is to do one of two things, both of which I think will work.
1) Commit my entier dataset into the array. Then loop through it and pull out the SETS of row that I want (I'll get to that in a second)
2) Test for the unique values before I put them into seperate arrays.
I have what basically amounts to an attendance sheet. The major info is what Building they are in, and what Area of that building they are in. Areas are not unique to the faciltiy, they are {A, B, C..}. I have a seperate columns for building and area. On this sheet multiple individuals can belong to a single area but not vice versa. In typical attendance sheet fashion I have the whole month on each sheet, and 12 sheets for the year.
My dataset will always be selcted (by a button) correctly, and it will always be in ascending order. I need to create a summary of attendance for each area.
What I'm thinking is that I need to identify the rows for each "unique" area. And place them into seperate 2D arrays like (row, attendance info). I mean in my head I say it like this "if colomn A & column B in row 1 = colomn A & column B in row 2 then add both rows and contiune. elseif colomn A & column B in row 1 <> to colomn A & column B in row 2 then commit row 1 and start again on row 2". Just to clarifiy column A holds building and column B hold area.
So what kind of things do I need to be looking at here? Whats important and whats not? The extent of my knowledge of vba, google has gifted me with
. So if nothing else just try to point me in the right direction.
I'll try to do anything I can to help you help me.
Thanks in advance
Pretty n00bish at vba but I'm pretty well acquianted with vb. Basically my goal is to do one of two things, both of which I think will work.
1) Commit my entier dataset into the array. Then loop through it and pull out the SETS of row that I want (I'll get to that in a second)
2) Test for the unique values before I put them into seperate arrays.
I have what basically amounts to an attendance sheet. The major info is what Building they are in, and what Area of that building they are in. Areas are not unique to the faciltiy, they are {A, B, C..}. I have a seperate columns for building and area. On this sheet multiple individuals can belong to a single area but not vice versa. In typical attendance sheet fashion I have the whole month on each sheet, and 12 sheets for the year.
My dataset will always be selcted (by a button) correctly, and it will always be in ascending order. I need to create a summary of attendance for each area.
What I'm thinking is that I need to identify the rows for each "unique" area. And place them into seperate 2D arrays like (row, attendance info). I mean in my head I say it like this "if colomn A & column B in row 1 = colomn A & column B in row 2 then add both rows and contiune. elseif colomn A & column B in row 1 <> to colomn A & column B in row 2 then commit row 1 and start again on row 2". Just to clarifiy column A holds building and column B hold area.
So what kind of things do I need to be looking at here? Whats important and whats not? The extent of my knowledge of vba, google has gifted me with
. So if nothing else just try to point me in the right direction.I'll try to do anything I can to help you help me.
Thanks in advance
