Daily Net Sales - Ecommerce

afs1jes / Clarins-US-IR-Migration

0 stars 0 forks source link

Daily Net Sales - Ecommerce #68

Open AVHuntley opened 1 year ago

AVHuntley commented 1 year ago

Workbook contains external links, but they look like correctable mistakes:

=IF(OR(COUNTIF('C:\Users\CAROLE~1.SEZ\AppData\Local\Temp\A3M\rad3559E.tmp\[Net Sales - Ecommerce .xlsm]Maintenance'!$B$11:$B$13,TRIM($D12))>=1,D12=""),"hide","")

...should probably be: =IF(OR(COUNTIF('Maintenance'!$B$11:$B$13,TRIM($D12))>=1,D12=""),"hide","")

I made that change in a couple places. Model seems to build now.

afs1jes commented 1 year ago

Disabled VBA for OnSheetChange and removed Budget sheet.

Adjusted lookups on Summary sheet to reflect new indentation results on grids.