Paste non-identical data from one book into another

[jchambers00]

Im sure there has to be a way to do this quickly either using some function (sumproduct) or a macro. Heres the situation
*receive monthly data report (see simplified attachment) with data broken into sections and values for each attribute running vertically
*need to paste into yearly report (see simplified attachment2).
*Yearly report has additional columns (rate; calculated) interpolated between the common columns
*need to paste monthly stats appropriately while also performing calculations: rate is calculated from associated click value / total; and Total is sum of all click values in row.
Any suggestions are welcome.
thanks
monthly.jpg

yearly.jpg

[Caligula]

Hi,

There are a few ways this can be done. But I have some questions first. First, are these going to be separate workbooks or only separate sheets? If they're all in the same workbook, it'd be easy to simply create a formula to link to the corresponding cell on the other sheet (you can do it even if they're in separate workbooks). Do you need help setting up the mathematical formulas also, or only getting the data to the yearly sheet? Third, are all the months set up on the yearly sheet or do you need the macro to insert a line when a new month is imported/pasted?

When posting what you've worked on so far, it would be appreciated if you post the actual Excel files, instead of a jpg. With that, we'll have a better idea of what you're trying to accomplish.

Thanks,
Chris

[jchambers00]

Q: First, are these going to be separate workbooks or only separate sheets?
A: Seperate workbooks

Q: Do you need help setting up the mathematical formulas also, or only getting the data to the yearly sheet?
Only need help getting the data to the yearly sheet. I see two approaches; either figuring out a way to copy the values while skipping the rate column all together (so as not to overwrite the preexisting formulas to calculate rate with a null value). Or code the formulas within the macro so as to paste the value, paste formula, paste value, paste formula, paste value, etc, etc.

A: Third, are all the months set up on the yearly sheet or do you need the macro to insert a line when a new month is imported/pasted?
New line needs to be inserted with each new paste

[jchambers00]

Q: First, are these going to be separate workbooks or only separate sheets?
A: Seperate workbooks

Q: Do you need help setting up the mathematical formulas also, or only getting the data to the yearly sheet?
Only need help getting the data to the yearly sheet. I see two approaches; either figuring out a way to copy the values while skipping the rate column all together (so as not to overwrite the preexisting formulas to calculate rate with a null value). Or code the formulas within the macro so as to paste the value, paste formula, paste value, paste formula, paste value, etc, etc.

Q: Third, are all the months set up on the yearly sheet or do you need the macro to insert a line when a new month is imported/pasted?
A: New line needs to be inserted with each new paste