Inventory Management Template in Excel VBA | Free Download

[@spreadsheet_power]

Friends, the template will be downloaded in compressed folder. First, you need to unzip (extract) the folder before using this template.

[@TanveerAhmed-hv4gn]

AOA SIR I AM TRY TO OPEN AFTER (EXTRACT ) UNZIP BUTT STILL DIDN'T OPEN . ALSO FOLLOW VIDEO YOU HAVE ON IT,

[@spreadsheet_power]

It should open, what message are you getting?

[@raviprasad5907]

Password bro

[@abelardoiv]

password= unlock_im is not working. can you please give us the correct password tnks

[@spreadsheet_power]

To use this template, no password is required. Password is for vba project. It is protected to avoid unwanted change in code. If any change happens in the code, problems may arise.

[@wellingtonyandikani9062]

Thank you very much, this is much needed and it came at the right time

[@chukwuemekaokolie8320]

please were you able to download the free template? bcos the link is not working for me

[@HidalgoInvestments]

Thank you for this good work. I entered the right date range and clicked refresh but still the list box shows nothing

[@jfslim25]

Hello. After creating my items and doing stock in for them, I dont get any stock in/out information on the bottom table.. Even if I change the date, nothing shows up there. Can you help please?

[@spreadsheet_power]

After changing the date, did you pressed refresh button?

[@himanshusharma-life]

AFTER PRESSING "SAVE WB" BUTTON ? HOW CAN I DELETE ALL THE ITEMS IN "SHOW DETAILS" SECTION ?????

[@PRINCELYAKO-su2km]

Please does this contain any licenses to be purchased after a while because i don't get it

[@spreadsheet_power]

It does not have any license, free to use.

[@mohammadyounas5495]

Hi Dear Sir. i downloaded but now showing Spreadsheet Power stamp is it possible to remove ?

[@spreadsheet_power]

Please write a mail to [e-mail] for template with no stamp

[@JoshuaMakewa]

Hi. Thank you for this great work on this application. I entered the right date range and clicked refresh but still the list box shows nothing. I have changed the dates as directed in the video and previous comments. Please guide

[@spreadsheet_power]

After selecting date range and refresh, it should show the transaction. It works perfectly in my computer. I even tried it in another pc with old Excel versions too. If it still doesn't work, please give me your anydesk id. I will see what has happened.

[@rajeshputhonveedu1201]

If the PPPU is varying from time to time, does this template do an averaging costing ?

[@spreadsheet_power]

No, it does not consider average cost. If price changes too frequently, this template is not appropriate. For occasional price change, you have to enter the product twice or thrice in item master by differentiating it MRP wise For example Television (MRP1) Television (MRP2) Something like that

[@BryanScott-t1y]

Sir, I encountered a similar issue. Despite entering the correct date range, the listbox did not populate as expected. Additionally, when I double-click the listbox, I receive an error. The error points to the line: Me.Tb_id1.Value = Me.ListBox2.List(Me.ListBox2.ListIndex, 0). Could we kindly request an updated version of the file? It’s possible that the file might have been altered before uploading.

[@spreadsheet_power]

I have uploaded updated file, please download and test whether it works. and also let me know.

[@wellingtonyandikani9062]

Encountering this error message when i try to insert my PPPU like $.50 it shows the message (please recheck purchase price) how can i add these small figures? please advise

[@spreadsheet_power]

It is because this field is validated for numbers only, do not input $ symbol there

[@wellingtonyandikani9062]

@@spreadsheet_power even if i put it this way eg; 0.50 its not working it is showing the same error message, and this template is what i was looking for a long time but am faced with that issue only please can you look into it

[@HidalgoInvestments]

Thank you for this good application. I entered the right date range and clicked refresh but still the list box shows nothing

[@spreadsheet_power]

the downloaded template is blank one. First of all, you need to add some items. add some transactions. then it will start showing.

[@HidalgoInvestments]

@@spreadsheet_power I entered items in item master, added some transactions but still the list box did not work

[@HidalgoInvestments]

@@spreadsheet_power I added items and transactions. I also entered correct date range and refreshed but list box does not populate

[@Luqman.777]

