Can a "what if" statement be used to insert cells?
 

I have side by side reports of thousands of lines of similar data. There may
be multiple lines pertaining to the same id#--one side may have 3
transactions for an id#, where the other may have 4, causing me to need to
bump the cells down on one side to keep matching id#s lined up side by side.
Can I use a helper column with a "what if" statement to insert cells? If so,
could you give me an example? Thanks in advance.

Can a "what if" statement be used to insert cells?
 

I got my answer in another post.

"A.R. Hunt" wrote:

I have side by side reports of thousands of lines of similar data. There may
be multiple lines pertaining to the same id#--one side may have 3
transactions for an id#, where the other may have 4, causing me to need to
bump the cells down on one side to keep matching id#s lined up side by side.
Can I use a helper column with a "what if" statement to insert cells? If so,
could you give me an example? Thanks in advance.

Can a "what if" statement be used to insert cells?
 

Example? Give us an example of your data layout.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"A.R. Hunt" wrote in message
...
I have side by side reports of thousands of lines of similar data. There
may
be multiple lines pertaining to the same id#--one side may have 3
transactions for an id#, where the other may have 4, causing me to need to
bump the cells down on one side to keep matching id#s lined up side by
side.
Can I use a helper column with a "what if" statement to insert cells? If
so,
could you give me an example? Thanks in advance.

Can a "what if" statement be used to insert cells?
 

Columns:
A:Name
B:Term
C:Amount
D:Hours
E:SSN

I:SSN
J:Last Name
K:First Name
L:Term abbreviation
M:Amount
N:Hours

Columns F, G, H return the differences in SSN, amounts, and hours. They are
conditionally formatted so that if the they are not zero, they are red. If
the SSN is not zero, I must insert cells so that matching SSNs are side by
side. For any SSNs that aren't on both sides, I must research why not. Also,
if hours and amounts are different, I must research what caused the
difference.

"Don Guillett" wrote:


Example? Give us an example of your data layout.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"A.R. Hunt" wrote in message
...
I have side by side reports of thousands of lines of similar data. There
may
be multiple lines pertaining to the same id#--one side may have 3
transactions for an id#, where the other may have 4, causing me to need to
bump the cells down on one side to keep matching id#s lined up side by
side.
Can I use a helper column with a "what if" statement to insert cells? If
so,
could you give me an example? Thanks in advance.