Before you can decide how you are going to put all the records into the WorkBook, you need to decide what you are going to do with the data after it is in there. This will be paramount to how you go about this in the first place.Work records. So, sounds like I need to have it split between multiple worksheets?
Access is not something you want to start using if you are not familiar with it, I didn't know that until you have just mentioned it. If you did want to go down that route then an Access forum would be your best bet.To be honest, I haven't used Access before. Would you be willing to give me a few steps on how this is done?
Before you can decide how you are going to put all the records into the WorkBook, you need to decide what you are going to do with the data after it is in there. This will be paramount to how you go about this in the first place.