Find last row

K

KurtB

I am working with a data set that constantly changes length there are
more rows each week. I am writing a macro that inserts a new column
then combines the text from two columns into the new column but I only
want the equation in rows which already have data. If I paste into all
rows it won't sort properly.

For example original data:
Fname lname
John smith
Jane Smith
John Doe
Jane Doe

Modified data
Name fname lname
Johnsmith John Smith
JaneSmith Jane Smith
JohnDoe John Doe
JaneDoe Jane Doe


What macro lines do I need if I want to paste the equation in column
Name only if there is data in column Fname.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine multiple columns and rows for one record into one row. 2
Combining rows with duplicate names - sum numeric, concatenate str 0
vlookup using match and date range 1
how to move all info in column a to seperate columns 1
2 rows of information, need to move to 1 row 1
Reference a column to make groups 1
How to join row data into one row 1
Offset function with inconsisent data location 1

Top