Link A Dot Checkbox To A Particular Column Of Another Spreadsheet
Jun 14, 2007
I am doing a project and met with a problem with the excel spreadsheet.
will keep my questions short and sweet for easy reading.
i have 2 excel spreadsheet which i need to link up.
one has an option for you to choose your nationality eg. american /chinese
the option is done via a "dot" checkbox
once "american" is checked, and the name is entered at a column below it.
the name will be keyed into the 2nd excel spreadsheet under the "american column"
and if its checked "chinese", the name will be entered under "chinese" column which is also in the same spreadsheet.
>>i understand that once i keyed in more entries. i need to create a For...loop whereby the system will do a run-through to check for a empty slot, insert another row and place the data in the rows.
>>how do i link up and make sure that the computer will know when to put under the "american" column and when to put under the "chinese" column.
View 11 Replies
ADVERTISEMENT
Apr 5, 2009
I have separate check boxes on cells B12 & B18 respectively (which I have referenced to these cell via the Cell Link feature of "Format Control"). However, when I hide & then unhide rows 13 to 17, the Check box referencing cell B18 jumps to cell B13.
stop a check box from moving from its referenced cell ? I.e. anchor the check box.
View 4 Replies
View Related
Feb 6, 2013
Is there a way to link to cells so that one cell is populated with the others value if a checkbox is set to true?
In other words if the checkbox isnt selected the two cells would be as normal. If checkbox is checked, I want to enter data in one cell and have it show up in the other. I cannot use formulas as I use spin buttons on these cells as well.
I can get it to work with a worksheet change event but that is proving to be more buggy than anything I have ever seen. The worksheet change event is set to one cell but it the code executes if any cell is changed. This has happened before so Id rather not use the worksheet change event if possible.
View 4 Replies
View Related
Jan 8, 2010
I'm creating a spreadsheet which will have a grid of hundreds of check boxes (used to record progress on a project). In order to use the value of the check box in calculations, I'm linking each checkbox with another cell. So, if the checkbox is in cell F10, then i might link it with cell AF10, which is where the TRUE and FALSE indicators are.
If I copy the last row (which has checkboxes--let's call it row 99), and copy it below to expand the grid, the check boxes in the new row are still linked with row 99 cells (i.e., all the new check boxes in column F are still linked with AF99). So, presently I'm having to go through and manually re-link each pasted check box to a new cell.
Is there a way, using something along the lines of the INDIRECT function, where I can have a formula dictating what cell each checkbox is linked with, so that when I copy and paste a large number of these, they automatically point to the new cell (such that, F99's check box points to AF99, but if I copy this F99 check box into cell F115, then it would automatically be linked with cell AF115)?
View 9 Replies
View Related
Jan 25, 2012
I have a page that is protected so formulas are not changed mistakenly, and have check boxes on the paged that link to cells and display True of False based on the checking of the box or not. If I leave the page unprotected I risk the True or False being changed. Is there a lay to protect those cell from the user but still change when the box is checked or not. The checkboxes are Form Control type.
View 6 Replies
View Related
Jul 25, 2007
I have 2 workbooks open, one called "Temp" and the other called "CRM 2"
My active workbook is "Temp". I am trying to insert a value into the active cell in this workbook, based upon the value of a checkbox in the other spreadsheet. Here's my
If Windows("CRM 2.xls").SelectedSheets.CheckBox6.Value = True Then Selection.Value = "By Phone"
I've tried variations on this such as:
If Windows("CRM 2.xls").ActiveSheet.CheckBox6.Value = True Then Selection.Value = "By Phone"
View 8 Replies
View Related
Nov 17, 2007
created a Weakest Link type scoreboard in Excel, together with BANK buttons etc? I am a teacher and I think this kind of quiz will be great in motivating kids to respond eagerly to questions. I've done a bit of googling and nothing jumps out at me.
View 3 Replies
View Related
Jul 19, 2012
I want to copy and link every 3rd row of my spreadsheet into another worksheet
View 1 Replies
View Related
Jan 31, 2014
I usually use INDIRECT to link to a separate spreadsheet. Is there a way i can use this without opening the separate spreadsheet
This is a sample of the formula =VLOOKUP($F$14,INDIRECT('Data Files'!$C$17 & "$A:$Z"),5,0)
View 1 Replies
View Related
Jan 14, 2014
I have created a Vacation Calendar workbook with 6 sheets. All the sheets contain the 12 month calendar. Each row contains an employee and the columns are the days of the week. I have to keep track of 5 departments. I have 5 supervisors that are on different sheets that need to be included on the 6th sheet. I have set conditional formating to show that when I type "v" in a cell that is will go green. Is there a way to populate this information to another sheet without having to copy and paste?
View 2 Replies
View Related
Jan 23, 2012
Workbook 1 has 2 spreadsheets. Spreadsheet 1 contains Item and Pass/Fail Columns. under the item column is the serial number of the item tested. the Pass/fail column has the serial number duplicated if it failed tested. what is the formula is to have spreadsheet 2 pick the items from the pass/fail column on spreadsheet 1?
View 4 Replies
View Related
Aug 11, 2013
I have two spreadsheets, one gives me the beginning and end of civil twilight as a measure of day vs. night. The spreadsheet has Date/Time in the first column, and the value 45 in the 2nd column when it is night. The second spreadsheet has also 2 columns with date/time and body temperatures of a squirrel. I want to get basic statistics (mean and standard deviation) of the squirrel's nocturnal body temperature, that is for times when it is night (value 45). The tricky part is that Date/Time of both spreadsheets are different. The procedure has to recognize that the date/time of body temperature lies between the beginning and end of the value 45 blocks of the first spreadsheet.
files: twilight sheet squirrel temperature
View 6 Replies
View Related
Nov 3, 2013
I am working on Excel 2010. I want to find a way to link data from one spreadsheet to another one and whenever I update the first spreadsheet, the second one will be automatically updated?
View 2 Replies
View Related
Feb 25, 2009
married, widows, single checkbox is selected
macro solution
good work.
View 5 Replies
View Related
Sep 17, 2008
I am trying to have a checkbox that will hide any row between 6 and 300 say IF column P of that row that is empty, or does not contain the letter "Y", whichever is easier. I have found a bunch of different code snippets, but most hide a predetermined row range, and I need this to be dynamic.
If it can also expand the range automatically as I add more rows to the spreadsheet, that would be even better, but not necessarily required.
View 9 Replies
View Related
May 25, 2009
I would like to have a checkbox that when checked displays a column and when not checked hides the column.
the Column to be hidden will be on a page titled "Totals"
the checkbox will be on a page called "Roster"
the column to be hidden will be "Totals!M"
now for the real problem
I am using Excel 2004 for Mac. Which does not have a "control toolbox"
what should i do. I tried to do a macro but all that does is run the macro when the object is clicked regardless of if you are checking or unchecking.
View 9 Replies
View Related
Mar 8, 2008
I want the option of printing my form with and without a certain column. I need to hide a column when CheckBox.value=True and unhide a column when CheckBox.value=False
I keep getting errors:
Block If without End IF
End If without Block If
Else without If, when I use an else for the second If statement
Private Sub CheckBox1_Click()
Dim DescriptionCell As Range
Set DescriptionCell = ActiveSheet.Range("B:B")
If CheckBox1.Value = True Then
With DescriptionCell
.EntireColumn.Hidden = True
If CheckBox1.Value = False Then
With DescriptionCell
.EntireColumn.Hidden = False
End With
End Sub
View 3 Replies
View Related
Jul 4, 2013
How to get Excel to automatically link address to company names?
Background information
I have started making a database in Excel and added company names and adresses in two seperate columns. Later I checked for duplicates by pasting in the company names from a database I have made before. Now, about 50% of the company names remained and so I want to remove the duplicate company names and adresses from the first file without sifting through them manually.
Example
File prior to duplicate check/removal (tab called 'Database' in attached Excel file):
Company name 1 Address 1
Company name 2 Address 2
Company name 3 Address 3
Company name 4 Address 4
Company name 5 Address 5
Company name 6 Address 6
*used another database (without adresses) to check for duplicate company names*
File after duplicate check/removal (tab called 'Database (2) in attached Excel file):
Company name 1 Adress 1
Company name 3 Adress 2
Company name 4 Adress 3Adress 4
Adress 5
Adress 6
The idea is to make Excel automatically fill in the adresses from the companies that remain after the duplicates check from the tab called 'Database' on the tab called 'Database (2).
View 5 Replies
View Related
Apr 16, 2014
I have 3 checkboxes; when one is checked, a set/range of rows should be visible. Only 1 checkbox should be checked at a time.
If checkbox 18 is already checked, and checkbox 20 is then checked, I want the first checkbox unchecked and the rows for checkbox hidden.
I'm using the following code. It works great as long as I check and uncheck the same box before attempting to check another box. But if Checkbox18 is already checked with its rows showing, and I then check checkbox20, the checkbox20 sub runs and as I step through, it jumps to sub checkbox18.
How can I stop my subs from jumping from one to another?
Code:
Private Sub CheckBox18_Click()
If CheckBox18.Value = True Then
Worksheets("TRF").Rows("36:41").Hidden = False
Worksheets("TRF").Rows("42:64").Hidden = True
Worksheets("TRF").Rows("65:76").Hidden = True
CheckBox19.Value = False
[Code] .........
View 9 Replies
View Related
Jan 28, 2013
How can i hide and unhide column and rows using checkbox in the excel.
detail price qty amount
chair 1000 1 1000
some time i just want to see only the amount or some time i want to see the qty, how can i hide and unhide row or Column
View 1 Replies
View Related
Jul 30, 2014
I have a sheet in excel 2013
In column "Y" I want to add a checkBoxs activeX from cell 6 until cell 500
I don't want to repeat it 500 times )":
This is my code for a single checkBox
[Code] ...........
View 9 Replies
View Related
Feb 9, 2008
I need to work with the run times for some equipment. This is just hours and minutes and I get the raw data as like "Pump # 1 - 35:30". This is not date/time data per se, just a raw number of hours. I thought I would format the cells as hh:mm and for 15:00 I would just enter 15 to save time. No go, that becomes 1/15/00 00:00 and displays as 00:00. I discovered that if I just leave the formatting as general and enter 15:00 it works fine and displays right but the formula bar says 3:00 PM (Excel figured to format it hh:mm). When I enter 30:00 it again seems fine but the formula bar says Excel stores it as 1/1/00 6:00:00 AM (Excel figured to format it [h]:mm:ss but I deleted the seconds).
I can just set the formatting as [h]:mm to be consistent and enter the full 15:00 but I guess that after working that out I am just curious - can Excel store hours:minutes as just hours:minutes without turning it into a meaningless date? And without converting it to a decimal number? I don't want to total 1:30 + 1:45 = 3.25; I want the total to be 3:15. Again, it appears that [h]:mm will do what I need but it just seems unelegant to me that it is stored as some weird date and I wonder if it will cause a problem at any point.
View 6 Replies
View Related
May 8, 2014
I build a tool in excel to make an analysis per industry (30 industries). I want to compare the results on the first sheet, as a summary. All the information is now scattered over the sheets, but what I want to do is when you change the ticker in column A, it automatically retrieves the information from on of the sheets for the specific company. I will try to make myself clear to attach a screenshot.
So if you change ticker in column A, I want to fill columns C:D:E, G:H:I, K:L:M, O:P:Q, etc automatically according to the company name.
View 5 Replies
View Related
Dec 14, 2008
How can i hide and unhide one checkbox using another one? Can it be done using IF formula?
And also i am using this checkbox to function something else as TRUE/FALSE.
View 6 Replies
View Related
Jul 10, 2014
I have an MS Access Data link (parametrized query) set up in Column A. (Specifically A5:B85). However, every time I change the value in cell G2 (the source of my A5 result), the width of column A always changes. Is there a way for me to get column A to "freeze" to a width size of my selection?
View 1 Replies
View Related
Jan 20, 2013
How would you set up a macro to delete numbers in a spreadsheet in one column that appear in another column or worksheet?
In other words, if I have the numbers 1,2,3,4,5,6,7,8,9, 10 in one column and in the same column, or another column or worksheet I have the numbers 1,2,3,4,5 - I need a way to delete 1,2,3,4,5. I know how to delete duplicates via the advanced filter but I want to have the duplicate and original deleted.
View 3 Replies
View Related
Jun 23, 2014
I was wondering if it is possible to hide a column(s) but still have data in that column be visible at the bottom of the spreadsheet. For example, if I hide column G can it only hide the column from rows 1 - 50 and then the column will appear after row 50?
View 3 Replies
View Related
Sep 19, 2013
I have a long list of Titles in Column A. I want to be able to paste a link into Column B and it automatically searches the text next to it. I would like it to be simple. Something that is the same for every row, so I can bulk copy and paste.
View 13 Replies
View Related
Jun 23, 2014
I'm trying to create a dynamic chart title by inserting a text box in the chart title that displays the value of the last populated cell in column A. The number of rows increases over time, so I'm trying to come up with a dynamic cell reference. When I hover over the text box a tool tip appears with this text "TextBox 2" so I assume that is the name of the text box. I'm definitely open to other methods that do not use vba. It seems that none of this code can activate the text box:
Code:
Sub textbox()
Worksheets("Figure3-5").TextBoxes("TextBox 2").Range("A" & Rows.Count).End(xlUp).Value
End Sub
[Code]....
View 1 Replies
View Related
Oct 8, 2009
I am building a userform which also needs to display current data from a cell in the most recent row of a worksheet. This current data and all userform selections are then to be written to a row in a separate worksheet. I have not been able to properly reference the current data; My (rookie) approach intended to set the ControlSource properties of a TextBox to the desired current data.
Private Sub CommandButton1_Click()
'Begin form
' find last gps reading
Dim LastRow As Long
Dim Source As Worksheet
Set Source = Worksheets("Sheet1")
Set Dec = Worksheets("DecimalForm")
View 4 Replies
View Related
