how do I keep my rows together?

[Kris]

I have two workbooks that I use to store different pieces
of information on the same employees. In both workbooks,
the first column is the employees' first name and the
second column is the employees' second name. After that,
the columns contain different pieces of information about
the employees. I need to make sure that if I add or
subtract an employee from one of the workbooks, he/she is
added/removed from both of them, so I tried to make the
first two columns in one workbook equal to the first two
columns in the other. The problem is that while the
cells in the first two columns shift to make room for the
added/subtracted name, the rest of the cells remain in
place, and the first and last name cells become
misalligned with the rest of their original row. How do
I fix my workbooks so that the rest of the row shifts
with the first and second cells?

 

[Harlan Grove]

I have two workbooks that I use to store different pieces
of information on the same employees. In both workbooks,
the first column is the employees' first name and the
second column is the employees' second name. After that,
the columns contain different pieces of information about
the employees. I need to make sure that if I add or
subtract an employee from one of the workbooks, he/she is
added/removed from both of them, so I tried to make the
first two columns in one workbook equal to the first two
columns in the other. The problem is that while the
cells in the first two columns shift to make room for the
added/subtracted name, the rest of the cells remain in
place, and the first and last name cells become
misalligned with the rest of their original row. How do
I fix my workbooks so that the rest of the row shifts
with the first and second cells?

This is a fine example of why spreadsheets make horrible databases. It can be
done, but it requires self-discipline and a desire to think and act like a piece
of database software.

In order to avoid misalignment between the two columns of names and the rest of
the employee data, you must delete ENTIRE rows, not just the names. If you do
that, you won't have misalignment problems. However, that requires *YOU* to make
sure you have entire rows selected when you delete employee information.

Are you using macros to do this or are you trying to do this manually?