copy cells from one excel spreadsheet to another

**Mickmac** · 05-13-2011, 10:12 PM

Hi,

I tried to find the answer to this on the forum but could not find it.
I have to make a series of invoices in excel 2007, and then I have to make a master invoice.
Is it possible to copy the cells in one spread sheet and then paste them into the master spreadsheet ?
It will save me a lot of time, otherwise I have to re-enter all the data again into the master invoice.
Thanks, Mickmac

**jeffreybrown** · 05-13-2011, 10:15 PM

Hi Mickmac,

How do you want to copy these cells, in other words, what triggers the copying?

**Mickmac** · 05-13-2011, 10:25 PM

Not sure what you mean, Jeff. I just want to create an invoice and transfer all the data to another invoice.
I have to make an invoice for each individual supplier, then when I send the shipment I have to make a master invoice which lists all the products in the shipment. It is to keep the Customs people happy.
Thanks, Mickmac

**jeffreybrown** · 05-13-2011, 10:59 PM

It's hard for me to see what you need without any data about what information, what cells, etc.

Can you post a sample workbook describing what you have and what you need?