I am unable to give you any pointers based on the information you have given in
this post or earlier postings.
Only you know which cell to copy and to where.
Gord
On Sun, 08 Jul 2007 12:50:12 -0700, fjs <(E-Mail Removed)> wrote:
>Everything is copied and pasted manually right now. The orders are
>based on a production run.
>When(if) production gets behind, that is why the cell to get copied is
>different, and the size of the to copied to range is also different.
>
>
>
>
>On Jul 8, 10:07 am, Gord Dibben <gorddibbATshawDOTca> wrote:
>> Are these orders based upon a filtered list or something similar?
>>
>> How do you currently select what data to copy and paste manually?
>>
>> Gord
>>
>>
>>
>> On Sat, 07 Jul 2007 21:19:17 -0700, fjs <fshep...@netscape.ca> wrote:
>> >That's the problem. The size of the range is based on orders. They
>> >are always diferent.
>>
>> >On Jul 7, 11:59 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
>> >> With great difficulty based upon those parameters.
>>
>> >> You don't know the cell to copy nor the range to copy to.
>>
>> >> Is there anything that could determine which cell to copy?
>>
>> >> I see your pattern for the start point of the range to copy to but what would
>> >> determine the size of the range from there?
>>
>> >> Gord Dibben MS Excel MVP
>>
>> >> On Sat, 07 Jul 2007 20:42:56 -0700, fjs <fshep...@netscape.ca> wrote:
>> >> >How do I make a marco to copy one cell in to many cells without
>> >> >knowing the starting of the range?
>>
>> >> >The start of the range will always be different, and the cell to be
>> >> >copied will always be different.
>>
>> >> >EX: this time copy a1 to a2:a28
>>
>> >> > next time copy a5 to a6:a28
>>
>> >> > and the next time it could be a54 to a55:a150
>>
>> >> >The start of the range will always be the next cell that is being
>> >> >copied.
>>
>> >> >Thanks.
>> >> >Frank.- Hide quoted text -
>>
>> >> - Show quoted text -- Hide quoted text -
>>
>> - Show quoted text -
>
|
Similar Threads
