click button and send data from one sheet to another

**Sonyk** · 07-09-2009, 11:32 AM

Hi

I have two excel files A and B and i want to send data from one sheet in A to a sheet in B when i click a button (activeX). How can i do this?

thank you

**Paul** · 07-09-2009, 12:32 PM

Hi Sonyk,

First, you have to add a command button to your worksheet.
Second, you have to write code in the command button's Click event to move the data.

The code that needs to be written is 100% dependent on the layout of your data, which data needs to be moved when you click the button, where it needs to be moved to on the second sheet, and what to do with the area previously occupied by the moved data.

Hint hint... try uploading a spreadsheet with your requirements for moving the data, and provide a before & after view.

**Sonyk** · 07-18-2009, 06:10 PM

ok I will try... here it is

I want to put the info from the doc A to the doc B... please write the code of the button here or in the sheet

thank you very much