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

R

Rikku

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).
 
D

Don Guillett

pick a column

lr=cells(rows.count,"a").end(xlup).row
rows(lr).copy to your destination
 
N

n_t_schultz

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
 
Top