tlchan
08-22-2008, 05:26 PM
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
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