| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy info in a range that always changes.
I have the following list
row 9 piece 1 12x12x12 $$$ row 10piece 2 12x24x12 $$$ Row 15 total material $$$ This list can have a various amounts of entrys so "total material" will not always be Row 15 (piece 1 will always be row 9) and I would like to know if there is a way to tell excel to Find what Row "total Material" is in and copy Range ("9:"total Material" row) Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy info in a range that always changes.
Have you tried using the vlookup function? -- mcarrington ------------------------------------------------------------------------ mcarrington's Profile: http://www.excelforum.com/member.php...o&userid=21641 View this thread: http://www.excelforum.com/showthread...hreadid=500803 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
| Copy a range from closed workbooks (ADO) | Excel Discussion (Misc queries) | |||
| copy named range to powerpoint | Excel Worksheet Functions | |||
| CheckBox Code to copy & paste range | Excel Discussion (Misc queries) | |||
| help with range copy | Excel Discussion (Misc queries) | |||
Hybrid Mode
