original

Hi All, I'm currently trying to get an IF function to work where i want the function to basically say, if the number is below -10000 or above 10000 then display "STRAIGHT" in the cell. If not then display the original cell value. I've tried =IF((BO31<'-10000,BO31>10000),"STRAIGHT",BO31) but it...

Hi My code below removes duplicates to a new sheet, however I need it to do a bit more which I can not work out and have been stuck on for a few days. Command Button1 Dim Rng As Range, i As Long Application.ScreenUpdating = False Set Rng = Range("D1:D" & Range("D" &...

Hi, I need some help with creating a macro, that can move a open workbook to a new location and delete it from the original location. Is that even possible? regards, Hawjeen

Hi, I have a series of .csv files that contain 2d x&y coordinates like so {x:416.83624,y:379.13855,status:0},{x:415.50653,y:378.78394,status:2},{x:414.4428,y:379.13855,status:2},... There are thousands of these points, all in text in one cell. How can I pull out the x & y coordinates and drop...

Hi to all of you, I would like use a vba code so that to run through col. “A” and where the find the text “Grand Total” then to clear any contents in adjacent cells’ range “B”: “J”. I present below an extract of original and expected result. Many thank in advance to all Original data...

Hi all, how can I achieve that, where in col. “B” exists the number “1” and in col. “B” is blank should place zero “0” in col. “C”, using VBA code. Please see below original data and expected result. Thank you all in advance Original data <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings>...

Hi, I use the excel camera tool a lot to create "dashboard" type of page. The issue is when I select the range and create an image with the camera tool, the "Scale height" and "Scale Width" of these images are not 100%. It is around 93~94% on height, and 67% on the width. HOWEVER, the image...

i am trying to write a formula to return my value with request: #1 ) if cell B2 value is "full", return with "anytime" in C2 #2 ) if cell B3 value is "0", return with ""(leave it blank) in C3 #3 ) if cell B4 value is contain "0:00", return with the original value in C4 actually i want to use...

Hello! I have created a macro-enabled workbook that I would now like to use as a template. My goal is to have this file (we'll call it workbook1.xlsm) save multiple times in a specific folder (Folder 1) based on a list of names with the macros from the original file intact. I am trying to have...

The original formula looks like this: <code> =SUM(COUNTIFS(Details!$BA:$BA,"A",Details!$AZ:$AZ,">"&"2018-12-31",Details!$AZ:$AZ,"<"&"2019-4-1")+(COUNTIFS(Details!$BA:$BA,"N",Details!$AZ:$AZ,">"&"2018-12-31",Details!$AZ:$AZ,"<"&"2019-4-1"))) </code> The purpose of this is to feed into charts...

I have a script that is working but I need to streamline it and make it more user friendly. My code opens up three spreadsheets and copies them to tabs 2,3 and 4 in the original spreadsheet. It renames the tabs and does a bunch of formatting and a few Vlookups. The original code to open up the...

Is there another way of reverting back to the original column sort order other than adding a helper column with the original sort order (without using VBA, of course) Jon, from Excel Campus, posted a video today on this topic (he is describing the helper column index method in his tutorial)...

Hello everyone, On my work I use a workbook to logg specific data and information during the day. At midnight I send this report and start a new one. I have made a simple macro and locked it to a button. This copy the active workbook, moves some specific data, change date, clear the fields etc...

Good Morning Everyone, I'm trying to come up with a macro that will save a workbook in two different locations.This workbook gets used ONCE per day so for example, the original file resides on the desktop and I want to save that as the original file "C:\Users\Leasburg Front...

I have inherited a spreadsheet which contains a look-up table and now need to update the text and figures in the table but can't see where the original data is stored, is there a simple way of finding it?

Hi all, I'm trying to use a stadard form called "Master Cleandeskform.xls", and I would like to save it in the same folder as the original document, under differend name. Cell F3 contains the date, which is used to complete the file name. Example: "Cleandeskform 17-02-2019.xls" Everything is...

Hi, I have the following code for saving a new sheet, but this only works when the original file is .xlsm. Any way to change this to work when the original file is .xltm? When the original file is .xlsm it saves in the right shared Onedrive folder, but when the original file is .xltm the now...

I have a large spreadsheet (over 20k rows), in column a there is a company name and then many empty rows next to it. I need something that will fill down until it gets to a new name and then fill down again. see example, column a is original and i need it to be like column b thanks in advance...

I'm hoping someone out there can help with this. I have a workbook with a sheet I want to save as a new, separate workbook of its own. I want the new file to be named by a specific cell in another tab of the original workbook and the new workbook needs to be either in the same directory as the...

Hello, To make a long story short I've upload a excel sheet as example of my requesting. I'm looking for a way to get the sum of expenses based on multiple criterias. https://www.sendspace.com/file/2ibp7m ** the original file has a large amount of rows and with more arguments, so the attached...