configure add button & code

[swain.s]

how do i configure a add button & code to do the following save data to a
different location

 

[Bob I]

record the macro, edit it to suit taste, assign to what ever button you
create.

 

[swain.s]

how do one edit the macro

record the macro, edit it to suit taste, assign to what ever button you
create.

 

[Bob I]

Alt+F11 opens the VB editor.

how do one edit the macro

:

 

[swain.s]

its once i am in the vb editor & I have the module open i don't know what to
do as putting in the strings/paths

 

[Bob I]

The location that you recorded, can be edited to reflect where you want
it to go. If you don't know the path, then you will need to decide where
this is going first.

 

[swain.s]

i know that i may sound a bit thick when trying to set i t up but i never
used macros to do this before, i want t save the data to another worksheet in
the same work book

 

[Bob I]

You want to copy one worksheet to another in the same workbook? Perhaps
starting over in a new thread and describing exactly what it is you want
to accomplish will result in a working solution. Currently the
description is vague and pretty confusing.