Link data with a loop

[SIMBAtheCAT]

Hi,

I have a workbook with two sheets. One contains raw data without any formatting. I'm trying to link the cells in "Raw Data" sheet to my "Clean Data" sheet.

The data are financial results by divisions and each division by year. So my goal is to do a loop 'Do until or 'Do while by the years to separate the divisions. My years go from 2008 to 2013 repeating itself for each divisions. Doing that way, when I add a year in my "Raw Data" sheet and re-run my code it will add the 2014 financial results to the "Clean Data" sheet.

I hope that for some it is an obvious answer. I'm not so bad in VBA but for some reasons, I have no imagination at all when it comes to looping... So, I am only asking for a code to get me started.

Any help is appreciated.

Thank you

[xladept]

Hi Simba,

Can you post a sample sheet??

[SIMBAtheCAT]

Hi xladept! I have attached a sample and changed all numbers in it.

Thank you.

[xladept]

Hi Simba,

I may have something for you tomorrow.

[SIMBAtheCAT]

Thank you, I'm looking forward to that.

[xladept]

Hi Simba,

Do you want all the companies on the raw sheet to be represented on the clean sheet?

[SIMBAtheCAT]

Hi xladept,

Yes that would be great, if possible.

Thank you

[xladept]

I decided that the best thing to do was to build a clean data sheet from scratch - maybe tomorrow

[SIMBAtheCAT]

From scratch? Lot of time. Sure, whenever you can.

Thanks.

[xladept]

Hi Simba,

This relies on the integrity of the raw data sheet - I had to correct the sample - but with that in mind, try this:

Deleted - Tomorrow another chance!

[SIMBAtheCAT]

Hi xladept,

I had a chance to try it yesterday before you delete it. It works fine except that the raw sheet must be perfectly in place to do so. Other than that, it is great.

Hope I'll be able to take a look at your new code today... if you have time. I wish I will be able to assist you the same way in the future if you need a code... And if doesn't require a loop of some sort ...

[xladept]

Hi Simba,

I've done some extra formatting with this one - glad that you liked the first copy:

Please Login or Register  to view this content.

[SIMBAtheCAT]

Unfortunately, I can't run this line :

Please Login or Register  to view this content.

Without this line it worked but the format and the years are just everywhere. So I replaced the line by :

Please Login or Register  to view this content.

But now, this line can't run :

Please Login or Register  to view this content.

If you could attached your file to see the differences that would help.

[xladept]

Hi Simba,

I think this fixes it:

Please Login or Register  to view this content.

[SIMBAtheCAT]

No, still have the same problem with the :

Please Login or Register  to view this content.

[xladept]

SimbaX.xlsm - This works on my machine, try it and let me know - program is in Module4.

[SIMBAtheCAT]

It works with it. I'm sure it has do to with the presentation of the data.

I'll try to breakdown the source of this glitch tomorrow. However, thank you xladept for your work! It is really appreciated.

[xladept]

You're welcome and thanks for the rep!

Perhaps you could post a book where it fails?

And, thanks for offering to help me with coding

[xladept]

Hi Simba,

I jazzed up the code a little:

Please Login or Register  to view this content.