looking for vba solution for inventory sheet

Hello Cath867,

Welcome to the Forum.

Please attach a sample workbook. Make sure there is just enough data to demonstrate your need.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

Hi Cath867,

it's very simple what I need, column A and I to copy to Sheet2 if I is greater than zero...

Nothing is always as simple as it may be considered, if you don't know how to do it.

You have Inventory Items without a Part Number, and those will be ignored by default, and filtered out.

Sorry Cath867, but your Workbook shows nothing in "I" in any Sheet.
However, I did not allow my frustration to get the best of me.

Paste this Code in a Standard Module;

Please Login or Register  to view this content.

The attached sample Workbook demonstrates further how you could fine tune the Workbook with inter-Alia some buttons. You may change the Sheets and Ranges to suit your actual project.

Regards.

Hello Cath867,

.. I would be more than happy to contribute to something if there is anyway to give back! just let me know.

Since you are so kind I shall settle for a miserable $1000.00 only.LOL

Thank you for the feedback, glad I could help, and thank you for the "Rep" tap as well!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.

I'll have a quick look. Sorry, was busy with some other Threads.

Got it! What a funny quirk.

Please remove this line from the Code in the Workbook.

Please Login or Register  to view this content.

Regards.

You are more than welcome.

Now Buzz Off and stop bothering me!

Just kidding, good luck with your project further on!

Kind Regards.

Are you Cath867 or Chicken?

Fight back! LOL

What a nice surprise to hear from you sintek,

It has been a while!

Thank you for the nice comment, ek waardeer dit opreg.

Vir so bietjie pret gara ek van die Forum Lede.

Groete.

@ Logit,

I was not born a fighter, you and your miserable attitude turned me into one. I hate it when people fight with me when I am rude to them!

If you can't take the heat, do me a favor and turn your peace maker into "Making some paces". Now stop bugging me and Buzz Off!

BTW regarding your PM, calling me a thief, BITE ME!

Nice to hear from you as well my friend. FDibbins once replied to one of my "Nasty" comments with "Take in some faith bud, like honest Government" LOL
That really cracked me up!

I absolutely love the flack you guys throw me way! Keep it up.

Kind Regards.

Thank you for the kind words Cath867, It is appreciated!

@ Logit,

There goes his ego !

If that's how you feel, enjoy the trip my Alter ego!

Warning: leave Cath867 alone!

Hi Cath867,

Just in case you are interested, here is another more complete sample of what you could do with the Workbook.

Regards.

Hello Cath867,

Glad you like it!

Kind Regards.

I now see why Winon has so many posts... never stops talking it seems! LOL

Nice work as usual my friend!

Hello Jpp887,

Welcome to the Forum!

Your request would require some intricate changes.

Considering

Would it be possible to add a sheet to the workbook that would list the part number, description, and a running total of how many times that item has been ordered. So that it can be reviewed from time to time to determine how many times we order that item every quarter. This would help reduce inventory on hand and overhead costs.

Please use my sample Workbook and add your required changes, then attach it as a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

@Logit,

You are creating a monster !

Don't worry my Friend, I shall never steep down to your monstrous level.

@Logit,

I appreciate you all the same, shortcomings or not.

Thank you Jpp887,

Please leave it with me for a while, to allow Logit to wave his magic wand!

If not, I shall respond promptly.

Kind Regards.

Hello Jpp887,

With a few adjustments to the Code, the attached might serve as a start for your requirement.

Please don't share it with Mr Logit, as I am not in the mood for his tantrums. I mean, come on, how looong does he need for this simple adjustment?

Your feedback will be appreciated!

Kind Regards.

Hello Jpp887,

I really don't appreciate you ignoring my request, quote;

Please don't share it with Mr Logit...

end quote.

As I have predicted I am now stuck with his typical tantrums.

Since, Mr Logit is so clever, and you are so stubborn, I have no other option than to withdraw my help, and leave it in the incapable ability of his Lordship Logit!

Now BUZZ OFF, both the three of you, and let me be!!!

Hi Jpp887,

And there you go!

His honorable Logit contributed to your Thread.

I am at a lost as how and where you would apply his "valuable" contribution, so I shall leave it to you to sort out that one, since I am stumped by his brilliance!.

Hello Jpp887,

Thank you for adding to my Reputation, and good sense of humor, I really appreciate it!

@ Logit, Please note that I am talking to Jpp887 and not to you, back there in the peanut gallery.

Best Regards Guys.