Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter data on one sheet and copy to others
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter data on one sheet and copy to others
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter data in one worksheet and have it copy to another worsheet | Excel Discussion (Misc queries) | |||
Copy data when enter text containing the filename | Excel Programming | |||
copy data when enter the file name | Excel Programming | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
how do i enter data using formula and the Copy command For exa. | New Users to Excel |