problem

Hi guys, I've got a wierd problem with this spreadsheet. An extract is available here: https://drive.google.com/open?id=1y_cvduilM1k3nnH8-hH0dbfdJPN9815t In column U there's a simple formula to sum the values in the preceding cells. The problem is that the first 4 rows are not summing...

I use Workbooks.Count to enable to Set a name to a new download. When the download is a .csv file there used to be no problem. However, in the last week (I have Excel 365, so it may have changed) a newly downloaded file of the generic ".csv" type does not get included in the Workbooks.Count...

Named Ranges become corrupted readily. I am writing a fairly large application using VBA and named ranges extensively. I have a major problem - it appears that in the event of any error in coding, wherever and not related to anything in particular, the defined named ranges are the first thing to...

Hi everyone! I'm sort of new here,a novice.I'v had problems with the excel for some time but the online suggestions couldn't help me as I don't know a lot of stuff. here is the deal,whenever I use a vba code. I have to clean up a list of exel on Task manager otherwise when I turn on my...

Hello i have a little problem here. , how can i fill colomn B faster. problem - > https://i.imgur.com/X7qf5vs.jpg ERJXGNJ7R8Y - where the R in 7R8Y stands for a decimal = 7.8 ERJXGNJ753Y * where the 3 in 753Y is the decimal place = 75000.0 video here - > https://streamable.com/4ssy1

Hello everybody. I've filtered some records on the original workbook and I've pasted them in a new workbook. If .SpecialCells(xlCellTypeVisible).Count > 2 Then .Offset(1, 0).Resize(lr - 1).SpecialCells(xlCellTypeVisible).EntireRow.Copy new.Sheets(1).Range("A2") End...

I have been creating several spreadsheets at work and there is a problem with opening more than 1 instance of them at the same time on a network. I have one spreadsheet called "quoting tool" that generates quotes. When quotes are finalised they are sent to separate spreadsheets called allocation...

Hi All I am trying to open up a workbook from my existing file (that file is the latest workbook) but im having 2 problem 1) I want to disable any workbook open code for the new workbook so if opened by macro then disable but if that workbook is opened physically then the workbook open should...

Hello, I have a problem when I am copying a csv text from a .txt file into Column A - on some rows the data is split between col A and C. I don't want to use the import csv. function because this is part of an RPA process and I want to keep it as simple as possible. Basically, what I am doing...

Hello everyone I have a GETPIVOT Data formula in A8 =GETPIVOTDATA("[Measures].[Name]",Total!$A$1,"[ValuesTable].[Employee ID]","[ValuesTable].[Employee ID].&[A0107733814033]") But this doesn't increment because of the ID written so i've tried to modify it to...

Hi ive searched google to try and find answer to my problem but there are similar questions but dont know how to manipulate the vba to suit me. My problem is i need to achieve the following i enter a value into A1 e.g 10 and it would then goto the start of my table data say A16 and then copy...

Hi All, Currently, I'm trying to resolve TSP problem regarding number of people need to cover stores in a day. What I'm thinking currently is to setup a constraint and actual working minutes & velocity to travel to stores as per current below. However, I'm stuck with the formula on how can I...

{=IFNA(INDEX(PO[Price],MATCH([@[SO Date]]&[@[User Name]]&[@[Item No.]]&[@[SO Qty]],PO[Posting Date]&PO[User Name]&PO[Item No.]&PO[Quantity],0)),INDEX(PO[Price],MATCH([@[Item No.]]&[@[Cost Exact Match]],PO[Item No.]&PO[Sales Exact Match],0)))} My formula works but I know it should be written...

Hi everyone, After installing Excel 2016, sometimes occurs the error "Microsoft Excel has stopped working", when I open a specific workbook, which has more than 100 sheets. To solve the problem, I have to open this workbook in other computer with Excel 2013, and save the workbook. Afterwards It...

Hey Guys ! Can any one help me out, i am stuck with a problem I have a list of codes in Sheet1 from A1:A1000 I want that list to populate as list ( Data Validiation ) in Sheet2 from B1:B1000 ( but from B1 to B1000 the list should be searchable ). As in when B2 is selected then selecting codes...

I've had a VBA macro heavy spreadsheet I've been using a long time. I've had 2 problems and here are the fixes in case anyone has a similar problem. Problem 1: Macro to name file by date was a major headache I solved by making a "save file as" cell on the sheet that I type the name of the...

Hi, I’m trying to create a formula that involves using IF and OR. The problem is that the columns the formula references have a lot of #N/A errors in them, so the result of the formula ends up being #N/A if there is an #N/A in either column H or column I. It just seems to disregard what is in...

Good Afternoon, I have been struggling with this problem for a few months and several people have kindly attempted to help through the forums, but I am hoping I can finally solve my problem definitively. Is it possible to create a formula that will generate a random number between 0.00%...

Hey Dear community, I have problem with following formula This is working formula sum(if((isnumber(match(rn,mrkt,0)))*(sfs>0)*(urun<>"""")*(not(isnumber(match(mstr,by,0)))),printed)) But this one is not working...

Dear all, I currently have problem with the header added to my listbox. It has been activated (listbox property where columnheads of the listbox = true) but I don’t know why the code below Listbox1.rowsource = (“E1”) Where in the cell E1 from an excel sheet its’ written ‘’blabla’’ but the...