Invoice stock checking

[unilever]

hello guys hope everything is OK.
i am little stuck here and i need your help.
i am trying to create an invoice that will be used in stock checking and issuing of receipt which i did. (thanks to skywriter).
Now another problem is that i want to be adding the stocks (Received stock sheet) as in batch by batch so that there will be a column for vehicle number, date, name of transporter and quantity. so that if i received goods from my supplier i will just enter it there so that it appear on the available stocks sheet.

[skywriter]

Your code is password protected.
Password?

[unilever]

The password is Jalingo77

[skywriter]

The password is Jalingo77

It's not working. I double checked my cap locks are not on, I even copy pasted the password and it's not working.

Maybe check it on the file you posted or unprotect your file and re-attach.

[unilever]

It's not working. I double checked my cap locks are not on, I even copy pasted the password and it's not working.

Maybe check it on the file you posted or unprotect your file and re-attach.

jalingo77 in lower case

[unilever]

If it didnt work Try JALINGO77

[unilever]

I am not close to my laptop thats why. But if it didnt work then later on if am back i will remove it and send it again thank you.

[skywriter]

jalingo77 in lower case

That's the one.

[skywriter]

The only headers you have in your Available Stocks sheet are:
(SKU) (SKU DESCRIPTION) (AVAILABLE STOCKSQtyQty)

These are the only ones we are interested in on the Received Stocks sheet.

If they were in the same order that would be great, then you run a macro and whatever is on the Received Stocks sheet gets added to the Available Stocks sheet.

Is this what you are after?

[unilever]

The only headers you have in your Available Stocks sheet are:
(SKU) (SKU DESCRIPTION) (AVAILABLE STOCKSQtyQty)

These are the only ones we are interested in on the Received Stocks sheet.

If they were in the same order that would be great, then you run a macro and whatever is on the Received Stocks sheet gets added to the Available Stocks sheet.

Is this what you are after?

Yes but i want it to be with records so that if i am checking when did i recieved a waybill and what did i recieved. It will appear

[skywriter]

I'm not clear. The best thing to do is format the sheet the way you want it and give me an example of what you want it to look like with some data and some more detailed instructions.

[unilever]

I'm not clear. The best thing to do is format the sheet the way you want it and give me an example of what you want it to look like with some data and some more detailed instructions.

Ok what i am saying is that i want the records of the goods recieved to be available when ever i need them. for eg let say i recieved ten cases of lipton on the 20th of august. If i put them on the recieved stock sheet the should automatically appear on the available stock sheet.
Morever instead of typing in the names of the skus i want to select them from a list and save so that anytime i want to check when did i recieve lipton it should appear with the date and transporter info hope am more clearer.

[unilever]

Hello skywriter

[skywriter]

Hello skywriter

I responded in post #11.
I asked you to do some things, but you didn't do what I asked you to do, you simply quoted me.
I am not here to design your spreadsheet.
You mentioned things in your first post that don't exist.

vehicle number, date, name of transporter and quantity.

I am here to help you make your already designed spreadsheet work for you.

[unilever]

Ok will do

[unilever]

Ok will do

[unilever]

Hello Skywriter here is the modified sheet as you requested.
what i want is that when i received goods i will add them to the received goods sheet after that if i click on add to available stocks. what so ever goods i received on the received goods sheet should automatically appear on the available stocks. and also when i click on save received stocks the received stock sheet should automatically be saved on my c drive in a folder called invoice. with the name of the waybill number(i.e let the file name be the saved as the waybill number on cell B4 so that whatsoever is in cell B4 be the file name).

i do count on your support always.

Thank you for your Enormous Help and Consideration.

[unilever]

Hello anybody here