input data

Good day All, I want to input a set of 3 data inputs and extract the results from a formula. The formula itself is linked with many sheets and other formulas and is restricted to 1 row only for the input and result. From the 3 data inputs of a row, I will receive 2 results that will change...

Hi there, Old thread I know, I'm having a little bit of trouble getting something to work. I'm also a bit of a novice, I'll admit. I'm trying to Populate a table, this I've succeeded in. Now however I need the information in a specific cell to be read and held against a portion of my table to...

Hello, I want to input a lot of data from a production batch into Microsoft Excel with version 2019. I want to search for an effective way to do it and to minimize any mistake from inputting at the wrong column, and to make the process a lot faster, because there's a lot of handwritten notes of...

Hello, I created the top half of the coding below to trigger an input box. What I'm trying to do is to use that result in the second half of the coding in the red text below. The box successfully appears and let's me enter the data then disappears. Nothing else happens. I have tried quotations...

I have a UserForm that asks the user to select a day (Monday, Tuesday, Wednesday...) and input a position. I want to direct this information to the worksheet called Data. I want to the position to be inputed in the row that is associated with the day the user selected for it. The current code...

Hello all! This is my first post on here. From what I have seen, you guys are enormously helpful. I thought I would put forward my questoin I have hit a wall trying to create a custom function in VBA. I am trying to find unique values in a list of copied values in some column. This is...

How can I create a command button that, when pressing it, will calculate the area of a rectangle by getting values from the user at run time with the help of two input boxes (one for length and one for width) and stores the result in cell A1. This should be done in Sheet4

Not sure if this is possible to do but I know excel can open a webpage with a hyperlink but is it possible for excel to also input data on a site then submit that data. For example say a youtube video i wanted to search i would set the hyperlink to youtube with what i wanted to search also so i...

Hi all and a happy new year! I am looking for help with a basic user form that has: 1x Combo box. 1x List box I need it to pull data from 4 columns on Sheet 1. If the combo box selection states "Factory" then it needs to pull the stated data below from the matches to "Factory" in Column I...

can any body help to change this form which works perfectly for inputting new data into a spread sheet to being able to edit the existing data in the spread sheet,scroll through the spread sheet to check existing data and still be able to add new data. Many thanks in advance. Private Sub...

hi i am new to vba i want to Update cells via a user form. user enter data in form and update in some cells like c5, c6, d5, d6, e6. e7. one more thing i want to show some data from the sheet on a user form. please help me... below given is code for 1st user form. Option ExplicitPrivate Sub...

I hope some body can help me with this code I have created a form and want to enter data into the form, the form needs to find the last row on a spreadsheet offset to the next row past data into several differents cells (all on the same row), clear the form ready for the next lot of data...

I would like to create a template for inputting 20 pieces of data on a weekly basis. The data will ultimately be presented on a seperate sheet with week 1 to 52 as column titles and the 20 parameter titles down the first column. For the input sheet I would like to have 20 blocks and a dropdown...

Hello All.... I have been working for sometimes on a workbook to calculate marks for my class. My workbook is comprised of 4 sheets. 1. Tools sheet, where I have a list of the various tools that a teacher uses in order to come up with a "Final Mark" for the term, 2. A sheet which summarises and...

Thank you in advance. I have a worksheet that I use to audit office locations for a specific organization. When I use it, a compnay may have 3 offices or 100 offices in the audit. I have a title page where I input data. My master file would have an additional worksheet with 1 office and all...