Error with Data Dump Macro

**maani** · 07-14-2009, 08:44 AM

Hello,

I have a model which I have created a macro for that will do a data dump of the date when I hit 'update' (on BBG Raw Data Tab) to Column A in the 'Data for Pivot' Tab. This works fine and all of the data comes over, except the last two data points in BBG Raw data (Cell A5055 and A5056) do not come across into the 'Data for Pivot' Tab (these should be going into Cell A5054 and A5055 of the 'Data for Pivot' tab). Would anyone be kind enough to take a look at the worksheet and the macros that I have written and let me know if they can come across the error? I have inserted the link to the file below.

Thanks,

Maani

http://www.4shared.com/file/11800545...g_Average.html

**StephenR** · 07-14-2009, 08:56 AM

Try this. I think your code can be shortened and simplified a little and I have taken the liberty.

Please Login or Register  to view this content.

**maani** · 07-14-2009, 09:22 AM

Wow, thanks so much Stephen! It works perfectly now. What was the reason it wasn't capturing the last two data points? Also, when I hit update, the worksheet runs much quicker; did the code you put in have anything to do with this?

Thanks again,

Maani

**StephenR** · 07-14-2009, 09:34 AM

Glad it worked.

In your code you were counting the number of non-empty cells but not allowing for blank cells at the top.

The turning off of screen updating and calculation speeds up code. Removing Select statements, which tend to be thrown up the macro recorder, has a similar effect.