Autofill Data

[nits1982]

I want a formula that can autofill data in SUN (sheet1) from in (sheet2) and shipped (sheet3).

and data should be come as per enclosed sheet

[Bob Taylor]

Looks like you could use the SUMIFS function, but you will need to make sure that your SUN column A exactly matches the labels in your IN column E.

[nits1982]

can you replace and try out the formula

[samba_ravi]

Data you entered in Column C of Sun Sheet is not matching with Actual Data in IN Sheet

[samba_ravi]

In which column of In sheet we will look for date and for SunBeam

[nits1982]

Column I and 2R/3R/4R is product type for which sum of date wise qty required.

[sktneer]

Try this.....

On the Sun Sheet,
In C4

Please Login or Register  to view this content.

and then copy across and down to row 14.

Is this what you are trying to achieve?

PS. As per your previous post there is no reference for col. I (Receipt) on the Sun Sheet.

[newdoverman]

As I understand your problem, you want quantities IN and out for both dates and skids. I found that the sample results just don't match the data in the IN and OUT worksheets.

Enter these formulae in C4 and C16 and copy down and across as appropriate.

IN:

Please Login or Register  to view this content.

SHIP:

Please Login or Register  to view this content.

[nits1982]

Actually i want sum of skid quantities for different receipt location as per date of receipt.

[newdoverman]

Isn't that what I have given you in message #8?

[newdoverman]

This is based on dates of receipt both IN and SHIP