a10

Hello, I am a relatively modest Excel user who i just breaking into VBA. I was hoping some of the members of this forumn could help me with a project that I am working on. Basically I have a master list of data (sheet one). On this list column A ("Quantity") is empty, and columns B through G...

I am trying to add or subtract a % (based on typing 5% or -5% etc) to a subtotal to get a new total. For instance, if in A10 I have a summed subtotal, I want to be able to type a positive % or negative % in A11. In A12 I want to total A10 plus or minus the % typed into A11. I hope that makes...

Hi everyone, I need help in figuring out a formula. Cell A1 = 2 Cell A2 = 3 Cell A3 = 3 Cell B1 = A Cell B2 = B Cell B3 = D ======================================================================= Example #1 : Now in cell: A6 = 2 A7 = 3 A8 = 3 I'm trying create a formula that will place...

<colgroup><col><col><col></colgroup><tbody> A 1 5 B 0 C 6 2 5 1 4 3 0 3 3 4 2 2 3 5 7 6 9 6 4 2 9 7 9 8 1 8 5 2 3 9 5 7 7 </tbody> 10

I have following code: I want to change the lookup value as the value of I changes. Like A8, A9, A10 ................ Any help is appreciated. Thank you

Hello, I need a help to get Multi-quantity for multi-BOM, example: actually in Multi-BOM, A3 need 4pcs Layer. No. Qty Multi-Qty 0 A1 1 1 A2 2 2 A3 2 3 A4 1 1 A5 2 2 A6...

I have a number in A10 which decides how many numbers should be considered for the below given MIN function. For e.g. if A10 says 2 then the MININUM of first 2 numbers should be the output i.e MIN of A1 & C2). If A10 is 3 then MININUM of first 3 numbers in the given formula i.e. MIN of A1 & C2...

Hi This seems quite simple but I can't seem to find a way of doing it or the correct terminology to search for it. But basically I have the following 2 Sheets On sheet 1 I need In cell A10 = Sheet 2 A8 In cell A11 = A10 In cell A12 = A10 In cell A13 = Sheet 2 A9 In cell A14 = A13 In cell...

Hi, I have 4 sheets in my workbook.. Summary, Sheet1,2,3.. Summary has all the sheet names (A1 to A3).. Each of Sheet 1,2,3 has numbers from A1 to A10... What I want to do is, in Summary sheet, against each of A1 to A3, I want to list down maximum of A1 to A10 in each Sheet 1 to 3 by referencing...

Hi<o:p></o:p> <o:p></o:p>I have a spread-sheet in which one of the rows is a summaryof columns: ie row 10 each cell from A10 to ZZ10 is a sum of the values in Rows 2 to 9, ie Cell A10 is the sum of A2 to A9, and soon. the formulas are from A10 to ZZ10. Row 1 A1 to AZZ are dates. So A10 is thesum...

So I have a few formula's that are based on checkboxes that I've set up I was wondering if it's possible to have a formula that will physically check other boxes to true. I'll write it out in terms of how I'm wanting it: IF A10 is true (checked) then A1:A8 should all be checked. Basically...

how to calculate YTD with 2 criterias (i.e. heading is the month from B1 to M1 and Specific Code in the column A2 TO A10) Example A2 – A10 has name of the fruits B1 to M1 has Jan to Dec Each fruit has a value from Jan – Dec entered in B2 – M10 I want to get the YTD total of fruit if I...

Hi, I have used the following code to take a value from cell "A10" in "Sheet1" to reflect in "Label1" on my userform. The code is working; code: Label1.Caption = Sheets("Sheet1").Range("A10") I have formated Cell "A10" on "Sheet1" to South African Rand value. The value in cell "A10" is "R40...

Please anyone help me out of my problem. If I type any word or number between A1 to A10 only “√” should appear.