If any data is entered incorrectly by mistake, how can it be deleted?I have made an entry whose value has also reached the total value, but it is wrong, how should I delete it?When I update my total value gets affected

[@spreadsheet_power]

You can replace the mistake transaction with a new transaction using the update button, If it still doesn't work, please share your excel workbook to [e-mail] We will add the delete button and send back to you.

[@amirjoyia2858]

In the transaction form which is a combo list box He is not searchable, can he be searchable?

[@amirjoyia2858]

If possible send me the VBA code

[@spreadsheet_power]

Combobox is searchable, for example, to find television, type "tel" It highlights ans shows shows television

[@reypangilan7157]

hi how do you delete records in product items?

[@spreadsheet_power]

Delete option is not available, but you can update an item.

[@GeorgeMcCoy-u1i]

HAVING TROUBLE I DONT GET A POP UP TO ENABLE EDITING PLEASE HELP

[@spreadsheet_power]

Pop up to enable editing means? Could you please explain further?

[@meedeng]

date selection can not choose date,it show runtime error ' 380 ' how can i solve this problem

[@spreadsheet_power]

Please share your working file to [e-mail] Will check for the issue and revert

[@PaulYT-25]

Hi Sir, transaction list box is not showing any results. Can you send me the link where I can download the latest file. Thanks

[@spreadsheet_power]

One of the reason not getting transactions in list box is because of improper date range selection. If transactions is on back date, need to select back date in from and to date. File download link will appear at video end screen

[@kavumaraymond8251]

Thank you for this good application. I entered the right date range and clicked refresh but still the list box shows nothing

[@aminuddinazmi6028]

@@kavumaraymond8251 i've also experienced the same,

[@padisiva]

Really its amazing tool bro

[@spreadsheet_power]

Thank you 🙏

[@PRINCELYAKO-su2km]

Greetings sir, i downloaded it but got something different

[@spreadsheet_power]

Could you please explain more ?

[@davidm8046]

I'm having issues opening this on a Mac.

[@spreadsheet_power]

Please check if this method works kzbin.info/www/bejne/pGq8ZYhtlLCraMk

[@ilayaraja9169]

Sir, project password??

[@spreadsheet_power]

unlock_im

[@ilayaraja9169]

Thank u sir, can we add items directly to the sheet , instead of product master userform ... B caz I have more than 500 items in my book shop

[@spreadsheet_power]

@ilayaraja9169 this cant be done in this particular template, however this is possible by editing the code.

[@muzamal353]

Good 👍

[@spreadsheet_power]

🙏

[@spreadsheet_power]

🙏

[@femiezekiel3622]

Hi, the link is not working

[@spreadsheet_power]

Really? What error message you got?

[@JaylordDoctor]

add client and remarks thank you...

[@chukwuemekaokolie8320]

The link is not working Sir

[@spreadsheet_power]

What does it say when you try to download?

[@abelardoiv]

password= unlock_im is not working. can you please give us the correct password tnks

[@jaypoysabellano8353]

sir can i have vbapassword??

[@paulagpeffer5142]

this is just what I need - but cannot download

[@spreadsheet_power]

What error you got? Please write a mail to [e-mail] We will send the template there.

[@renanbenedicto1378]

Please can i know the VB password

[@spreadsheet_power]

unlock_im

[@linthushein291]

VBA password plz unlock_im is not working

[@ilayaraja9169]

Sir, please give Password for code

[@ishantverma7805]

SIR PLZ SEND ME PASSWORD

[@spreadsheet_power]

To use this template, no password is required. Password is for vba project. It is protected to avoid unwanted change in code.

[@ishantverma7805]

@spreadsheet_power change for out product price

[@rathpros8463]

VB password 🔑 please

[@BryanScott-t1y]

Sir, I encountered a similar issue. Despite entering the correct date range, the listbox did not populate as expected. Additionally, when I double-click the listbox, I receive an error. The error points to the line: Me.Tb_id1.Value = Me.ListBox2.List(Me.ListBox2.ListIndex, 0). Could we kindly request an updated version of the file? It’s possible that the file might have been altered before uploading.

[@spreadsheet_power]

I have uploaded update file. Please download and test whether it works or not. And also let me know.

[@BryanScott-t1y]

@@spreadsheet_power listbox still did not populate sir.