Hello, I have a big problem and was hoping for some direction. I have a workbook with 2 sheets one sheet (RAW) collects all the data. the other sheet (Audit) merges the data together. What I need to be able to do is anytime a value from my combo box is picked all the data is moved to this sheet (Audit). So in a nut shell here what happens in one case:Jan 09 was picked... raw data cells c,d,e,o,p,q,r,J,s,t,u,v14 pasted into Audit cells c,d,f,g,h,i,j,m,n,o,p,q15 also raw data cells KLMN,14 need sum and placed into r15 on audit sheet. and raw data cells FGHI,14 need sum and placed into k15 on audit sheet. So basically if someone could help me get started with this mess I may be able to continue with all the other case's I have. I'm just not sure how to get all the data from point A to point B. Thanks MiLLIONS... Mike

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

picking ranges of cells and pasting into another sheet

Thread starter realniceguy5000
Start date Mar 30, 2009

realniceguy5000

Board Regular

Mar 30, 2009

Hello, I have a big problem and was hoping for some direction.
I have a workbook with 2 sheets one sheet (RAW) collects all the data. the other sheet (Audit) merges the data together.

What I need to be able to do is anytime a value from my combo box is picked all the data is moved to this sheet (Audit).

So in a nut shell here what happens in one case:Jan 09 was picked...

raw data cells

Code:

c,d,e,o,p,q,r,J,s,t,u,v14

pasted into
Audit cells

Code:

c,d,f,g,h,i,j,m,n,o,p,q15

also raw data cells

Code:

KLMN,14

need sum and placed into

Code:

r15

on audit sheet.
and raw data cells

Code:

FGHI,14

need sum and placed into

Code:

k15

on audit sheet.

So basically if someone could help me get started with this mess I may be able to continue with all the other case's I have. I'm just not sure how to get all the data from point A to point B.

Thanks MiLLIONS... Mike