Prev: Type checking from VBA to C++?
Next: Change Data Connection Definitions from local to sharepoint
From: Kelly P on 25 Feb 2010 16:43
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?
From: JLGWhiz on 25 Feb 2010 20:55
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" <KellyP(a)discussions.microsoft.com> wrote in message
news:F1680014-D20C-465F-A119-67B947C3F34C(a)microsoft.com...
> 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?


 | 
Pages: 1
Prev: Type checking from VBA to C++?
Next: Change Data Connection Definitions from local to sharepoint