| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Displaying Returns from another worksheet that change?
Worksheet 1(WS1) has multiple rows and columns. Worksheet 2(WS2) is to display some of the columns and all of the rows from 1. The issue I have is that during my process, some of the rows from A are removed and placed in another location.
When using =A2 in WS2 the information looks great, the problem comes after removing/deleting row 2 in WS1 and having the remaining rows shift up. I then get the #REF! error in WS2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDF returns different result in worksheet to that in VBA | Excel Programming | |||
| Function that returns worksheet name? | Excel Worksheet Functions | |||
| number returns only two decimal places after I change from text | Excel Discussion (Misc queries) | |||
| Function that Returns Worksheet Name | Excel Discussion (Misc queries) | |||
| Is there a function that returns just the worksheet name | Excel Worksheet Functions | |||
Threaded Mode
