excel

Hello to all who might be able to assist me and my colleagues with this. I am trying to find a way to split the ranges of numbers apart and to get each individual number that would be in that range. For instance, some of the data I am working with is: 120751.120754 120760.120764...

In excel I have sheet 1 and 2. Basically if the cell value in sheet 1 is either (s) or (c) I want to pull a value from sheet 2 based on the (s) or (c). So to break it down in sheet one I have the baseplate geometry and it can either be sqaure (s) or circular (c), based on if that cell says (s)...

Hello, (First; I have Office 2016 at home) I want to run a statistical analysis on my photos that I have taken over the years to see what my most used focal lengths are. The focal lenght in the EXIF data is available for windows explorer and can be seen like this: In excel, I just learned...

Hi, I created a UserForm to enter data into a worksheet. In that UserForm I have a button that opens a ListBox showing all the records stored in the worksheet. I want to filter this ListBox using a ComboBox based on my "Area" column. I populated the ComboBox using unique values from the column...

I have a workbook with multiple sheets and I have a simple macro to go to the last row in the sheet Sub LastRow() Range("amberville").Select Selection.End(xlDown).Select End Sub my problem is that when i copy the macro button to other sheet in the same workbook it doesn't work unless...

I have a few sheets that are printed together to a single PDF file. I'd like to get the page number where each sheet will start in the PDF and include it on the first sheet that is part of the larger PDF. I found this a few other things that do not work...

I am getting this error message popping up in a workbook I have, but not when I am running the macro (there's only one in the workbook at the moment). The macro runs fine with no errors, but any time I enter any data into a cell in any worksheet I get this pop up error message. I've looked in...

Hello, I need help with an excel formula that will auto populate the column PRIORITY LEVEL based on columns CRITICALITY and FREQUENCY LEVEL (see attached screenshot of what should be populated in PRIORITY LEVEL column). I know that this can be done using IF function, but I can't seem to find...

Hello All. I have a workbook into which I have placed the following code which works as it should. This was done to prevent all following instances of Excel having hidden toolbar etc when opened while this workbook is open. The code below works and allows excel to opened ok with toolbar present...

0 I have a piece of code that is trying to overwrite the value in a named range, but I am getting <Object doesn't support this property or method> Sub CheckStuff() If Evaluate("Table1RowCount") > Evaluate("Table1LastRowFixed") Then ActiveWorkbook.Range("Table1LastRowFixed").Value =...

VBA Newbie here; I have built a macro to copy data from one spreadsheet to another, compiling multiple sheets from the source workbook into a single sheet in the target workbook. However, the report that spits out the source workbook does not always have the same number of sheets. Is there a way...

I have "Asset ID" in Column A, and "Unit ID" in Column B. See Image of sample data below. I need to find the largest unit ID for a given Asset. I found: MaxSN = Application.WorksheetFunction.Max(Range("B:B")) But this only works if there are numbers - the SN messes it up. I tried using...

VBA Newbie here; I am attempting to use a sort of search function in a schedule that I create every day for work. In essence, the schedule that our software exports does not include the date that the finished good jobs are tied to; the jobs are scheduled per week, but that data is not shown in...

Hi all, Hoping someone can help me with this "Run-time error '76': Path not found" problem that im getting I have a sharepoint directly mapped to my C drive, and im using this code to try and create a folder in said directory but when running im getting an error my foldername required is in...

I have a spreadsheet in which the user will enter data in Column A. Every time that data is entered, I need that data to be stored as a string "Asset" for additional steps. I cant get this to work: Private Sub Worksheet_Change(ByVal Target As Range) ' Check if the changed cell is A1...

Hello I'm moving completed tasks from one sheet to another and want to be able to move a task back into my worklist sheet. I have a vba code in Excel for cutting and pasting rows from one sheet to another based on cell value="completed". Now I want to be able to reverse fromthe completed...

Im trying to set up a document to show the differences in days between 2 cells = Example: A1 has a planned date, B1 has an Actual, C1 has the difference, i have used =B1-A1 in cell C1 but if cell B1 is empty it is bringing back a number of "45448", why is this? What is the best formula to use?

Hello, I am having trouble calculating a time difference between 2 x calculated dates taking into account workdays / weekends and working hours. Could someone help me coming up with a working formula? I have tried NETWORKDAYS - but don't know how to account for working hours. My problem is that...

hola pido ayuda para resolver esta practica de excel no entiendo que tengo que hacer ni como hacerlo si alguien me puede decir que tengo que hacer exactamente y como lo resuelvo seria de apreciarse bastante gracias

Hi all, I'm wanting to make a calculator to help me keep track of scores/damage during gameplay, and help me make sure I don't miscalculate damage to the players or monsters. In an ideal scenario, I would have a checkbox (B1) that I can check for any weather condition. I also have the...