| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.access.gettingstarted,microsoft.public.excel.programming
|
|||
|
|||
Sorting and Moving Rows in Multiple "stencil " worksheets
Hello, I hope that someone can help me with this problem. I have two
worksheets in the same Excel file; each worksheet has 3 columns as shown: Name Abbreviation Value in the first worksheet. Name Abbreviation Comments in the second worksheet. As I type in the first Worksheet the first two columns are directly copied automatically into the second worksheet due to the formulas I have placed in the second worksheet. However, if I alter the first worksheet columns, then the comments do not follow correctly in the second worksheet. The comments column will not stay with the correct rows anymore in the second worksheet if I move the data around in the first worksheet. Can anyone offer advise? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a text strings but omitting preceding "A" or "The" | Excel Worksheet Functions | |||
| Sorting by "High", "Medium" and "Low" | Excel Discussion (Misc queries) | |||
| How do I get Excel to ignore "a", "an", "the" when sorting? | Excel Discussion (Misc queries) | |||
| Sorting "State" Column onto separate worksheets in same workbook. | Excel Worksheet Functions | |||
| Copy "Page Setup" for multiple worksheets of identical size. | Excel Discussion (Misc queries) | |||
Linear Mode
