Condense Macro

[Dan5953]

Hi Guys,

I have been using this site for a while now but this is my first post.

I have created a macro using the record macro feature in excel2010. Basically I have a bunch of data in sheet 1 and I need to move it to another Tab titled Asset Details. I was wondering if there was a way to condense the code down and not have it as long as it is. Thanks for taking the time to consider helping me out.



Thanks
Dan

[TMS]

Simplest way ...

This:

Please Login or Register  to view this content.

Becomes this:

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.

Repeat ad nauseam.

This is a little shorter but will be much quicker as it avoids sheet and cell selection.


Better would be have two arrays of source and target cell references and loop through the arrays and use a construct like above with the range addresses replaced by array elements.


Regards, TMS

[K m]

See if this helps you out:

[tigeravatar]

Building on what TMS suggested, this is what I came up with:

Please Login or Register  to view this content.

[Dan5953]

Thanks everyone, I will give them a try.

[Kyle123]

Possibly:

Please Login or Register  to view this content.

Or maybe even:

Please Login or Register  to view this content.

[TMS]

Thanks for the rep.

[Kyle123]

Thanks for the rep too