input

Hi, Not sure how to do this but I want to have a cell display various message text depending the value input into another cell e.g. if value in cell D10 = 1 then in cell D8 I want to see the message Change if value in cell D10 = 2 then in cell D8 I want to see the message Pump Out I...

Hi. I have a User Form to add information in a data list. In some of the textboxes, I want the information to be added to the list in a certain format. For example: 1. the engine model to be all in UPPER CASE 2. the manufacturer to be in Proper Case, unless user entered all information...

I'm using the code below and today's date is pre-populated in the Input box. Is there a way to make it today() - 7 days? thanks! Sub DeleteFromDate() Application.ScreenUpdating = FalseApplication.DisplayAlerts = False Dim LR As Long LR = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row...

This feels elementary, but I figure this is the best place to ask. My starting value is 1000 and I would like to add 500 every x columns (dynamic based on cell input). Can someone help me write the formula for this request?

I have a workbook with 4 sheets. First sheet is called "Main" Second Sheet Is called "Heavy Used Belting" Third Sheet Is called "Medium Used Belting" Fourth Sheet Is called "Light Used Belting" On "Main" I have 3 categories and 6 buttons. The categories correspond with the heavy, medium...

Hi all, i am have a small issue with my excel function. my goal is if i enter a file name it outputs the drive letter is should be on. the problem is that all of the file names are numbers and i only want it to search the first three characters but it does not. my function is...

Hello everyone I want to input data in a table using userform. I have three tables in the worksheet and I want to enter data in the respective table based on user choice. Can anybody help me Please ? Please find the screenshot for clear picture. https://imgur.com/a/LFHle1z Thank You

I have the following code that is not keeping the same date format as the input. The input dates are in a date column and have mm/dd/yyyy formatting in the cell (e. g. 5/7/2019). The result after running the following m-code is 07/05/2019 in a general format. How can I get the output dates to be...

Hello Everyone, I want to take the input of the line number from the user . I want to run the operation from the cell range (A1:T100) (example) Taken input from the user (1000) concated to T1000 ( Cell = "T" & Uinput ) and used it in the Range("A1:Cell").Select But getting error. Please see...

Hello Everyone, I want to take the input of the line number from the user . I want to run the operation from the cell range (A1:T100) (example) Taken input from the user (1000) concated to T1000 (Cell = "T" & Uinput) and used it in the Range("A1:Cell").Select But getting error. Please see...

I have a form that different teams return to me giving their total hours spent each day on different activities. Currently some people for example 1 and a half hours work type 1.5 or some do 1:30. I wish to limit input to time format ie 1:30. However these totals can go over 24 hours. The cell...

Sorting Data (Numbers) Within a Single Cell I'm using a spreadsheet to input a series of digits into a particular cell. I want to be able to use formula 。 For example, I input the numbers: 21, 10, 37, 2, 5, 44 into cell A1; the numbers will be separted by a space not a comma (,). After formula...

Hi all, Sheet1 has product Bill of Materials: Sheet2 is for user to input Product & Tonnes in the INPUT section: I'm looking for VBA to calculate & return Ingredients & total Tonnes under the RESULT section. Thanks for any help in advance. Mark

A bit of help for a 'novice' please - I am preparing a workbook that will track financials acrsoss 18 months for multiple workstreams. Currently only a couple of months have actuals the rest are still forecasts. Please see below... <colgroup><col><col><col span="6"></colgroup><tbody>...

Hey guys We have recently switched to sharepoint online on the job. This has really messed up some of my excel work. I have especially two files which are now corrupted. One is the input file, and the other one is the data file which contains all data. The input file has VBA which opens the...

Have a work book with 12 worksheets - 1 per month called : Jan 19, Feb 19,Mar 19 etc I am trying to get a formula to read the next sheet in the series. I have it working fine when i manually input the next sheet number but would like say, Jan 19 to be able to calculate the next sheet name as...

We have a program we use for some work, its a exe file that runs in a dos window. It starts with a menu of 5 choices, and I would like to use excel to populate the menu choices, and also other operations. Is this something excel can do, or is there a better way? It would involve opening files...

Hi All, I'm looking for a data validation formula that can achieve the following: Only allow the input of a 5 digit number Don't allow the input of the 5 digit numbers in a list (The list is in cells F5020:F5045) Any help is much appreciated Thanks Tom

Hi, New here and I took over using a workbook at my company and I'm trying to learn VBA to make some changes. One of the issues is with this userform code that we use to add part order quantities, it works great except for it only inputs a whole number in the cells. As an example if I input...

Hi, In order to automate a site and get around using the date picker ive found I can remove the 'read only' part of the input on the site which allows me to input the date, however i cant seem to automate this. Im trying to change : <input id="fromDatePicker" placeholder=""...