pulling data from one sheet to another in a workdata which can be refreshed in excel.

[krisuk]

Hi
I used microsoft query to pull data but unfornatunately the data is in multiply tables so I now want to join the table in order for the data to make sense.
Please see the attached excel workbook.
Thanks for your help in advance

[dilipandey]

Hi Krisuk,

welcome to the forum.

In sheet "aim to achieve this", how you will get values in column G:M.
I got that column C:F, you can get from sheet2


Regards,
DILIPandey
<click on below * if this helps>

[krisuk]

Hi DILIPandey,
G:M was picked from E:J in sheet 1.
Hope this helps you to understand it better.
Thanks

krisuk

[dilipandey]

Hi Krisuk,

Is there any common field (column) between sheet 1 and sheet 2 as this may help in getting information from both the sheets ?
Also, can you manually put in two rows of data basis these two sheets as a sample ? Thanks.


Regards,
DILIPandey
<click on below * if this helps>

[dilipandey]

I found "DocumentNo" field in sheet2 and I am thinking if this field is there is sheet 1 as well, then we can easily extract complete row. Thanks.




Regards,
DILIPandey
<click on below * if this helps>

[krisuk]

The common field is POPOrderReturnID.

[dilipandey]

sheet1's K2:K5 has same ID.. so which row you need here ? Thanks.


Regards,
DILIPandey
<click on below * if this helps>

[krisuk]

yes K2:K5 has the same ID and the line Total Value for them adds up to 492 see F2:F5 in sheet 1 and this is shown in sheet 2 document no 0000010122 in C2 total gross value of P2 sheet 2.

[krisuk]

I need all the rows

[dilipandey]

Okay.. so I manually updated all rows information from sheet1. Now how you would fill the grey cells from sheet2?

Book2.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[krisuk]

I am a bit confused.
I don't won't to manually fill the data.I am looking for excel formula which can do that for me.
At least if a formula could be used to pull the document no column unto sheet 1 and link with the right data that will be great.
regards
krisuk

[dilipandey]

I don't won't to manually fill the data.I am looking for excel formula which can do that for me.

I know this.. and just wanted to be sure what would be the final result look like after applying formulas and this is what I was expecting from you where you could have said "I have entered results manually and looking for formulas which can output same results" - hope you got the message


Regards,
DILIPandey
<click on below * if this helps>

[krisuk]

I have manually completed it now.
Thanks

[krisuk]

Please find the completed file.
Thanks

[dilipandey]

Hi Krisuk,

In sheet "aim to achieve this", paste the data in green cells from sheet 1 and drag down formulas in rest of the columns. thanks.
Book2(2).xlsx


Regards,
DILIPandey
<click on below * if this helps>

[krisuk]

Thank you Dilipandey.
I will check this work life data tomorrow and let you know if it works ok.
Thanks you for your wonderful job done.

Regards

Krisuk

[dilipandey]

Okay... awaiting your reply



Regards,
DILIPandey
<click on below * if this helps>