i have this code working perfectly:

Windows("whatever.xls").Activate
Sheets("sheet1").Select
Shipqty = Range("G23")
If Shipqty 1 Then ActiveSheet.Range("A23:Q23").Select
Selection.Copy
ActiveWindow.ActivateNext
ActiveWindow.WindowState = xlNormal
ActiveSheet.Range("A23:Q23").Select
ActiveSheet.Paste


bascially its check to see if something is in G23, if it is it copie
the row and paste it on another sheet i have created in the same spot.

heres my problem. it paste it in the same row and everything. i have
sheet with 334 rows of parts, and im condensing this on another sheet
cause we dont select all the parts each week. so basically if i have
row i need to copy in row 18 and row 300, i can have it pasted in 1
and 300. i need them in the first emtpy row. so can i have it paste i
the first empty row? also is there a way i can make this continue t
check every row for the next 334 rows for the same this and paste th
same way in the first empty row? cause i dont feel like writing thi
code 334 times. is there a loop i can do or something, im still novic
so i dont know all of excels potential with this kinda stuff. any hel
will be nice. thank

--
Message posted from http://www.ExcelForum.com