transfering data from one sheet to another

[dre2112]

I have a little excel sheet which I use to track ebay and other online sales. Recently I decided to change things up to something what I think is a simpler format of columns and rows to calculate costs/expenses and profits. I've got about different 300 items so manually entering descriptions and sale prices is going to be tedious... in fact, It took me 3hrs to do only for me to exit excel without saving... yup, all thous hours gone down the drain!

Anyways, here's what I'm talking about in the pic below:

I'd like to know if it's somehow possible to transfer the data in certain rows/columns from one sheet/page to another sheet/page in a giant batch. The pic should explain it better. I'd like to do that, for 300 different items.

Any help is appreciated!

Here's the image for reference:

http://i617.photobucket.com/albums/t.../excelhelp.jpg

[6StringJazzer]

Welcome to the Forum!

First, please please please don't bother to make screenshots and attach those when you could more easily just attach the workbook.

Here is a workbook with the formulas you need. You will have to provide your own to calculate totals and profit. You did not show arrows for those so I assume you expect to calculate them in place.