Want to choose last filled line, but dont know how?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I choose last filled row and copy it to other worksheet?

People are filling excel sheet and the latest data should be copied to
summary sheet (all can be in same workbook).
 
pick a column

lr=cells(rows.count,"a").end(xlup).row
rows(lr).copy to your destination
 
Do you know how can I take data from one cell and put into another.
Example:

Column 1 first Name Column 2 Last Name Column 3 username
John Doe autopopluate
value JDoe


basically I wan the first letter of column one, all of column two to be
feed into column three automaticlly.


Thanks,
Nate
 
Assuming source data in A1 and B1
In C1: =LEFT(A1,1)&B1
Copy down as required
 
You must log in or register to reply here.

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

Series fill only copying and fill series greyed out 1
auto fill certain data from sheet1 to sheet 2 2
Excel 2007 - Linking workbooks 1
HELP!!!!! 1
Excel Cannot delete empty cells/rows 4
Linking Worksheets to a Summary Worksheet 1
Multiple column search and Copy 7
Skip Rows in Fill Series and Filter to Two different sheets 3

Back
Top