I've created the form and formatted everythig as I need it but now I am clueless how to make the command button (enter data) post the data to the appropriate cells in my spreadsheet. I especially need the data to find the first empty row so that it doesn't overwrite the previously entered information.
View 11 Replies
once I get the pretty boxes and such, how do I link this form to a sheet to record data? How do I get it to run? I have tried searching the forum, but it seems that most of you already know that part and don't have any problems there.
I know this is probably very very basic and I will smack my face with my hand when you point it out. I just have never created forms with Excel before. I am used to using SalesLogix and when I create forms there, I have a database table that I can link each field to, so I keep looking for how to link to the table and I can't figure it out.
I have a spreadsheet in which the user will respond to questions using "T" for "True" or "F" for "False". If there is a certain number of T's I would like the macro to take the user to one sheet in the workbook or if there are a certain number of F's I'd like it to take the user to another sheet in the workbook.
View 2 Replies View RelatedI am looking to connect 2 form control boxes and have the second box run 2 different types of macros. The first box will have only 2 options - select by week and select by month.
The second box should show the list of weeks or months based on the selection in the first box. Then for the second box, if weeks is shown, a week macro should be run whenever a week date is selected. Similarly for the list of months, a month macro should be run whenever a month is selected.
I have been trying to do this for more than a week (after posting on this board) without success. I apologize if this seems like a duplicate post.
I'm trying to link two combo boxes via a user form. I'm trying to select a city in one combobox which in turn would provide a listing of zip codes for that particular city in the next combobox.
View 6 Replies View RelatedI have an excel that has dropdown column from form control, in F4 there is a formula of vlookup that take the range from A2 to B20 in consideration but the reference cell that is given to vlookup formula to pick corresponding value is E4 which is also the reference cell of dropdown box and therefore its not showing any name rather than a value, problem with the formula is that when we select any name from dropdown it does not respond to any value in F4 despite changing values in E4.
I am using these setting for the first time.
Image & excel file is attached
drop down.png
Is it possible to have a user form command button perform link or steps that are recorded with macro recorder? I am trying to reformat cut and paste a xls raw data file. I am trying to keep my file uploads to a min., but can upload an example if necessary.
View 4 Replies View RelatedI'm missing something in my UserForm initialization code. If I fill the form out once and click 'OK' (run the code to put the form data into a sheet), when I go back into the form all the old info is still there. If I then click 'Cancel' (Unload Me) and reopen the form, the old data is cleared out. What am I missing to make it clear it out the first time?
View 2 Replies View RelatedI have set up a form where the user can enter the number of copies they want for 10 items (I will call them item1, item2 etc for ease)
Is it possible to then link the numbers in the form to separate parts of a large printing Macro?
I have created a form where people will take a survey, and the responses from that survey will be carried over to another worksheet that will analyze their results.
For each question in the survey, I want them to choose only 1 of 2 responses. For example:
Place and X next to the statement that describes your opinion most often:
__ I prefer to work with others.
__ I prefer to work alone.
The responder will choose either the first or second response, but I do not know how to limit it so they can't answer both. I want a way to limit the worksheet so if they type an X in the first field, they are unable to type one in the second field, and vice versa.
Is there any way to limit the responders ability so that if they choose to respond to the first statement, they are not able to also respond with the second statement, and vice versa, while not affecting the results page that uses the IF formula =IF(sheet1!A8="X","X","")
how to create a progress meter based on yes/no (completed/not completed) responses? If 2/10 responses are completed, then the progress meter would display 20% or 20% of the bar would be red. Is this even possible in excel? I've used conditional formatting to create a progress meter but can't figure out how to make a progress bar based on responses.
View 1 Replies View RelatedI have recorded the data from 12 records (i actually have hundreds, but im just using a small sample). Each record is represented by a vertical column. I want to find the total number of "x's" for only the records from Country1 (from all the answers). Then I want to find the number of "x's" from only Country2. I have tried the "countifs" function but cannot find a way to make it work. Would a different array function be better? How would I write it?
P.S. The answer for Country1 should be: 15.
The answer for Country2 should be: 5.
I conducted a survey and want to tabulate the results in excel. There is a lot of paper, so I want to list each answer on the spreadsheet and have a button next to it to tabulate the responses instead of doing it by hand. When I look at each survey, I want to click the button for the corresponding answer. I want to have excel tally/increment each response each type I click the button.
So what macro do I need to assign to each button in order to do this? Or can I just click on a cell and have it increment? Or what can I do to achieve this?
My attempts have given my circular reference errors, or if I do the iteration thing (tools, options, iterations), excel increments EVERYTHING in the spreadsheet by one instead of just one specific question.
I have worksheet1 with 200+ customers and 12 months of data for each customer. I want to link each month to a separate worksheet (worksheet2, 3....12) for all customers. (i.e., customer 1's January activity across row 1, customers 2's January activity across row 2.....)
Is there a way for me to create a formula or copy comand to link row1, worksheet1's data to row1 worksheet2 and then every 13th row in worksheet1 to row2, row3...in worksheet2?
Right now I'm just putting the = in worksheet2 and mousing over to worksheet1.
As part of an audit program I have a questionnaire. One of the questions has 10 check boxes, one with a combo box and one with a text box. The user will check at least 2 or more answers, but not all 10. (2-4 average). I don’t want to link the answers to specific cells, because I don’t want the answers to display with blank rows between answer on the sheet. I want the answers to display in 2 columns evenly distributed.
I would prefer, to not have to run a macro, if possible, but the only way I could see to do this is a very long if statement base on every combination of answers. If the only way to do this is thru a macro, I would prefer to tie it to the printing of the sheet, or I could make it part of an error checking macro I plan to do. The actual question is in the attached file
I would like to generate a dynamic list of the top five most common text responses in a range. For simplicity sake, let's assume that the range spans cells A1 to A20, and the list is generated in cells B1 to B5. So, essentially, I am seeking five separate formulas. One to calculate the most common text element, one to calculate the second most common text element, one to calculate the third most common text element and so forth.
I am currently working with the two formulas below but finding it incredibly difficult to merge them into a working format.
Formula for finding second most common number:
=MODE(IF(IF(A1:A20"",A1:A20)MODE(IF(A1:A20"",A1:A20)
),IF(A1:A20"",A1:A20),""))
Formula for finding most common text element:
=INDEX(A1:A20,MODE(IF(ISTEXT(A1:A20
),MATCH(A1:A20,A1:A20,0))))
I am running excel 2010 with windows 7. I created a macro in sheet 1 and I wish to activate the macro from sheet 2 using a form button. I have entered the code below. I know how to perform this function on a more simple macro like adding names to cells. This code is a bit more complex I just dont know where to start.
Code:
Sub LoanData()
'
' LoanData Macro
[Code].....
Writing the code to assign a button so when I click it it types or pastes a short response on the body of a reply message or where I place the cursor.
View 5 Replies View RelatedHow can I link 2 sheets in excel? If I have 2 different rows in 2 different sheets and want to calculate the difference between them (THE ROWS), i.e. On one sheet i have a number lets say 4 and on the other sheet I have 8. On one of the sheets (doesnt matter which one) I want to calculate the difference which in this case is 4. And automatically when I change one of the numbers the difference also changes automatically..
View 5 Replies View RelatedI have a workbook that I am trying to get easier to work with, I have sheet 1 that my product codes,cost,mark up % and amount sold etc. and I have sheet 2 that has suppliers order No's, Cust name/email etc. and the At the moment in my example I manually hyperlink AE2 in sheet 1 to A2 in sheet 2 - and I manually copy cells P2 & Q2 in sheet 1 and paste link into E2 & F3 sheet 2.
I want cells E2 & F3 in sheet 2 to automatically link to their corresponding cells in sheet 1 P2 & Q2
Can you link a cell to a sheet tab. If yes how?
View 4 Replies View RelatedI have a sheet with a bunch of company information, Name, address, phone, email, etc.
On another sheet I link back to this sheet with =DATA!A1 and copy down.
Although the cell that has the email address on the DATA sheet is a working link to open Outlook, it does not give me that link when brought to the second sheet.
Is there a formating tip or something else that will do the trick. I have looked though searches and all I could find is creating Hyperlinks. I don't think that is my answer because on my Second sheet I will be coping from a different set of cells the next time I use this workbook.
Is it possible to link a sheetname?
I have a list of employees on sheet1 and each employee has there own sheet with their name as the sheet name. Each sheet contains a form that the employees need to fill in.
I have created several extra sheets for new employees and I would like these sheet names to be linked to a cell on sheet1. This way the only updating I need to do when receiving new employees is enter there name to the list in sheet1.
how I can use a hyperlink to access a particular sheet of another workbook? for eg, I have 2 workbooks, A and B.' A ' has a set of 15 hyperlinks. When I click the first link in 'A' it should open sheet 1 in 'B' and when i click link 2 it should open 'sheet 2' in 'B'. How can I do that?
View 6 Replies View RelatedI've created a chart in sheet 1 in a workbook. I want to copy and paste that chart into another sheet (lets take sheet 2) of the same workbook. I am using Excel 2010 version.
Whenever, I try to copy a graph and want to do "Paste Special as Link picture". The problem I am facing as "Paste Link" option is inactive.
I am attaching the Excel for your reference.
i have attached my sample spreadsheet that i need to have a code to link to specific cells value.
whenever i click on the command button on beside Activation 1 it will go to Activation 1 sheet/tab.
Project is shared, cannot use vba.
I have in A2 - A12, The names of different sheets in the workbook. I would like to create a link so when a user clicks on the cell, it will take them to the specified sheet.
Lets say cell A2 contains the text '1208', when pressed I would like it to open up the sheet 'A1208'
So I have a set of data in my sheet 2 that I want to be connected to sheet 1. The data in sheet 2 looks like this,
NO
Reaction
H
S
1
2Fe2O3 + 3C = 4Fe + 3CO2
105690
120.21
2
Cr2O3 + C = 2Cr + 1/2CO2
218,085
59.24
while in sheet 1,Reaction No
Carbothermic Rxn
H
S
What I want to do is that when I put a reaction no (e.g 1) at the empty cell next to the label Reaction No, the data in sheet2 (i.e. Reaction, H and S) would automatically be reflected in the empty cells next to Carbothermic Rxn, H and S.
I have created 10 Hyperlinks in sheet 1. And all these links in the same sheet. When i copy the same sheet to sheet 2, the sheet 2 hyperlink is related or is reffered to sheet. Is it possible that when we copy teh sheet to next sheet, the hyperlink also gets copied with the sheet number
View 2 Replies View RelatedI'm trying to open a web link from my excel sheet in Mozilla firefox. But each time I try to open the link it opens in Internet explorer eventhough I've set mozilla as my default browser.
How could I write a code that would open the link in mozilla firefox.
