Enter data on one sheet and copy to others

  • Thread starter Thread starter Kelly P
  • Start date Start date
K

Kelly P

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?
 
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,
 
Back
Top