user input

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...

Hi. I have a question and need to suggestion as well. I have a template in excel that I need to follow so I can't change or add any column. My problem is in column H I have the formula Vlookup. However, sometimes users also need to input different data in the column H as well because column H...

I have a worksheet that includes user input regarding the number of months required for the cash flow. I want the cash flow spreadsheet to automatically adjust (contract/expand) the number of columns pertaining to the number of months in the cash flow (the months are listed on the top of the...

I have a worksheet that includes user input regarding the number of months required for the cash flow. I want the cash flow spreadsheet to automatically adjust the number of columns pertaining to each month in the cash flow (the months are listed on the top of the speadsheet). I cannot find out...

I am trying to put together a macro that waits for the user to input data and then continue running the macro. All user input is for one cell and I am looking at more of an entire sheet worth of data. Here is the scenerio. I have one tab that pulls data out of a sharepoint list. I then have...

Not sure if this is possible... Can I set validation on a cell to only allow user input if a separate cell has a particular value, otherwise the cell has a default value of 1? For example, the narrative formula would therefore be something along the lines of: If a1 = "POD" then b1="1" else...

I have several excel tools that use pivot tables to get and process data from Access. THese tools have multiple (many) pivot tables. This becomes a burden when I need to refresh the data in the pivot tables. so I use the macro Sub Refresh_All_PT_WS() 'Refresh all pivot tables active...

Hello, I have a VBA-Crossword Puzzle for those who like them. I am looking for a way to have two user input boxes pop-up upon opening the workbook, and depending on their selections, direct the user to the appropriate tab (worksheet). If it easier to have it done with one input box, then that...

Hello, It been awhile since I have ask for help and come to the place where the macro genuises reside. My question, (I thought would be an easy one to search for but I guess my key words do not work) I want a user input box to pop up when a workbook is open and depending on the user input...