Copying specific Excel data to another based on criteria

[taklong]

Hi,

I am completely oblivious with the logic behind the macro scheduler and would really appreciate the help I can get.

I have an excel workbook full of customer details + orders.

The 2 workbooks look like this;

First workbook

On each row (1,2,3,4,5 etc.) there are full of data from EACH customer with information such as;

(Column A = Name of customer)
(Column B = Contact number)
(Column C = Leafy Greens Request)
(Column D = Fruits Request)

Second workbook

(Column A1,2,3,4,5,6 etc. = All the vegetable / Fruit names)
(Column B5,C5,D5,E5,F5 etc. = Customer name, thus, each column = all customers details of order)
(Column B4,C4,D4,E4,F4 etc. = either B or S, which stands for Big or Small box)
(Column B7,8,9,10,11 - Y7,8,9,10 = Values of requested vegetables/fruits volume from each customer)


1) So based on what the customers want from the data in Workbook 1, I'd like to automise for example;

From the first sheet with order details, if customer "Ben Clark" ... has "Orange" under "Column D" ... confirm that and write in to the OTHER Excel workbook either 900 grams or 450 grams in the specific cell for that customer and orange (maybe the location for that Customer and Orange is B1,B9) based on if the customer has a BIG or SMALL box.

But the total accumulated amount of GRAMS in that column (customer) may not exceed either 7500 grams or 4500 grams based on Big or Small box respectively.

So I would like to run this across all customers and confirm through all vegetables/fruits if I should place any value on the SECOND worksheet if the FIRST worksheet has a request for it.

Right now, I am doing this manually and have been doing it for a quite a while and it takes 3 days to do this; very labour intensive (since customer orders are continuously coming in so I need to update it each time).

Would anyone be able to help me out on this issue? Would REALLY appreciate the help if anyone could since I am not that experienced with scripting/programming, and this is very tiring.

Thank you !

[Marcus Tettmar]

Realistically I think we're going to need to see your spreadsheets to help. Without that we can only really tell you to look at the samples, look at the native Excel fuctions and the articles and tutorials on this site.

But if you are looking for a solution, or at least part of it, then we will need a copy of your Excel files. Feel free to send to support.