OK, basically I've got a spread full of data, and I need the macro to do 2 different things:

1) The data is all in columns, and I need to copy and paste one row into a bunch of rows and one column. I.E. its horizontal, I need to make it vertical...this way it's more of a form for someone to fill out. So theoretically beside each row will be a button that calls a macro to format that one row.

2) After it's all pasted, I need it to bring up the send email function (as a sheet), and use one of the fields as the email address.

For step 1, I've pretty much got all of it, except that it only works for one line. Even if I make 100 buttons for all the rows, the macro will still call on just that first line. Is it possible to have the macro format only the row in which the button is? Or am I going to have to make 100 different macros, one for every button?

Step 2 I am almost good on as well, except I can only find how to send the email as an attachment, and I don't want the whole spread sent, just the 1 sheet.

[Edited on November 6, 2006 at 4:32 PM. Reason : c]

11/6/2006 4:31:11 PM

11/6/2006 5:28:21 PM

for problem 1, it sounds like you need additional input. Can you have the button read from a cell or from a drop-down list or something where you input the row that you want created?

for problem 2, you should probably use VBA to move the new worksheet into its own new, temporary workbook, save it, email it, then close and delete the temporary workbook.

11/6/2006 5:33:30 PM