←Back to all posts
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to automate updated SKU code in spreadsheet

I have a spreadsheet that has a list of sku codes for products across multiple sheets. The sku codes that are on the sheets that I have currently are “in house” (basically a place holder) sku because we use these templates for multiple vendors.

We have a vendor that provided an excel catalogue of sku that are specific to their company. Basically I need a way to link my sheets with their information. So if my sku for drywall is 1234 currently but the sku they use is 4567 I need my sheet to update any sku that is 1234 to 4567.

The one master catalogue of skus will be spread across tens of spreadsheets. Master catalogue is every material used in home building vs my sheets are broken up by category. Does anyone know what tools is can use to accomplish this?

submitted by /u/CJ_4654
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#google sheets
#generative AI for data analysis
#collaborative spreadsheet tools
#Excel compatibility
#financial modeling with spreadsheets
#no-code spreadsheet solutions
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#rows.com
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#big data management in spreadsheets
#self-service analytics tools
#AI-native spreadsheets
#business intelligence tools