Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to look up and copy a changing range of data ?
How can I lookup and copy a section of data in a worksheet where the data row
changes from one day to the next (ie. fom a150..z300 to a250..z400) ? In worksheet 1 in column D I need to find a name "Birmingham" and from that row move to column A, select the range of data (a250..z400), copy, and paste into workrksheet 2. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a vlookup formula without changing the data range? | Excel Worksheet Functions | |||
range of Formula copy but not changing the content | Excel Discussion (Misc queries) | |||
How to copy range without changing formulas? | Excel Discussion (Misc queries) | |||
Copy formula into multiple cells without changing range | Excel Worksheet Functions | |||
How do you copy RANK w/o it changing the range? | Excel Worksheet Functions |