You know the feeling when you have gone so far down the road that you realise that you can't go back, well that is how I feel.
A member of staff is currently doing a survey to 1100 staff at the offices where I work and has sent out a paper questionairre to them. She asked me to help her out with a method of quickly inputting the information onto her PC . She originally told me that there were about 50 questions with 5 options to ticks. Being a bit of a novice at excel VBA I said that I would put together an excel form which would output to an excel worksheet. The form uses optionbuttons which offsets each optionbutton value to the next active cell. I was then going to open a new worksheet and use the countif satement to count the number of each "True" answer in the respective columns. It works fine as there are 250 columns and just fits nicely across the sheet with 6 cells to spare...few.
Now comes the sad bit....
She neglected to tell me that there were in fact 7 options to each question, which now expands my row to 350 columns, which doesn't fit on a worksheet. No problem, I say, I will spread it over 2 worksheets, 2 groups of 25 question responses...works fine. Until her boss says to her "I want to do some demographic stats from the responses, not just counts" i.e. "The number of White-Irish who answered no to question 6"
This would work fine if I had been told all of this info and I would have probably gone down the road of creating a small access database, and it would have been easy for me if it had all been on one worksheet, but as the info is now spread across two sheets how can I append the data so that I can start interrogating it (anything in row 1 on sheet1 correspons to row 1 on sheet2 and so on).