help me please

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

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

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

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

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

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

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

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

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

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

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

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>

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

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

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

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

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

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

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

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