works

Hi there, so I have the following code. it works great, if there are 3 rows or more. But if there are only 2 rows, the script copies down from B1, instead of essentially doing nothing. I do not want the header to overwrite B1. Is there an easy fix? I tried offset, but I don't think that works in...

So I got a new computer and on it came Office/Excel 365. I pulled open one of the spreadsheets that I have been working on and figured out that the "-" key doesn't work when it is the first key pushed in a cell. For example: If I want to put in a negative number I would input -123, the...

Greetings, I have some code that works, but but now I need to make it loop upwards through the blank cells and stop before overwriting the first non-blank cell. I just can't seem to figure out that whole "i = / Next i" thing. Also, in the last "Else" statement if the cell (0,-13) from Active...

Hi all, I am trying to enter a formula to calculate how many periods it will take to payback. The formula I have works well unless someone enters additional capex at a later date - then it all goes to pot. The original calculation is on sheet 2 - but I'm playing around with sheet 1 to try and...

Hi there, I have three columns in a Power Query Table in Excel with Year, Month, Day (they're numbers, for instance: 2018,08,25) and I would like to merge them in a date column (DD/MM/YYYY). I searched in Google for a solution and tried everything but nothing works, it just give me an error...

Hi, I'm trying to extract some data from an old workbook which is locked (and the password is unknown and I cannot crack it). I have managed to type in the location of data in the old workbook into a new workbook to extract it (=[OldSheetName.xls]OldSheetName!A1 and fill down), which works...

I have a INDEX/MATCH formula, whenever it encounters a duplicate, it is being ignored. Otherwise it works fine =IFERROR(IF(COUNTIF($J$3:J3,J3)=1,MATCH(J3,INDEX(Input_Events,,5),0),MATCH(J3,INDEX(INDIRECT(ADDRESS(ROW(Input_Events)+K2,6,1,1)):data!$J$102,,2),0)+K2),"") Thanks

Hi, I'm trying to reference a named range using the indirect formula but am getting an #REF error. =IF(cur_month>=G$12-1,SUMIFS(INDIRECT("amt_"&G13),INDIRECT("dpt_"&G13),'Rooms-0010'!$A32,INDIRECT("acct_"&G13),'Rooms-0010'!$B32),SUM(G15:G31)) cell G13 has the value of "Jan" and my named...

I'm new to Macros and working with a training tutorial, and there's a really simple problem, I just cannot figure out. I feel so stupid asking but i need help. Here's my code. So... I copied and pasted the line currently ' - which works fine But when I type the line, I get an "Unable to get...

I have an advance filter which works perfectly if I use this formula =AND(J16>=0.607,J16<=0.627) I does not work if I us this formula =AND(J16>=O6,J16<=P6) O6 and P6 are not in the List or Criteria range. O6 contains a formula that return 0.607 and P6 contains a formula that returns 0.627. So...

Just imported a load of CSV values that came across as 1/15/2019 12:22 date and time I was following > https://www.mrexcel.com/forum/excel-questions/1086344-formatting-dates.html which works when no time value is involved. Just wondering if a small vba script could be developed that would strip...

I have a payroll spreadsheet that features a cell for deductions. I want to make sure that regardless of whether we enter a positive or a negative number in that cell, the number always reverts to negative. I found a code on extendoffice.com that works, but I have to add it to every sheet. I...

Hello everyone, I made a Macro and it uses many user forms depending on the buttons you clic. The point is that I use a .vbs script to run it without having to open the excel workbook. It displays the login userform and everything works perfectly. The problem is that after you are done using...

I am so close with my macro... This is my last error. I am using the ActiveSheet.Range("").Select method, and it is doing the following: ActiveSheet.Range("A6").Select 'works like a charm for exactly what I need. I am copy/pasting between files, and using this works. I would like to use the...

Hi I copied the code below from a website and it works fine and I got an idea what it does. But I tried to understand what "ActiveCell" returns. So I did the following in the immediate window ?ActiveCell and I got the "Hi" which is the content of the cell A1 that is selected? if that is the...

Could anyone please tell me what I am doing wrong? =IF(AND(C2=C1,D2="LIS",D1="LIS")*OR(C2=C1,D2="LIP",D1="LIP")*NOT(F1="PL")*NOT(F2="PL"),TEXT(B2,"00\:00\:00")-TEXT(B1,"00\:00\:00"))*1440 I've tried doing it this way aswell...

Hi, I have data with product names in A5:A14 and associated sales values in B5:B14. I have used LARGE() to extract the top 5 sales values from column B I now need to create a formula that will return the product name associated with each of the 5 largest values. The problem is that there...