Macro to add data to the bottom of a table

[LLAMA]

Hi All,

Hoping to get some assistance with this one, I've reached the limit of my Excel knowledge unfortunately

I have data on a sheet named "Audit Tool" in cells D3:H3 and I6:I8.

I have a table on a sheet named "Results". I would like to use a macro to paste the data from D3:H3 and I6:I8 in "Audit Tool" to columns A-H in the "Results" sheet. I would record a macro to do this, but I would like to paste the data into "Results" at the very bottom of the table (there is already data here and I don't want to overwrite)

E.g. If there is data present in "Results" in A10:H10, I would like the data from "Audit Tool" to start at A11:H11.

Thanks in advance

 

[James006]

Hi,

For a very clear explanation about Tables ... sorry List Objects .. take a look at the excellent site designed by Jan Karel Pieterse:

Excel: Working with Tables (VBA)

jkp-ads.com: Excel Tables (VBA)

jkp-ads.com

Hope this will help