Insert different cells into a table on one row.

[brent_milne]

I have asked different ways to do this but after many discussions with the user this needs to be done this way so I apologize if it looks like a duplicate post. I am looking for a macro to copy invoice #, date, name and totals for that name into a table on sheet 2. I have attached a sample of what it needs to look like and some comments on sheet 1 explaining a little better and what the user would like the table to look like. Not sure if this can be done but thanks for looking and trying.

[daffodil11]

Maybe something simple like:

Please Login or Register  to view this content.

It's a tad verbose though.

[PCI]

Try the file attached
Take care to format the Date column in sheet Table

[brent_milne]

Thanks for everything. PCI nailed exactly what I needed.