help me please

  1. A

    Calculate the difference in minutes of 2 rows

    Hi experts! I'm new to the Power BI world and I have a job to do, but I can't find the way to do that... If you could guide me, would be great! I need to obtain the time difference in minutes between a row and the one that follows. I would like to use the field "DATE" to calculate and maybe...
  2. Y

    Formula to Sum Outstanding Amount Due

    Hi there, To assist the lady in accounts, I've been asked (an Excel newb) to create a spreadsheet that allows Accounts to keep track of outstanding invoices our clients are due to pay. My example: So far I've made it so that information has to be input into cells A through to E. 30 days...
  3. J

    Compute and populate the chart from date range

    Hi all, I hope you can help me with what I would like to do. I've searched and searched and not come up with anything yet!! I have one sheet which is my 'data' sheet with a number of columns according to date. And I have another sheet which is the chart sheet. I want to populate the chart...
  4. B

    Dependent ComboBox

    I'm creating a dependent drop down box using ComboBoxs. I have a total of 3 boxes dependent upon the previous. I've written the below so far but it's not working. When I select the item in the 2 drop down it doesn't appear in the drop down. Or (If i take out the .clear from below) the list...
  5. T

    Excel vba import data

    Hey guys I'm a newbie on the VBA, and I need to do a project for the company I work. Every thing was going very good until I knew that I was going to need to import information from another excel file to the one I'm developing. And they said I need to take the information out of 3 columns, and...
  6. D

    VBA Question

    First of all, thanks to everyone who has helped me on my current project. I currently have a code to prompt for password before saving a metrics file, which only a handful of people know the password (and not too many are bright enough here to look in VBA to find the password :rofl:) I was...
  7. S

    VBA - Paste 1004 Error

    Hey All . . . I have used this code before, grabbed it from here (good stuff if you use SSRS):Chintak's Blog - Refreshable SSRS reports in Excel - Chintak Chhapia , and it has always worked swimmingly. I have another use case that requires this trick, but I am repeatedly getting a paste error...
  8. A

    Adding a button or macro to change values of cells?

    I am trying to build a worksheet, and it would be very helpful to put a button in that manipulates the values of certain cells. Above is what a row of my spread sheet looks like. What I want to do, is add a check mark box in N2 that, if checked, would do the following: 1, make the value of...
  9. S

    Unsure of How to write this equation

    I'd like to know what kind of formula/what is the formula to have Excel figure something like this out: Say A=7 B=12 C=30 D=Scaling(1-100) Like a unit's level And it will make Q=((A*B*C)+(C*D(also D-1, etc)) like an Arithmetic progression. Where D is Q/((A*B*C)+(C*D(also D-1, etc)) So for the...
  10. A

    Run time error 13 mistype. how do i stop this? please

    hi i am getting a run time error 13 mistype when i copy a cell from one workbook to another. The cell just contains an address. on the workbook i am copying to it has some vba running. The code is used to take a name from cell D3 and rename the tab on the bottom. i am not even adjusting this...
  11. G

    Powerpivot Weighted Average Measure

    Hello, I have a data that calculates forecast accuracy. I have this as a measure - the measure formula is...
  12. R

    Help with IF rule

    I want to create an automatic rule that if column(c) contains specific text(total), then column(d) divided by column (g)= column(h) <tbody> Grand Total 446.75 $508,716 0.088% </tbody>
  13. H

    Query about Input boxes

    Dear Excel Wizards, I was wondering if it was possible that when you answer a input box with no answer "" and then press ok then the input box loops to ask the question again. If the user inputs nothing "", and clicks cancel or clicks the red button then the sub is exited. Or even better if the...
  14. N

    How can I make cell value update automatically upon opening each time

    In Microsoft excel, I'd like to enter an order number in one of the cells for each packing slip of each order. What I'm wondering is, how would I make it so that value would automatically update everytime I open my excel template. eg. after I finish a packing slip and the order# is 1001 I save...
  15. N

    Excel Bar Chart Help

    <tbody> Product Min Median Max Apple 1.00 5.00 7.00 Orange 2.00 4.00 6.00 Pear 0.50 3.00 7.00 Bread 1.00 2.00 3.00 Croissant 0.50 0.50 0.75 Scone 0.25 0.40 0.8 Lettuce 2.00 2.25 2.60 Cabbage 3.00 3.20 3.40 </tbody> Hi, This maybe a basic...
  16. A

    Need help with Data Validation

    The problem i'm facing is that C8, C9, and C10 all have to be positive values and less than C4+C5. That part I've figured out and is fine but the problem is that C9 has to be greater than C10. I set it so C9 has to be between the above restrictions and set C10 so the minimum is C9. The...
  17. M

    VBA help, creating a macro!!

    Hi I want to create a button on an Excel spreadsheet which will go into a folder, open up the most recent excel file. Add together several cells in that file (B12,B13,B14,I8,I13) then display the answer in the spreadsheet which contains the button (in cell J3). I've already started the code...
  18. L

    Update vba code to change the code after it has run?

    Hi all. I have a macro I wrote in vba (2010) to update the years in a template and change the sheet name. The code is based on the individual sheets original name. Is there a way or a line anyone can think of that will change the code to match the new sheet name after the macro has done it's...
  19. V

    Trailing Zeros Problem. Need Help Badly

    Hi, I had a excel sheet sent over to me it had account number of 16 digits something like this <tbody> 8342561027735067 </tbody> but when i opened excel sheet all the numbers were converted to something like this <tbody> 8.14731E+15 </tbody> When i tried converting it into number all...
  20. K

    Need assistance with using email with VBA

    Hi there! I am relatively new to a company that are using macros as part of some key processes, I have been tasked with fixing them whenever there is an issue because my predecessor created the macro, but my VBA knowledge is minimal so any help with this would be massively appreciated! The...

Some videos you may like

This Week's Hot Topics

Top