Excel 2007 : Repeat Columns in multiple sheets

Hello,

I would like to have Column B in Sheet 1 repeat automatically in Sheet 2 as Column A. Is there a macro or formula for this?

I have used the VB code from http://www.excelforum.com/excel-work...orksheets.html However it doesn't work on my workbook. It may be because I'm new to VB and I'm just doing it wrong.

Thanks!

First question would be, where have you put the code? Second question would be, did you try to modify it or just use it? Third question would be, in what way does it not work? Does it do nothing? Does it do something but not the right thing? Does it generate an error?

Best bet is to post a sample workbook with the code and some typical data.

Regards