Building a macro to copy a set of column

Microsoft Excel 2003 (full product)
September 3, 2010 at 02:22:29
Specs: Windows XP
Hi all,
here is my issue (first of all I've never used macros). I need to build a macro so that by pushing a button - ie "add a new blabla" -, it will copy a set of five column just next to the existing one. the trick is that I need it to also copy two different set of column in two other worksheet at the same time, but in the same manner (just next to the existing one). basically i'm building a calculator, and it's to facilitate the adding of items in it.
Does that make sense at all?

See More: Building a macro to copy a set of column

Report •

September 3, 2010 at 13:33:23
Turn on the Macro recorder, do exactly what you want it to do and hit the Stop recording the macro button and save it.

Or, move your post to the Office forum where there are a couple of MS Excel macro experts.


Report •
Related Solutions

Ask Question