input

Good evening all, I have a two tab excel workbook. The first tab as a list of sequencial numbers (house numbers) in one column and a list of mulitple items across. The second tab is editable and i want to freely input house numbers in say A1,A2,A3 etc.. and a item description against each in...

I am using the following to sort an excel sheet: Sub Sort() 'Unprotect Worksheet ActiveSheet.UnProtect Password:=" cover700" Selection.Sort Key1:=Range(Selection.Address), Order1:=xlAscending, DataOption1:=xlSortNormal ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Password:="...

I am trying to build a spreadsheet macro, which is based on the below mentioned steps. 1) Takes the list ID number of a SharePoint form from the user via input box. 2) Creates a folder name based on this ID number (originally captured by the input box) 3) Retrieves all the attachments stored...

Hello people, I'm having a problem here, I'd like to filter the birthdays in the listbox and also know the "|" symbols. from the list and keep only in the .txt database. I would also like the EDIT, DELETE buttons to work. Follow the code so far and the download link. Thank you very much ...

Man I hope I explain this correctly... I use Excel for a purchase order log. Most materials have a set cost & I have a tab in my log with all materials and use VLOOKUP to input the cost of per line item entry based on the item ordered. However, I have 2 products whose prices vary depending on...

is it possible to specify the location of an inpout box? and how to I insure it is not opened behind oher windows?

So I would like to automatically run an auto filter when a wb opens. and this code does, but I would like the main screen not displayed. this code hides both the xls and the input box. Any ideas on how to only view the input box? Private Sub Workbook_Open() 'Setview...

Hello, I have a macro that is pulling data from a sheet Cycle_14a_Output.txt. There will be multiple sheets used for this project, all name Cycle_XXa_Output.txt. I've added an input box to ask what the number of the file should be. How can I add the Input Data into the formula string? <Code>...

Hi, I have two worksheets, named as A and B. I would like to assign two different password to A and B. And if the user input A's password, the worksheet A will be shown.. and same for worksheet B. Some cell values in B is referring to A, thus, I would like to make sure B also displays the value...

I'm having a massive problem getting an auto filling sequential number down a list of rows (column A). If one box has a value greater than 0 (column G)then I want to input a number (starting at 1). If one or several rows don't have this input I need that cell left blank, but need to keep the...

Hi Vba champs, 1 Need help for macro which should consolidate n number of Input files(all saved in "Input" folder) in 1 summary file 2.Each Input file has same format/ 2 tabs - 1-Input Details 2. Summary. Need each tab in Input file to consolidate(copy as values/No format copy) separately in 2...

Hi all, new to the group, but will do my best to make this as clear as possible. I searched up and down and couldn't find a solution to this problem. I have a macro that searches for specific trades that are listed within cells of an Excel spreadsheet and replaces the exported craft names with...

Hi guys..need help on vba for:-Have one consolidation file to consolidate data from different Input file.Column headers are same, Row data can vary for each file ( File path will be office shared drive):- [MENTION][MENTION][MENTION][MENTION][MENTION][MENTION][MENTION][MENTION]...

I am trying to get the duplicated input removed. I have a input form that a user can input a new serial number, however if it is a duplicate I need the program to remove it. The code I am using is as follows: Public clr As Boolean Public eRow As Long Public dup As String Private Sub...

Is it possible to have an automatic email be created when a button is pressed on a spreadsheet. I will need a box to come up asking for a reference number (which is in Column A). We this is input I need a set email address in CC (ie aa@aaa.com), To field to be blank. The subject field should be...

First, I appreciate any help I can get and thank you in advance for any help you guys/gals can provide. Here is my scenario I will have a page (worksheet 2) on a workbook with a Marco button and then A3 is the input field. The input is based upon data from the same workbook but different...

I want all cells in a worksheet to expand after every input as if you had selected them all, then double clicked the grid line to manually expand them. Thanks in advance

Hi Guys, I'm new to excel and I took up a time sensitive assignment assignment and I really appreciate any help on this. <tbody> Start date (input) Eligible Months (input) Age 50 (Input) Age 55 (input) Rule62 (input) Age 62 (Input) Leave end date 06/1/2019 12.5 7/1/2014 07/1/2019 09/1/2019...

Ciao All ~ Attempting to return the minimum value of a Range based on input from a Combo Box. Combo Box returns value in cell BM6 : 1,2,3,4 Set this table up to use Index/Match formula on : BR BS BT BU 1 S13:S49 W13:W49 AA13:AA49 2 T13:T49 X13:X49...

Hey Guys, I'm wonderng if it is possible to transfer data from exel vba to multipe HTML Input boxes? I would like to replicate the HTML Form onto an Excel UserForm which will be used to automatically generate data. I woud then like to have a button_click on the userform to transfer the UserForm...