Inventory Add-On

[CENAK]

I've looked around here but couldn't find what I was looking for.

I have a client who does inventory audits. He gets an inventory list in Excel the night before his count from the warehouse manager. These lists are formatted in all kinds of crazy ways so that night we reformat the list manually, add filters and sorting functions. We also select the items that need to be counted (app. 80% of the total value) and sort by It's a pain in the neck as every warehouse manager sends it in a different format, and it is not feasible to make them use one we send them.

I looked at Tableau but it is a bit expensive and was wondering if there is an add-on I could buy that cleans up these lists and let's me sort them etc? We also add columns to calculate the actual value and difference to the information we received the night before (variance).

Thanks in advance for any tips.

 

[sandy666]

try Power Query aka Get&Transform
XL2010/2013 add-in (free from MS site)
all above - built in

for more info

Power Query documentation - Power Query

Power Query is used to filter, combine, and mash up data from one or more supported data sources.

docs.microsoft.com

 

[sandy666]

also you can try PowerBI Desktop (free) but this is not my favourite software

 

[Logit]

Or depending on the format they send you ... you can try Text To Columns which is an Excel built in on the DATA TAB.