This statement is too ambiguous to determine which row on which sheet that
you are referring to:

what i
need is for it to go to the next available cell within that row,


"Kelly P" wrote in message
...
I'm not sure if this can be done or not...i currently have a workbook with
3
sheets, sheet one is the master sheet and i have some vba coding that if
column a is not blank it copies over to sheet 2, this is working well but
now
i have added sheet 3 and need the master to copy to it, it's a little more
complicated because some of the cells already contains information and
what i
need is for it to go to the next available cell within that row, basically
fill in the blanks; column b in the master needs to copy to column a in
sheet
3, d and f in the master needs to concatenate into column b and column m
needs to copy to column c..is this possible?