Split data input in to separate work sheets and create separate emails

[Annpan79]

Hi,


I'm hoping somebody can help me with this.


I have a workbook with 3 different worksheets. "60 days", "90 days" and "default". Each worksheet has the below columns;

<TABLE style="WIDTH: 561pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=746 border=0 x:str><COLGROUP><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1938" width=53><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" span=2 width=73><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH: 200pt; mso-width-source: userset; mso-width-alt: 9764" width=267><TBODY><TR style="HEIGHT: 53.25pt; mso-height-source: userset" height=71><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 40pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 53.25pt; BACKGROUND-COLOR: #ff6600" width=53 height=71> Client</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 76pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ff6600" width=101>User Profile</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ff6600" width=73>Status</TD><TD class=xl25 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ff6600" width=73>Creation
Date
CYYMMDD</TD><TD class=xl25 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 68pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ff6600" width=90>Previous
Signon
Date
CYYMMDD</TD><TD class=xl25 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 67pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ff6600" width=89>Last Used
Date
CYYMMDD</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 200pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ff6600" width=267>Description</TD></TR></TBODY></TABLE>

The data contained from those columns is brought in from a DB2 external data source and can range in number of rows. It is a basically a listing of user id details, sorted by client name.


What I'd like is for the command button to split out the rows corresponding to each individual client (based on a selection in a combo box), copy them into another worksheet. I'd like it to do the same thing across all three worksheets and send then one email with all three worksheets attached, to an email address determined by which ever client is selected.

Any help would be very gratefully recieved. I've created a button to email out the worksheet - but thats about it for my skills!


Thanks

Ann

 

[Annpan79]

Is anybody able to assist with this please?

Thanks

 

[Annpan79]

Is anybody able to assist with this please?

Thanks