Hi there,
I have 3 worksheet and I wanted to transfer my current data in sheet("Cards") column D Add to column E of the same sheet and at the same time append to next column A in sheet ("FY0809").

The button in sheet("reportdate") will run the macro for above task. However the data only appended in column B of sheet ("FY0809") instead of next column on every button pressed.

The macro works in VBE under run but failed in button click command. Anybody can assist me ?

Attach the sample workbook