Possibly bitten off more that i can chew

[Luke1690]

I want to know before I start a project, is it possible to fill in a second spreadsheet automatically from data in a single row from the main sheet.

Then with a single click from main sheet send that second sheet as an attachment on email from outlook. (I know that is possible using macros)

The bit I want to know is can I then delete the data from the second sheet by entering new data in row two on the main sheet. Then send that as an attachment automatically with the new data. So on and so fourth each new data typed in a new row on the main sheet overwrites the old data in the sheet 2 and is ready to send as a attachment?

Thanks in advance I will keep popping back on a checking answers and will give more details if you need.

 

[Logit]

Yes, what you describe is possible.

 

[Luke1690]

Thanks I'm teaching my self by watching you tube videos. I just haven't seen anything on the overwrite problem. What sort of code would I need or solution. Don't worry I don't want a full blown explanation, if you could point me In the right direction would be appreciated. Thank you

 

[Logit]

Option Explicit

Sub CpyPste()
    Sheet1.Range("A2").EntireRow.Copy Destination:=Sheet2.Range("A2")
    Sheet2.Columns("A:f").EntireColumn.AutoFit
End Sub

 

[Luke1690]

Thank you.