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

Similar Threads

Somewhat complex code to copy data from one sheet to another 9
Creating several smaller worksheets from a 'master sheet' 3
Create if partial match then copy and paste data from one cell to another 1
Want code to copy to ABOVE row 22 column A on sheet 1 10
Macro to Compile Data from Different Sheets 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Copy some of selected columns to master sheet 1
Copy columns and paste with blank column between 5

Top