Copy cell value based on multiple criteria

[cepinac]

Hi everyone, I've been trying to figure out this by myself but it's out of my reach.

Quick description:
Sheet "Sales" contains 3 columns:
Customer Name | Product | Qty
Workbook contains another 10 sheets with different customer names (same as "Sales" Customer Name).

Sheet "Customer XYZ" contains multiple colums but key one is Product (with matching name as sheet "Sales").

I would like to copy Qty of matching Customer and Product then paste it in an appropriately named sheet.

i.e.
Sales sheet:
Customer XYZ | Oranges | 10
copy 10 and paste it to a Specified colum (i.e. N) and a row containing Oranges in sheet Customer XYZ.

Thank you

 

[cepinac]

Thank you so much, got it

 

[cepinac]

There is not paste, you are making one cell equal another cell.

fRng.Offset(, 1)

For this example it's column B

fRng.Offset(, 2)

would be column C

Hi Dave, would you be willing to help me out on problem with ranges.
I would like to have VBA that subtracts three column ranges and outputs to the fourth one; all columns should be defined by the value in Cell A1.
Example:
Cell A1 defines the number of week (i.e. number value 1)

based on Cell A1 value VBA should subtract three columns and output to forth one i.e. A2:A - B2:B - C2:C = -> output to D2:D

when cell A1 is changed to number value 2 then the operation would look like this:
B2:B - C2:C - D2:D = -> output to E2:E

Thank you

 

[davesexcel]

You need to stat a new thread