Enter data on one sheet and copy to others

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?
 
J

JLGWhiz

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top