S
Steve
I am having a similar problem, however my difference is
that I want my destination to be in rows.
Example:
Sheet 1 has two columns:
1. First Name
2. Last Name
I would like to concatenate the two names and place them
in rows. My problem is, when I drag the formula over, it
does not increment the row numbers from the first sheet.
Any ideas where I can work around this or will I have to
continue editing my formulas manually?
Thanks!
Steve
that I want my destination to be in rows.
Example:
Sheet 1 has two columns:
1. First Name
2. Last Name
I would like to concatenate the two names and place them
in rows. My problem is, when I drag the formula over, it
does not increment the row numbers from the first sheet.
Any ideas where I can work around this or will I have to
continue editing my formulas manually?
Thanks!
Steve