goods

Hi all I'm getting the above error on a new PC I'm setting up, it doesn't happen with the other PC's in use with the same code! With CreateObject("ADODB.Connection") .Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=K:\KKDB.accdb;" .Execute "INSERT INTO TestOpen...

I have raw materials. I want to be able to get the finished goods total from the raw material reference. the raw material is in another tab. I am desperate. Any help is appreciated.

I have raw materials that go into several finished goods. I will like a formula where I can input several Raw Materials and I get the count of the finished goods. I think a count if formular will work, but I am not sure.

hi, I need a macro code where specific column has to pick from TAB name. For Ex: excel sheet tab name "PRIME J654". Data in Column M in same sheet as " J654- GOODS INTAKE" 1.Now, if I change the name of TAB to "PRIME J655", Then data in column M has to pick the last four characters...

Hello Everyone, Happy New Year ! Hope you all had a nice time with your Family, Friends, Relatives.. Starting a New Year with a new challenges on Excel ! :) Basically I'm trying to build a 'Goods In' spreadsheet. Made the macro which gives unique ID for each delivery we are getting in...

Evening All, Could someone help me understand what I am doing wrong please. I am trying to create a user form (my first one) When I use userform_initialize it works the very first time I run the script. I then close the form to make some changes and next time I run the same script I get '...

<colgroup><col><col><col><col><col></colgroup><tbody> Posting Date Document G/L Acct/BP Name Inventory UoM Qty FG00017 500 Litre Water Tank White 02.08.18 SI 2109 Finished Goods Pcs 14 02.08.18 SI 2109 Finished Goods Pcs 13 02.08.18 SI 2111 Finished Goods Pcs 11 02.08.18 SI 2111...

Hello - I'm trying to find a formula that would allow me to perform the following calculation: The average number of new consumers is x per location per month The current level of goods = y By dividing y/x = the lifespan on a monthly basis If I need to determine the number of lifespan unit to...

Hi all, So I'm trying to run an INDEX MATCH against the nuber of visits that some of my web pages have received and view the top 10 by category. The issue I have is that I've found that some of the pages have received the same number of visits so when running the INDEX MATCH it's returning the...

Hi All, I need some help with constructing a formula. Basically I have a three column table, one column is transfer document, one is shop and one is goods code in the shop. What I'd like to see is what is the goods code of the same goods in the different shops. The only connection between the...

Hi I have two tables (Table1 and Table2) on 2 different tabs (Sheet1 and Sheet2, respectively). Table1 <tbody> Name City Line District James Boston Hard Goods John Los Angeles Soft Goods William Baltimore Soft Goods Harold Miami Hard Goods </tbody> Table2 <tbody> Name City...

Hi all, Please help me about this situtation. Now, I have much orders which are have some kind of goods is the same. It's on the data_need_find sheet. The inventory have the total data = data_source sheet. And the question is, how I could make a macro to minus decesing the quantity of each kind...

Hi All, I need to make a quick schedule to calculate shipping and processing times for my business. My schedule contains multiple stages that differ in their time period, so I would like to have something that can calculate when all tasks need to be completed by in order for my shipping to...

Dear Professionals I have a data sheet of goods codes. I want to find and sum all specific goods code of a company and put it in another sheet. I tried many functions.But i didnt get the right result. Please help, thank you. Data Sheet of goods codes ( in sheet 1) <tbody> <tbody> Company Name...

Please advise why the variable 'lastrow' is storing a value of 0 when there are data up to row 100 in column A Sub usingFind() Dim ms As Worksheet Dim lastrow As Long, i As Long, c Dim myCell As Range Set ms = Sheets("mathew") lastrow = ms.Range("A" & Rows.Count).End(xlUp).Row x = 2 y = 3 c =...