Auto fill Log sheet from Negative values found on another sheet.

[MrKingisin]

The best way to describe this is that I'm trying to auto fill in a Weekly Planner with values from a customers list that has negative values found within the line of each client.

IE

If the comapny is ABC and has a value of last year of 20 and this year is 10 the company would have a -10 rating. on the front sheet I would want to auto extract that information of each cell with the information of company name, address and phone.

[mikeTRON]

Welcome to the forum.

You are much more likely to get useful help if you attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.