| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy range with different ranges.
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy range with different ranges.
One approach:
With Range("A1") .Copy .Offset(1,0).Resize(27, 1) End With "fjs" 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy range with different ranges.
Dim rng As Range Set rng = ThisWorkbook.Sheets("Sheet1").Range("A5:A33") 'or whatever rng.Value = rng.Cells(1).Value Tim "fjs" wrote in message ups.com... 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy range with different ranges.
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 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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy range with different ranges.
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 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 - |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy range with different ranges.
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 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 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 - |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy range with different ranges.
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 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 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 - |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy range with different ranges.
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 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 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 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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy big ranges of cells without drag or copy/paste? | Excel Discussion (Misc queries) | |||
| how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
| Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
| compare ranges in different workbooks and copy "not matching values" at bottom of range 1 | Excel Programming | |||
| Compare ranges n copy at bottom of first range | Excel Programming | |||
Hybrid Mode
