place

I have created an excel file which is used to perform a simple calculation. The values will vary depending on the types of category data - there are 12 in total. I have been working my way through to verify the excel calculations of each group using a manual calculator. I have found an issue at...

Hi old friends, been a while since I've been on here; they got me learning python at work. Anyhow, I'm trying to create a VBA with regex-like abilities. I want to look at a string and parse all <*> (ie, <someword>) and replace it with the word as a variable. Example: Hello <username>, We...

Hello,</SPAN> I want to split columns C:H numbers, in to columns K:X, how I need that the C:H 6 numbers to be split in 14 cells in to K:X columns. Here I will try to explain, look up all C:H numbers in to in the cells K5:X5 (where I have got 14 numbers as follow...

Hello, Hoping someone might be able to assist please. I am running a program which updates some results if you place -6 in the q2 cell.I have been doing this manually but I wondered if there was a formula I could put in that would place the minus 6 (-6) number in the q2 cell say every 5 seconds...

How do I create an formula that contains if an value is found with in an search, and then an second value is found in another search, then the formula that will take place.

Hi there, Is there a way to show a pop up or a message based on a cell value each time the user opens the Excel file? Preferably they see it no matter where they were when they saved the file. Limitations: - No VBA!!!! - Users must not be able to alter or delete the message - Users must be...

Hello I have a question? In Excel I have list of the same numbers but in different areas on my sheet. Example 1 2 3 4 5. Now if I wanted all the 1's to change if I entered 6 in place of 1 what formula would I use rather than going through the entire page changing all the 1's to 6's?

Hello! Thank you guys/gals for taking the time to view this post. I am looking at creating a custom generator based on 3 criteria I give it. The first Criteria will lookup in Table_1, Find the corresponding data which will give it the next table link. From there it will use the 2nd piece of...

I want to add all data from D3 down to last used cell then go down 1 and place that result there. Can someone fix that for me?

Hi all, kindly advise me so that to create a VBA code which should run through col. “E” and where the code start from number 5, should place the letter “D” in col. “D”, from number 8, should place the letter “N” in col. “D” from number 4, should place the letter” C” in col. “D”...

Hi I have tried to create the VBA code below to populate values in column B but cannot get it to work. Essentially my spreadsheet looks like this with numbers and text in column A. Whereever there is a numeric value in column A, I would like to copy it and place it one cell above in column B...

here's what I'm trying to accomplish: if any of the same ID number in column B have Type 1 and Type 2 in column c, mark all rows associated with that same ID number with "priority" in column A i have =IF(AND(B3=B4,C3<>C4),"PRIORITY","") in column A and have been trying to use it as a helper...

Hey my friends, In results page of loto results in one websites, winning numbers are placed in a sentenced with commas. While i am copying them to excel, I want to have each number in cells along the row. Sometimes while copying start of sentence, i don't copy every time from same point so...

In Column B I have a number with multiple digits. The first part of my formula I want to round up to the next whole number, then if the number is greater than or equal to 18 place the number 18 in the cell, if the number is less than or equal 6 place the number 6 in the cell, but if the number...

<colgroup><col><col span="2"><col><col><col span="12"></colgroup><tbody> Name time begin time end weeks------ 1 2 3 4 5 6 7 8 9 10 11 12 John Doe restricted 2/11/18 days-------- 0 0 0 0 0 0 7 7 7 7 7 7 lost time 1/30/18 2/10/18...

I have about 20 columns of unsorted data, and I'm trying to record a macro that sorts (a-z) and removes duplicates without "expanding the selection". can someone point me in the right place? i searched but was unable to find. thank you!

='\\hinas1\mfg\QRQC\Auxilary\[QRQC A7 fy19.xlsm]OEE'!$G$11 Can the fy19 in the formula be replace with a cell location and full in whatever year i place into the cell?

Hello All. I have the following Code: Sheets("NonFormat").Select With Selection Cells.Select Selection.ClearFormats Selection.Hyperlinks.Delete Application.CutCopyMode = False Range("Z1").Select Range("A1").Select End With This is working in place of pasting special...

Hello friends, hope all is well! please help me with the code here please. Trying to place a custom footer, with a certain font size, but I keep getting the font size in the footer (i.e. 1228 - Aug - 2018 18:16:07) Please help me place only the date & time in the footer. Thanks a lot in...

I have been working on this VBA code but I keep getting the error '-2147024809(80070057)' The specified value is out of range. Not sure why. I'm trying to copy values from the excel sheet to a powerpoint presentation for an awards ceremony. Any help would be appreciated. I'm using excel and...