Macro to transfer cells to another work book, but trying to transfer to next row in table.

[DONAGHYJJNR]

hi there

have managed to record a macro that works .....only i just want it to go one further and instead of copying the information to the cells i selected when recording it. I want it to place it in that column just in the next row in the table..So i can arrange the order from the headers at a later date.

Heres what i have and heaps of thanks for any help..

Please Login or Register  to view this content.

[DONAGHYJJNR]

ONLY MY SECOND THREAD SO IF I HAVE WORDED OR CREATED IT INCORRECTLY SOMEHOW PLEASE LET ME KNOW AND I WILL CHANGE IT

[dasle]

you have to add before the pasting process somthing like:

the no. 1 you can change it for the column number you want to paste it

You also have to at the begining of your macro paste the following:

[DONAGHYJJNR]

using this do i change all of the #1s to column i.e A or B?

and the 2nd part, should this be the first thing on the script after sub *macro name*
or were it repeats the name underneath.

Sorry if these are stupid questions i am totally new to anything like this.

Please Login or Register  to view this content.

[DONAGHYJJNR]

i have found using

Please Login or Register  to view this content.

will enter information to the next available row if it is not in a table...

just that little step to sort out.

any ideas?