Excel Problem

by Spree • 27 May 2008, 07:25 • Journals
Yo, another question ^^

I have 3 sheets in excel, I'd like the program to copy the last 50 cells from one column from the first sheet, to the second, but there can be added latr to the first so it has to be dynamic.

HOW TO DO THIS?!

THX
Comments
7
▼
crabje 27 May 2008, 08:29
i only know some basic stuff from excel!

i love =som tho!
▼
LeFiZip 27 May 2008, 08:50
CTRL+shift+mouse1 imo
do 50 clicks :>
▼
Spree 27 May 2008, 08:56
doesnt work ^^
Parent
▼
Snorfiets 27 May 2008, 10:28
make screenhstoz and clcajs,and, and, cut thrnem jin parts a nd apste as pcitures
▼
flms 27 May 2008, 11:16
range(range("A1").End(xlToDown)-50, range("A1").End(xlToDown))

or s/t like this... only works for non empty cells though

vba just sucks though
▼
Spree 27 May 2008, 18:06
Sub laatste50()
Dim iRij As Integer
iRij = Range("A65536").End(xlUp).Row
Range("A" & iRij & ":A" & iRij - 49).Copy Worksheets(2).Range("A1")
End Sub
Parent
Back to top