| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying named range
i have a list of cells in sheet1 that i want to be automatically copied to
sheet2. what i did was to use named range for the cells and use the forumla =namedRange in sheet 2. However it did not paste the entire range. Say the sheet1 cells are A1:A5. If i wrote the foruma =namedNamed in sheet2 cell C2, it will paste the value relative to the row which is A2 in sheet1. So if i write that forumla in C10, i get nothing. my ultimate goal would be to be able to copy the range of cells from sheet1 to sheet 2 automatically. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
| Dynamic Named Range with blank cells | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
Threaded Mode
