Hi everyone.
I am new to excel and have been attempting to learn it myself.
'
I have Invoice in Sheet1
and I have stock in Sheet2 where i record my stock
I was looking for something where I could link my invoice and stock sheet. So when i enter the product code and quantity in invoice sheet then it automatically reduces from the stock sheet.
Anyone who could help me please?
I am stuck in this since long. Please help
Before anyone is able to offer any help on this issue, you will need to upload a sample workbook that contains a sample invoice and stock report. Without at least this information, we would have no way of knowing what your workbook looks like. We may be pretty good at excel but we are really terrible at mind reading.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Sir.
Thank You.
I am unable to upload any attachment. SO please refer to the google drive link below:
https://drive.google.com/open?id=0B9...Es0VnlvR25hcUk
I automatically wanted to update my inventory as and when i type the product code in invoice sheet.
Please help me Sir
Please check your PM in box, I have send you a messageOriginally Posted by sikshit
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Sir,
This is something which i found on the internet. however i am not able to apply this code to my workbook even after changing the range,etc.
Many of our users are reluctant to load files from other sites for various security reasons. I am one of those. If you wish for me to offer assistance, then upload a file to this site.
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.
Thank you for your guidance.
I have attached 2 files.
Invoice is my workbook and Update Inventory is the file which I think is similar to what I want.
In the Invoice workbook there are 2 sheets - Invoice and Product.
Product sheet has list of all the products we have in our inventory.
So as and when i type a product code in invoice sheet, i wanted it to update in the product sheet and show the inventory in hand.
I basically want to auto update my stock in hand as and when i make a invoice and sell.
Please help me.
Anyone plz help me ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks