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?