simple VB

[ChrisMattock]

Hey all,

I have the following code that summarises the data from my first sheet on the second sheet. I need it to first clear all of the data on the second sheet though, when I added some code to do this it occurs at the end, which obvioulsy just erases all of the data sent accross. Also any other suggestions would be great as I'm rather new to VB and I'm sure I'm not using it that well!

Please Login or Register  to view this content.

[antoka05]

I don't understand what you exactly need... in the attached file I added a macro in the first sheet where I tried to simplify your macro... I hope it can help you.

Regards,
Antonnio

[mudraker]

With your macro as you are only using the data from the Monthly Data once it makes no sense to fill avariable with the data before putting into the External Invoicing sheet when it can be all done it the one action.

If using the data more than once then variables are the recomended way to go.

Please Login or Register  to view this content.