Copying a multiple cell values from one worksheet to another

[jrg123]

I have a 2 columns on a spreadsheet that are populated from another spreadsheet. I have attached a sample below as book1. I want pull each column d value and corresponding column G value into another worksheet. Example: Column D has two lines for laborers and column G has two values 2 and 6 corresponding to the two laborers rows. I would like the second spread sheet to combine the two lines in Column D and add the 2 values in column g into one row. Is there a way I might be able to do this. Thanks.

[dilipandey]

Hi Jrg123,

You can use a sumif function here ;-

=SUMIF(Sheet1!D:D,Sheet2!A1,Sheet1!G:G)


see attached .. green cell in sheet 2.

Book1(20).xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[jrg123]

Thanks dilipandey, but I also need to populate column a on sheet 2 with the values from column d on sheet 1. Not sure how to make this happen.

[dilipandey]

Hi jrg123,

See the pivot in column D .. whenever there is any addition or deletion of data, just right click on pivot and choose refresh..

Book1(20).xlsx
Regards,
DILIPandey

<click on below 'star' if this helps>