a11

hi all, I checked all the threads that could be altered a bit to get what I want, but I believe because of my very limited knowledge of VBA, I couldn't reach anywhere. Here is what I have: - Formula in cell D3 that counts the number of records based on the value of cell A11. - An array...

Hello, I have a vba code that will fill a series from A11 down however if there is only 1 item (A11) I need something in my code that will recognize this and not give me an error but continue with my macro. What could I add to this line to have that happen? ActiveCell.FormulaR1C1 = "1"...

Hi all, trying to finish a job involving exported data. the export populates either range A10 or A11 on each sheet with a value. what do I use to to the effect that if A10 is blank, assign the value of A11 to my variable and vice versa?

Hi I have a table which has a total row. the headers of the table refer to dates. At the moment I have a formula sub totaling the whole from to date range however I want the user to be able to use a drop down where they can choose the start date range and for the total to update accordingly...

If I have a cell with two digits - how can I use the SUBSTITUTE function to add an extra character to make the cell have 3 digits? So a cell with 11 would turn in to 011 or A11 Thanks for your help!

I have looked at a dozen pages and I cannot understand why this is not working. The INDIRECT range on the left should be exactly the same as the range on the right but I am getting #REF !. =SUMIF(INDIRECT("'" & A11 & "'!" & AM2:AM5000), ">0", 'West Creek'!AM2:AM5000) The value in Cell A11 is...

Hello Everyone Can someone help me convert below data from: <colgroup><col width="64" span="19" style="width:48pt"> </colgroup><tbody> JR TR1 TR2 TR3 TR4 TR5 TR6 TR7 TR8 TR9 TR10 TR11 TR12 TR13 TR14 TR15 TR16 TR17 TR18 1 a1 a2 a3 a4 a5...

I want to re arrange my data as follows , if i do manually it will take long , cell reference A meaning on sheet 2 <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> D3 TO A1 E3 TO A2 J3 TO A3 O3 TO A4 N3 TO A5 F3 TO...

Hello hope you can help I have a column O with 7 different codes, each one relates to a name. I just want to a formula to look at the code in O then return the name. B2:B8 are the list of codes C2:C8 are the list of names I want a formula in A11 which looks at the code in O11 then returns...

<colgroup><col span="3"><col><col span="3"></colgroup><tbody> 3 4 4 10609 2 2 5 5 5 2 10608 2 2 2 3 4 5 10607 1 1 1 3 4 5 10606 4 2 4 5 5 2 10605 4 5 3 4 4 3 10604 2 3 5 1 2 1 10603 4 5 4 4 1 2 10602 5 5 3 3 4 5 10601 5 4 2 5 3 4 10600 5 3 4 1 5 5 10599 4 4 1 2 2 5 10598 2...

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...

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...

Hi, How to do index match with returning unique value. Column A contain code and B contain text. Snap shot attached for your reference. https://www.dropbox.com/s/w1mrqn8x43i26c8/INDEX.PNG?dl=0 Please help me. <colgroup><col span="2"><col><col><col><col><col><col></colgroup><tbody> DATA...

I have a long list of following cells: A11: XYZ A A21: XYZ B A31: XYZ C A41: XYZ D My desired Output: A11: XYZ A B C D Please help me in to find a function or formula.

Hello, and thank you for your help in advance. I have a list of percentages based on their original value, some may increase, some may decrease, or the value can stay the same as the original amount; or no change. That said, I have the following criteria I can't seem to get right on an "IF"...