Combining excel files

Hi

The only easy answer I can give is whichever option gives you have the most flexibility in the long run with the least transformation coding in the short term. If you know the size and format of the tables you have in each sheet won't change, its only the data that will then you can connect and transform the data as they are now. However, if you think in the future it might change you will probably want to save the time now and move them to separate sheets. It's only a copy worksheet and then remove what you don't want from each sheet anyway.

The answer to your second point is you will decide that. You will connect to both datasets, you can then merge immediately and transform. Its as I mentioned earlier, what's the easiest solution for you? If the transformation you will perform is the same to both datasets you don't want to replicate the code. Alternatively, if you need to maintain separation for future flexibility keep it separate then merge the sources towards the end.