questionnaire template

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - How do I put a checkbox with no words? I am making a chart with names down the left column and other catagories along the top. I want to put checkboxes in so people can just check them individually for their cell in that catagory. I am wondering how to put the checkbox in without any words. (such as "checkbox 1") I want to remove the words. Tag: questionnaire template Tag: 801989
  - 2
    - Data Fields in Pivot Table I'm trying to write a macro that will clear all fields in my pivot table including the data fields. I have the following: On Error Resume Next Dim pt As PivotTable Dim pf As PivotField Sheets(4).PivotTables("PivotTable2").ClearAllFilters Set pt = Sheets(4).PivotTables(2) With pt For Each pf In .VisibleFields pf.Orientation = xlHidden Next pf End With The macro above clears all fields except the data fields. Any ideas for what I could add to the macro to make it also clear the data fields? Thanks. Tag: questionnaire template Tag: 801982
  - 3
    - Page numbers appearing across spreadsheet There are large page numbers ie. PAGE 1, PAGE 2 appearing across my spreadsheet - they don't appear on the print out, only on the screen. How do I make them go away? Tag: questionnaire template Tag: 801981
  - 4
    - Macro to Fit AutoShape over Range? It seems to me that inserting and manipulating AutoShapes is incredibly straightforward in Excel, but users of a form in our office have asked if there's a way to more quickly make rectangles that would EXACTLY cover whatever range of cells they have selected. (This is all the more annoying of a request, because most of the users are on Excel for Mac, whose Formatting Palette makes this sort of thing even easier.) Anyway: can a macro be written that will do this? I'm imagining that, after a user left-clicks and drags through any area, that they'll right-click, select the macro from the shortcut menu, and the code will plop a rectangle over the area. (I already have a number of custom options on the shortcut menu, so that I can do that part myself.) I know this is all absurd, but any help anyone can offer would be much appreciated! Tag: questionnaire template Tag: 801978
  - 5
    - Default Save Extension Posted in another excel newsgroup 7/11/08 but no solution: I'm using Office Home and Student 2007 on a Vista Home Premium machine. I'm unable to change the default save extension from xlsx to xls. I can do it on an individual file by file basis but I would like to have the program always save the files to a default extension of xls. I've changed the setting in Excel Options and the setting "sticks" but the program continues to create and save as xlsx. I also have the same problem in Word. Any help is much appreciated! Thanks in advance. Tag: questionnaire template Tag: 801976
  - 6
    - Error message - Errors were detected while saving FILENAME In Excel 2007, when saving a file, we get the following message... "Errors were detected while saving FILENAME. Excel may be able to save the file by removing or repairing some features" If we click continue, it gives us the file selection screen to "save as" Press enter, and we get "The file already exists. Do you want to replace the existing file?" If click "yes", the next message is "No errors were detected in FILENAME. No repairs were necessary" Click OK and it saves the file. I have searched newsgroups, but only find references to TrendMicro AV or MS Livecare possibly causing the problem; neither of which we have. Any help would be appreciated. Tag: questionnaire template Tag: 801970
  - 7
    - Cells not included in formulas I have a summary page that pulls numbers in based on account numbers from a detail spreadsheet. Column A is the account number, Column B is the amount on the detail spreadsheet. Is it possible to do some sort of trace function to see what numbers are not going into the summary worksheet? I haven't had this error before and there is not one amount that comes close to matching the difference from the summary sheet to the detail sheet. Hope this makes sense. Tag: questionnaire template Tag: 801969
  - 8
    - Database problem I have set up a spread sheet to keep a track of my spending. Column A is formatted to dd/mm/yyyy and columns B, C, D, E, & F are my expenses with column G being income and column H being the balance. I am trying to set up a seperate worksheet where a single cell will give me the total spending based upon a calendar month. Many thanks in advance for all those who have helped. Tag: questionnaire template Tag: 801968
  - 9
    - excel spreadsheet compare I looking for something I could utilize that would compare two excel spreadsheets. It would need to compare across all cells and note any changes. There will be text and numbers contained within the cells. I've seen some stuff posted on here, but it compares (I.E cell A1 to cell A1). The excel spreadsheets I'll be reviewing will have adds, updates and deletes. So it needs to compare based on a unique identifier (probably name in first column) and then note if there are any changes. Also, note if the data between the two excel spreadsheets is new or deleted data. thanks for any help you can provide.. Tag: questionnaire template Tag: 801965
  - 10
    - Exporting Quickbooks Data into Excel When I run a report and export it into Excel, the file size is way larger than it should be. It seems like when the file gets imported into Excel, there are thousands of extra lines that don't contain any data. I end up having to copy and paste the data into a new Excel spreadsheet. Does anyone know how to fix this problem? Tag: questionnaire template Tag: 801962
  - 11
    - Form a sublist from a list using lookup I have a table listed as follows: (A) (B) (C) 1) Name Region Age 2) John America 23 3) Lee Asia 42 4) Johann Europe 18 5) Tom America 43 6) Sara America 19 7) Ricardo Europe 37 I am trying to form 3 new additional tables for each of the three regions from this table that lists only Names of people over 30 yrs old (preferrably in a descending order). I thought of using something like =IF(AND(C2>30,B2="America"),A2,""), but instead of "", I would want the formula to look into the next rows until it finds one that fits the region, or if it finds none - then it should leave a blank cell. Otherwise, each of the tables would have many blank rows within, between the rows that are of interest. Any ideas of how this could be accomplished? Thank you very much in advance! Tag: questionnaire template Tag: 801955
  - 12
    - Formatting text within merged cell I am trying to enter a row of data in a cell that does not completly fill the cell and want to hit enter to enter more underneath without jumping to the next cell. Tag: questionnaire template Tag: 801949
  - 13
    - Unprotect workbook Using Excel 2007, how do you unprotect the workbook in an Excel 2003 file. The protect workbook function actually indicates it is not protected, but I know it is. Also, when I try to copy in a new worksheet, it says it is protected. Please help. Tag: questionnaire template Tag: 801948
  - 14
    - Commas drop off of number in mail merge to into Word Does anyone know why when I mail merge using Excel 2007 into Word why the commas drop off of the numbers shown in my columns? Tag: questionnaire template Tag: 801941
  - 15
    - Dating a file. What can I add to a file, that I send out periodically, to date stamp that version of the file? -- Matt S Tag: questionnaire template Tag: 801940
  - 16
    - Protecting Cells from changing or modifying long formulas How do I protect certain cells from being changed by other users because i have a long formula within the cell? The rest of the cell in the spreadsheet they can modify, except those particular cells. Tag: questionnaire template Tag: 801934
  - 17
    - Why does my cell content display as '############'? when typing text into a cell, the cell will display '#######' instead of the actual text I've typed. re-sizing the row/column does not help. Tag: questionnaire template Tag: 801920
  - 18
    - Sorting by name but ignore the word The I have a list of movies and I want to sort them by name then what stack there in. a b Gone with the wind | stack 7 The god's must be crazy | stack 6 Except I want to ignore the word "the" in the title but still have it in the title after the list is sorted alphabetically. Easy to do? Is there a way to hide the word and it will sort OK ? Thanks for any help, Rich Tag: questionnaire template Tag: 801919
  - 19
    - Displaying BOTH formulas and values Is there some easy way to display both the values and the formulas? I want to be able to show the results of the formulas as well as the formulas used in obtaining the cell results. I know I can toggle back and forth by using Ctrl+`, but for what I want to do I now have to display the formulas and copy the sheet as formulas into a new worksheet, then insert columns and copy over the results into adjacent columns of cells. Is there another way of doing this? Tag: questionnaire template Tag: 801913
  - 20
    - Timestamp for changes in any row of cells? Hi, I am trying to set up a timestamp at the end of a row of cells that will enter the current date if any cell in the row is altered or updated. I can only do it at present with one cell, if I use a range of cells the formula doesn't work, not sure why. The formula I use is =IF(R4="","",IF(T4="",NOW(),T4)) If I change the R4 to A4:R4 I get a wrong #Value. I'm running Office Pro Excel 2003 edition with SP3. Thanks for any help. Tag: questionnaire template Tag: 801910
  - 21
    - Place zeros in blank cells I have set up an Excel spreadsheet that will be used to input a variety of data that will be imported into an Access database. The data is all numbers and the reports that I run in Access can't do the calculations on blank cells. There are usually 1500 records that are being imported and there are 9 columns that contain numbers, but not all will have a number entered. What I need to find out is how to setup this spreadsheet to automatically place a zero in all blank cells prior to importing without doing it manually. The last time I did it, it took me about 20 minutes. Tag: questionnaire template Tag: 801908
  - 22
    - Cells won't automatically update --- urgent! Hello, We are having a problem with one of our excel templates at work, and we are on a tight deadline. The workbook is quite large....probably 50 to 80 sheets or so. Most of these sheets have been duplicated off of other sheets. The issue is that we have a bunch of valuation multiples linked to an assumptions page, and when we change the number on the assumptions page, the multiples do not update through out the template. We have tried a number of things. We have verified that the cells are set to automatic update in the options menu. We have also tried to go into a worksheet select all and hit F9, which you would think would update the cells. I have also, click on the specific that i want to update and hit F9, and nothing happens. The only way I can get the cell to update is if i put my cursor inside the cell, and hit enter. There is no way that I can go through every individual cell and update them manually like this. Plus we would not be too confident in the integrity of our template. I would consider myself a fairly advance user of excel, and I am quite familiar with using macros in visual basic. If anyone has an easy solution or a set of code that I can run that will update the template for me that would be much appreciated. Thanks in advance!! Ryan Tag: questionnaire template Tag: 801906
  - 23
    - Count I have a large spreadsheet dating back from 2006, is there a way I can search by a Detectives Name which is in Col K and then count the assigned offenses in Col G, example: Detective John Brown col k and then search col G, AA (Agg Assault) and give me a total for Agg Assault, then change col G for Burg (Burglary) and give me a total for Burglary, etc. I have been counting by doing a filter, but I felt there could be an easier way. Thanks, Tag: questionnaire template Tag: 801904
  - 24
    - Print Landscape/Portrait based on level of grouped data selected Probably not possible....but I have a spreadsheet I send to multiple clients where the rows are grouped on levels 1-5 (5 being the most specific of the data, therefore most rows). I have set up buttons (macro assigned) which they can use to print just their columns of data. The titles to the left of the data are repeating, so each individual macro is simply selecting the appropriate columns, setting print area, and printing. I find that levels 1, 2 & 3 of data look best when printed in Landscape. Levels 4 & 5 look best when printed in Portrait. Is there something that I can add to a Macro in order for it to print Portrait/Landscape based on the level of grouped rows selected? Thanks! Tag: questionnaire template Tag: 801902
  - 25
    - Integrity of Column Headers I have created a company form in Excel. The form has several columns and each column has a one, two or three line column header. The form was designed to be viewed at 100% Zoom (the viewing tool in the Standard toolbar). Apparently some form users are viewing the form at 50% or 75%. When viewed at less than 100%, the lines in the column headers break in odd places, for example, when the view is reduced, the one-line header "Quantity" breaks into two lines: Quantit y and the two-line header "Catalog Page No." breaks into three lines: Catalo g Page No. Other than increasing the size of the cells the column headers are in, is there a way to freeze the headers so this odd line breaking won't happen? I tried un-selecting "Wrap Text" in the Format Cells/ Alignment/Text Control menu and this made the headers be one line and the entire header wouldn't display in the header cell, so that wasn't the answer I'm looking for. Can someone help, please? Thank you for your help with my question. Leslie Tag: questionnaire template Tag: 801900
- Next
  - 1
    - Rotating on-call schedule M-F for 13 people? How can I create an on-call schedule for lunch time coverage that changes by person (13) everyday? Is there a way to do it in an Outlook Calendar? These people also have days that they can not take call due to a prior committment. Tag: questionnaire template Tag: 801892
  - 2
    - I am unable to unhide rows through the format menu. I have tried unhiding rows and my worksheet is not protected and the panes are not frozen. I have also tried selecting the entire worksheet to unhide, but I wasn't able to see all of my hidden rows. Tag: questionnaire template Tag: 801889
  - 3
    - HOW DO I CREATE A SERIES INVOLVING CELLS ACROSS ROWS? I'm trying to fill cells across a row. The first cell references C18, the next F18, the one after that I18 and so on i.e two cell are to be skipped to get to the next value I want. However, after i fill the first 3 values manually and drag the fill handle after selecting all three the next value to be filled in is F18, then I18, L18, I18 and so on. Is there a way to make the fill follow the series I want it to? The problem persists even if I fill 5 cell manually. Tag: questionnaire template Tag: 801886
  - 4
    - Preserved cell formatting We have an excell workbook that is linked to an extrenal SQL data source. The preserve cell formatting box is checked on the External Data Range Properties pop up. Randomly we will get cells were the format is being changed. The data fields that are being imported are text. The cell format is set to General and is being switched to Text. When this happenes the cell display all #######. I have been checking the data in the cells that this happens too for any odd charicters. (line feeds, char returns....) I don't see anything that would make this happen. It looks to be completly random. Any insight would be a huge help. Thanks Kevin Tag: questionnaire template Tag: 801885
  - 5
    - Need to find the name of the command buttons I inherited a spreadsheet that contains 11 steps kicked off by command buttons. I want the command buttons to be disabled as they are completed so the users will not run the same process more than once. I'm not able to find the names of the buttons to be able to reference them. Tag: questionnaire template Tag: 801884
  - 6
    - splitting my cell hey all i have a cell like the following: 1|2 can someone please show me how to put the 1 and the 2 in 2 separate columns? thanks, rodchar Tag: questionnaire template Tag: 801879
  - 7
    - List Dependent Worksheet Functions I am creating a summarising worksheet that evaluates a list of numbers. The list of numbers is held in a column of adjacent cells called 'ListVal1'. I wish to evaluate the numeric cells in 5 possible ways as determined by the user - the analysis could be any one of SUM, AVERAGE, MIN, MAX or COUNT. The user selects the analytical process by reference to a text value in a related cell - in this case cell 'B11'. The following formula works but is both cumbersome and has reached the limit of nested 'if statements' =IF(B11="","",IF(B11="SUM",SUM(ListVal1),IF(B11="AVERAGE",AVERAGE(ListVal1),IF(B11="MAX",MAX(ListVal1),IF(B11="MIN",MIN(ListVal1),IF(B11="COUNT",COUNT(ListVal1),"")))))) Does any one have a more flexible (less cumbersome) approach? Tag: questionnaire template Tag: 801878
  - 8
    - LIST BOXES TOO WIDE I created several drop down list boxes to limit entries in several fields in a worksheet. Two fields are limited to "YES" and "NO." When I click on the down arrow which makes the list pop up, it is a good 3-4" wide, with the YES and NO at the far left of the box. It is quite annoying to have to move the mouse so far to click the appropriate choice. Is there some way to limit the width of the drop down box? Thanks for ideas. -- William Tag: questionnaire template Tag: 801874
  - 9
    - Date value conditional formatting or Macro Hello The cell value is 00Y - 07M which is a date formatted as yy "Y" - mm "M". This column has over 1,000 numbers. What I want to do is if the first three values = E.g. 00Y - 07M then show only the last values or 07M otherwise it should remain the same Thanks Tag: questionnaire template Tag: 801871
  - 10
    - Multiple "IF" I'm sorry I didn't make it clear what I needed. E2 E3 61 E3 needs to be the total of E2. The numbers 0-3=0, 4-10 * 2.43, 11-61*1.75. 4-10 would equal 17.01 and 11-61 would equal 89.25 and the total should be 106.26. Any help would be greatly appreciated. -- LindaM Tag: questionnaire template Tag: 801870
  - 11
    - Import/export netCDF files to Excel Is there any way to import and/or export data files in net CDF format in Excel 2003? Tag: questionnaire template Tag: 801843
  - 12
    - Multiple "If" I am trying to write a formula that will multiple the numbers between 4 and 10 by $2.43 and add that to the numbers between 11 and 100 that is multiplied by $1.75. Example: A1 = 61 and the total in B1 would be 4 thru 10 multilplied by 2.43 and then added to 11 thru 61 that has been multiplied by 1.75 -- LindaM Tag: questionnaire template Tag: 801838
  - 13
    - Creating a Macro? V2 I don't know how to reply to a post and get it to come back to the top of the list so I am starting a new thread under the same heading. Sorry everyone. Pete and Gord responded to my original thread but unfortunately I was not able to get their advice to work. My original question related to a four page survey. The survey is posted on our intranet at work for people exiting our employment. Once they have completed the survey they activate the submit button returning the survey to our HR people. The survey contains four pages (worksheets) with the submit button on the last page (page four). When the submit button is activated it emails the workbook. When the recipients opens the workbook it opens at page four because that was the last page open and the one with the submit button on it. I want the macro to basically return the workbook to page one when the submit button is activated so that when the recipients open the workbook they see page one first and not page four. The VBE I am using is below and is one of Debraâ??s (I just wish I knew how to write this stuff, but I am learning a little bit, obviously not enough though) Sub Mail_workbook_1() Dim wb As Workbook Set wb = ActiveWorkbook If Val(Application.Version) >= 12 Then If wb.FileFormat = 51 And wb.HasVBProject = True Then MsgBox "There is VBA code in this xlsx file, there will be no VBA code in the file you send." & vbNewLine & _ "Save the file first as xlsm and then try the macro again.", vbInformation Exit Sub End If End If On Error Resume Next wb.SendMail Array("email.address"), _ "Exit Survey" On Error GoTo 0 End Sub Sorry this is so long. Cheers Tag: questionnaire template Tag: 801835
  - 14
    - Balance of pivot table data I need to maintain an in/out/balance table showing new cases, closed cases and the running balance each day. I have pivot table queries showing a running total of new, closed and live cases. Unfortunately not all dates appear in all pivot tables so I can't just do GETPIVOTDATA becuase there may not be a matching date. How can I select all dates up to the date in question? Example of what i have: Date Open 02/03/08 1 17/03/08 4 07/04/08 6 I want to show: Open Closed Bal Opening 378 02/03/08 1 2 377 17/03/08 4 0 381 Tag: questionnaire template Tag: 801833
  - 15
    - Macro - Fixed text code needs replacing with variable text I would like to change the below code so that all of the current fixed text typed "Sheet1" are replaced with a variable text and the variable text is equal to the ActiveSheet.Name I can see there are two parts too resolving this 1) the variable text will be only part of the define name and 2) the variable text in the formula entry within the define name Any help with this would be fantastic Many thanks Steve ActiveWorkbook.Names.Add Name:="Oracle_Travel_Sheet1", RefersToR1C1:= _ "=OFFSET(Sheet1!R12C2,0,0,COUNTA(Sheet1!C2),COUNTA(Sheet1!R12))" Tag: questionnaire template Tag: 801832
  - 16
    - Add a mark in every row in a column Hi, I need to add "," and a space in the beginning of every row in a column. so it looks like ", " in the beginning of the row. I've got 4000 rows so I would prefer if someone could help me do something that does this automaticly instead of doing it all manually Tag: questionnaire template Tag: 801829
  - 17
    - Grey bar at left side of worksheet Can anyone tell me what the function of the grey bar at the side of a worksheet is? i.e. it's name, function, how it is inserted, how can I edit. The grey bar appears to the left of the numbers in grey boxes at the left side of the worksheet. There are four small boxes at the top of this bar, containing the numbers 1-4. It looks like another column, but is grey like the number/alpha row and column. There is a dot, like a bullet point next to each number cell. This grey column/bar is appearing on reports I receive, but seems to change the worksheet so that I cannot sort the data by highlighting columns, clicking "data", "sort". I cannot left or right click in this area. Any clues would be really appreciated, thank you for your help. Tag: questionnaire template Tag: 801826
  - 18
    - Equation I would like to do the following equation in excel. Can anyone assist with the formula required to complete this is excel. x = a x 10^9e^ -b/(c+273.15) The following are variables: a = 2.8 b = 7.8 c = 60 b is a minus number Many thanks in advance Zephyr Tag: questionnaire template Tag: 801820
  - 19
    - What do I need to add to my macro to make the cell colors change What do I need to add to the macro listed below to make the cell colors change to yellow after 1 day change and to red after 2 days? Tag: questionnaire template Tag: 801818
  - 20
    - How can I transpose reference cells by Auto-fill? Hi Folks, for example, satrt from a reference =A1 then Auto-fill right (Ctrl+R), I can get =B1, =C1...and so on, is there any easy way that I could got the same result list in same column as: =A1 =B1 =C1 ... but Auto-fill down (Ctrl+D) as; =A1 =A2 =A3 ... What I'm doing now silly is to edit each cell =A$1, =B$1...copy...paste special...transpose... -- CKKwok Tag: questionnaire template Tag: 801815
  - 21
    - menu float Excel 2002 had a great feature of "floating" the fill colour and borders slection etc boxes on to the desk top. Does Excel 2007 have this ability as I can't find it? Tag: questionnaire template Tag: 801813
  - 22
    - how do i veiw 2 worksheets on dual screens Tag: questionnaire template Tag: 801810
  - 23
    - Data source name not found and no default driver specified I moved a database to another server and after updating the ODBC DSN to point to the new server I get the error: Data source name not found and no default driver specified. If I change the DSN back to the old server and put the old database back online, everything is fine. Change it back to the new server and I get the error. If I create a new worksheet and reference the data, it works fine. Any help from this group greatly appreciated! RBollinger Tag: questionnaire template Tag: 801805
  - 24
    - search for words with capital letter at end I need to search for a word with a capital letter at the end of the string. For example Hydrochloric acid 1M Ive tried using =IF(RIGHT(D18)="M","yes","no"), but it doesnt differentiate between lower case and upper case. Can anyone help? Thanks, Roger Tag: questionnaire template Tag: 801804
  - 25
    - Duplicate account codes that total amount This should be an easy one, but nothing is coming to me! I have an expense sheet where the user will list account codes and the amount spent for that code. They can enter the same account code numerous times. I then have a summary box that I want to auto populate the account codes used and the total dollar amount spent for that code: A B C 06000 50400 $15 06000 50200 $50 06000 50400 $26 06100 50200 $100 I would like the summary box to show the following: J K L 06000 50400 $41 06000 50200 $50 06100 50200 $100 I cannot figure out the formula that will combine the duplicates and then total the amount. Tag: questionnaire template Tag: 801801

I need a template for the following:
Type: Online questionnaire for clients
Format: Questions are a mix of Yes/No or multiple choice (some with more
than one answer selected from a list)
Output: All answers carry a weighting and total points are shown on a
sidebar as the client completes the questionnaire

The points per question are derived from a control benchmark database (not
visible to the client)

--
KAS

Top

RE: questionnaire template by Wigi

Wigi
Tue Jul 22 14:34:03 CDT 2008

This is not an Excel question since it must be online.

Try ASP or the like.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

"KAS1234" wrote:

> I need a template for the following:
> Type: Online questionnaire for clients
> Format: Questions are a mix of Yes/No or multiple choice (some with more
> than one answer selected from a list)
> Output: All answers carry a weighting and total points are shown on a
> sidebar as the client completes the questionnaire
>
> The points per question are derived from a control benchmark database (not
> visible to the client)
>
> --
> KAS

Top