Question about Excel (SS8SATAS5128400R)

2 Answers

Excel formula creation

Hi! I would like to create an formula for in and out stock control system.
For example: Total Stock minus OUT quantity= Live stocks (10-5=5)
I am taking out stocks many times per day with different amount, so I need to have an total that is up to date. THANKS!!!

Posted by on

2 Answers

Hi, I need to have the TOTAL that is only changing when add/take away stocks. The input value is every time diferent.
I tried to play with macros a litle and it worked with stock OUT.
Now I only need to adjust the formula for IN stocks. Please help!!!
Find below the macro...

Private Sub Worksheet_Change(ByVal Target As Range)
Set r1 = Range("K2:K1000")
Set r2 = Range("L2:L1000")
If Intersect(r1, Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target.Offset(0, 1).Value = Target.Offset(0, 1).Value - Target.Value
Application.EnableEvents = True
End Sub

Posted on Sep 06, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Expert
  • 78 Answers

= (a3) minus (b3) won't do it for you?

Posted on Sep 05, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I need ethernet controller driver. Does anyone know where to download the driver? Please email me at antonakilov@yahoo.com Thank you


Now a day virous delating this softwere. we can get it in our mother board softwere cd. first virous ,malaware and worm. should be delated. you can get it on www.driver stock.com) thanks

Jul 14, 2009 | Network Storage Systems

1 Answer

Excel question


You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.

Aug 19, 2008 | Excel (SS8SATAS5128400R)

1 Answer

HELP with macro config


Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table
table_to_check = the table you want to find the data from
column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.
range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here
B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)
G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)
etc

Jul 12, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Prevention of delition of cell which has a formula


If you right click the cell in question and go to Format Cells..., on the protection tab there should be a check mark in the locked box. Go to the tools menu and choose Protect and Protect Sheet, enter a password and your cells will be protected.

Any cells you want to allow changes to when the sheet is protected should have the Locked checkmark removed.

Jun 16, 2008 | Excel (SS8SATAS5128400R)

2 Answers

Version Tracking in a workbook


Hi blackhand18,

This might be different on your version of excel but try this

=INFO("release")

Jun 04, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Calculate a bill


Hi you can Apply below mention formula
=ABS(SUM(COUNTIF(RANGE,"CATAGARI")-(COUNTIF(RANGE,"CATAGARI")))

RANGE = FROM WHICH CELL TO YOU WANT TO APPLY THIS FORMULA TO TILL WHICH CELL.
CATAGARI = WHAT DO U WANT < FOR FOR FIRST > FOR SECOND

May 22, 2008 | Excel (SS8SATAS5128400R)

2 Answers

Attendance sheet in Excel


Hi KDina,

If you need me to work on this project for you please contact me at hdbas8@gmail.com

May 17, 2008 | Excel (SS8SATAS5128400R)

1 Answer

To turn hours and minutes into decimal


Let's say that the time is in cell C3.
Now in cell D3 type =C3*24
then format cell D3 as Number.

Hope this helps.

Apr 24, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Excel formula


Assuming that all of your data is in a single row number 4 and between columns N and PF

Try:
{=OFFSET(N4,0,MATCH(TODAY(),N4:PF4,0)+1,1,1)}

The MATCH function looks up the value of today() in the range N4 to PF4 and returns the number of columns offset from the beginning of the range. (The 0 here does an exact match)

The OFFSET function returns a value from a cell a specified number of columns from a reference cell, in this case N4, which is the first column that contains the search data. We need to add on to this value to skip the Interest column.

Regards,
Daryl

Jan 25, 2008 | Network Storage Systems

2 Answers

Excel 2003 formula


detail about growth formula in ms excel

Jan 23, 2008 | Network Storage Systems

Not finding what you are looking for?
Network Storage Systems Logo

Related Topics:

149 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Network Storage Systems Experts

Geoff

Level 3 Expert

413 Answers

Brad Brown

Level 3 Expert

13540 Answers

Daily Mehdi
Daily Mehdi

Level 2 Expert

48 Answers

Are you an Excel Network Storage System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...