Hello gurus,

Can somebody show me how to create a macro/script that would insert a
row in a worksheet (Sheet1) and then copy the top row of another
worksheet (Sheet2) into the inserted row? The copying needs to
triggered manually.

We have a 4 copy pre-printed form that we use a dot matrix to print to
it and I made an Excel template where the clerk can enter the data and
then just hit print. I am trying to capture the data that the clerk
types in and create a database so we'll a searchable computer record.

If inserting the data in a row is not possible, how about exporting a
row and appending it on a text file?

Thanks in advance.


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=386957