We are seeking a skilled Excel expert to create a master sheet that consolidates data from three separate sheets. The final sheet will utilize formulas to provide accurate calculations and derive essential insights. The ideal candidate should have a solid understanding of Excel functions and data manipulation to ensure seamless integration and calculation.
I have had help previously to successfully create a similar report, but it has been many years, and the data has changed, so I would like to build a new sheet from scratch. Currently, we have a sheet where we select the 3 different reports and then click a generate report button, which brings you to the final report. This works well and can stay the same unless somebody has a better idea. There are 18 columns that need to pull data and do calculations. This is an example description of what I think would be the most complex formula that I need. “In stock/Total Available (column B) minus MOQ (Column F) if MOQ has data. If MOQ has no data, In stock/Total Available (column B) minus 60 days stock calc.off Last 3 removals. If both have no data, format cell text Purple and take In stock/Total Available (column B) and subtract ((Column G divided by 21) multiplied by 60)” Or maybe this “Find up to the 2 most recent Pos for the item in POByReceive report, Calculate how many day between the order dates and received dates and average those quantities if applicable”
I think it should be fairly easy for someone who is an expert with macros.
Thanks,
Andy
