user input

Hi, I am not sure if this is possible but I think if it is I might have to use VBA! Due to my lack of knowledge this will be a learning curve :eeek: This is what I am hoping is possible. When you enter a number into cell A1 it automatically fills out data below depending on the value. For...

Hello, I have a macro that uses the active cell to sort through data and fill the acceptable data into three new columns. I wanted to see if someone could help me create a button that prompts the user to select the active cell and then runs through my macro code. This would be very helpful in...

Hello all. I have scratching beneath the surface of Excel for a little while now, but I'm finally stumped and hope to find some help here from someone with a little more knowledge... I am trying to write a macro that prompts the user to change the date range in a pivot table report. My current...

Hi All I am trying to write a macro the autofilters based on the user's selection. Here is an example. Column A Column B Row 1 Snacks SN1 Row 2 Snacks SN2 Row 3 Clothes CL1 Row 4 Clothes CL2 Row 5 Drinks DR1 Row 6 Drinks DR2 The user would run the...

I have been using cascading data validation lists to standardize user inputs on a form we have at work. Sometimes, the input is a custom item that is not included in the predetermined table of items that the data validation looks up. I would like to allow the user to input whatever custom item...

Respected Members, First of all, I want to thank everyone contributed to this forum. So much I learned for you! Hope you can help me on below issue I searched on the net and here in the forum and found several suggested solutions. Yet, none of it worked for me! When I use function today()...

I would like to set up a spreadsheet that has links to other documents. I know how to create links, but I would like a link which contains a document location which can vary with a cell contents. for exam if the file names were Report wk42, report wk43, report wk44 etc. and the cell I wanted a...

I'm having a hard time getting this collection thing down. What I want this code to do is take the user input as a string and store it for use later when the For-Each code is run. I'm not having any luck so far and its probably because I'm having trouble wrapping my head around the concept...

Hi - am developing a macro for users to use and need help refining one part of it. Essentially, the user selects a cell, then clicks a button to run a macro. This is the "From" cell. The macro then needs a "To" cell address to be able to complete. I have got it working using the following code...

Hello, I am trying to build a macro that will search a column for the word "TEST" and when it finds that word it needs to prompt the user with a YesNo message box (or something similar) if they would like to delete the entire row that contains TEST. If Yes is selected, it should delete the row...

Hello, I have form that prints 3 to a page. I need a macro that will allow the user to input how many pages to print and only print those with data in them. Sometimes there might be 2 or 5, etc... I was thinking that maybe using "case" might work? Thanks, Julie Form example: <TABLE...

Hi all, I'm trying to make a worksheet to help me size the parts for cabinet doors. I've made it functional but I was trying to make a bit faster to enter the data and this is where I got a little stumped. Every door has 2 Rails (horizontal pieces), 2 Stiles (vertical pieces) and one raised or...

Hello, I am trying to re-lable the first column of data into sections, usually 60 sample increments, in order to post process all of the samples that are contained within the recorded section. So I have a worksheet with column showing test step = usually ranging from 0-10 and the data recorded...

I don't know much (anything, really) about VB, but I'm usually pretty good and finding relevant code online and adjusting it to my needs; but today, my brain is not cooperating. Please help :) I have a worksheet and in cell B2, there is a data validation list, allowing the user to select...

I am a complete newbie when it comes to writing macros, but I was wondering if someone would be able to help me? I want to click on a button (I know how to assign a macro to a button) and have a macro run that asks me which row numbers to hide and then pop up a print dialog. Is this doable? I...

While I have been able to resolve just about everything through the genious guidance of the fine minds on this forum, I just cannot resolve, nor find a solution to this seemingly simple issue: I am trying to allow the user to specify the 'age' of a record to obtain a list of aged loans. I have...

Hello everyone -- I am new to VBA (four days now) and have put together a relatively simple macro that creates a pivot table. I have found that I can select one of the options in the .xlPageFile (which are dates i.e. 11/17/2011, etc.) by using .PivotFields.CurrentPage = "nnnnnnnn" which is...

I am developing a student grades report on excel for my students. I need to accept a number from the user(the number of students in the class) and allocate so many cells for various fields such as name, age, grades. To calculate grades, I need the formula to be automatically copied to as many...

Hello All!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Awesome forum!<o:p></o:p> <o:p></o:p> I am trying to create a tool to help with some calculations we do all the time. Every time we design a new product, we need to do several...

Hi all. This may be around somewhere in the forums, but I appear to be searching incorrect key words. I have a range of columns (I:AQ) that a user can freely use to enter quantitative data. Each column represents a province of Vietnam. Column AR contains qualitative data (comments) that...