Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Is there a better way for my data relation?

0

I keep track of inventory in excel and a singel sheet of metal has 4 different attributes that make the sheet unique to track its quantity.  I made this relationship hoping to build an automated method to add/subtract sheets but I'm not sure if this is the way to set this up.  Just looking for opinions/thoughts.

Answer
Discuss

Discussion

Hi Jonathon

Please edit your question to explain what you mean by "add/subtract sheets". I assume you mean new, unique types of metal sheet, not Excel worksheets and guess you don't have all possibilities covered alread (since that would give unwanted results from your Order button/ LowInventory macro).

Your filtering of Sheet2 seems okay so are you thinking to add/ subtract types by selecting a filtered line and choosing delete or add similar perhaps?
John_Ru (rep: 6102) Mar 18, '22 at 9:55 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login