Copying rows in EXCEL

[Handcopy]

Hello, I am using EB to send an email that gets information from excel. For example, i need to send an email that contains every row that has been marked by initials in another column. I want to be able to take only those rows and email them. That would work, or if not i was wondering if i could just send that one sheet.

Thank you in advanced.

 

[SkipVought]

Hi,

Try using the Excel AutoFilter on the marked columns & copy the CurrentRegion. Just a few statements. No loop.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]