Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here is the long story short. I have two columns, A is company ID#
and B is company name. I need to search through the company names to find a certain one and when I find it, I must cut that cell with its adjacent co. ID# cell and insert both cells into another location in the worksheet. My question is...can I possibly tag or group the co. name and ID cells together?? Let's say I for some reason only cut the co. name cell by accident, I want excel to understand that the ID# cell is grouped with it and both will be cut automatically. Is there any easy way to do this?? I know that I could "name" both cells and have the one name refer to 2 cells...but thats a whole lot of extra work that doesn't make sense to do. Please let me know. Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Grouping Cells / Sorting | Excel Discussion (Misc queries) | |||
Grouping / Fusing Cells | Excel Discussion (Misc queries) | |||
Grouping or locking cells | Excel Discussion (Misc queries) | |||
Protected cells and grouping | Excel Discussion (Misc queries) | |||
Grouping cells | Excel Discussion (Misc queries) |