Re: I a little direction in starting my project
The issue of using only the "old" sheets means that now you can do imports consistently. However, the number of files mentioned earlier makes me wonder if it wouldn't be a good idea to import all that data once and include as part of the imported data that you would have a list of files already imported. Then you can run your import process and ignore files already imported, only appending new data to the master table.
I see that CJ made the "import" suggestion as well. I'll second his proposal.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.