hey guys,
sorry for dragging out such an old post but im trying to do pretty much the same thing as this: http://www.excelforum.com/excel-prog...xcept-one.html
the only difference is i need to copy an undefined range in the other sheets and paste them in the next available space in sheet1 (the data sheet as referred to above)
the range in the other sheets will always start at A2 and is always the same format. i need to copy from A2 to the last row in G with data and paste it in the next row in sheet 1
this is what i came up with but its not working. it doesnt have an error, it just doesnt do anything (except delete the other sheets)
Please Login or Register to view this content.
Bookmarks