Userform Button to Add Data to an Existing Table

[abysva]

I'm creating a userform that needs to update to an existing excel tabel named "CFSData"<BR><BR>I have a submit button (cmdSubmit) that I currently have the following vba for:

Please Login or Register  to view this content.

I found that this can only add data to the worksheet (named: "data") which contains the table (CFSData) I would actually like the data to go into .. I need the data to be inserted into the table instead of adding additional rows outside of it...

[waffffi]

Very nice work .. Great userform

[Md Aejaz]

There are some extra rows below that table .
remove those rows it will work as u need.

[Md Aejaz]

There are some extra rows below that table .
remove those rows it will work as u need.

[abysva]

@Waffffi .. Thank you!

Very nice work .. Great userform

[abysva]

@Md Aejaz, Ok, thank you ... will delete and attempt again ...

There are some extra rows below that table .
remove those rows it will work as u need.

[abysva]

@Md Aejaz, so simple and It worked perfect! I was pulling my hair out, Thank you again!