VBA

Hi Vinay

As you have already assumed this needs some VBA code.

If its a straight forward copy of one cell in "Sheet1" to another cell in "Sheet2" then only a simple recorded macro is required.

1. Select the "Tools" menu, click "Macros" and the click "Record New Macro"

2. Name the macro "Copy_Data"

3. In "Sheet1" select cell "A3" and click "Copy"

4. Go to "Sheet2" select the destination cell "B7" and paste

5. Stop recording the macro

Every time you run the macro it will take whatever value in A3 and copy it to B7 in "Sheet2"

Now if every time you run this macro you want to paste in the next empty cell (B8, B9, etc) you will require some written VBA code that will search for the next empty cell in the required range before pasting the data.

We do run VBA courses if you are interested in learning VBA.

Hope this helps

Carlos