Copying specific cells from worksheet to activesheet

Thanks StephenR. I tested. Nothing happens. Probably not explaining clearly enough. I'll try again. Value on Sheet2("order") from G5 needs to go to the active sheet, col 1, first unused row. Etc from there. I may be way off course in what I wrote, too. I am struggling to grasp VB.

I think best if you mock up and attach a sample workbook.

Thank you for working on this. Attached is an example workbook. The first sheet called "order" is where users type in information. (That sheet will always be there and always named "order".) Then they can select from one of many worksheets to "export" the info they typed to the selected worksheet. That worksheet is one of many so I can't "hard" code to it. The "export" will have to go to "activesheet". Here, the selected worksheet is called "example". The info from "order" goes to the columns on the "example" worksheet - name to name, address to address or G5 to column 1, G6 to column 2, etc. Thanks again to any and all that help. I appreciate it.Mockorder2.xls

It may just be that you need the +1 on the end here. Certainly, I tried it and something was copied over so it did something. Without the +1 it just overwrites the last entry each time.

Please Login or Register  to view this content.

That's much better!! Thank you, thank you. I truly appreciate your persistance.