Spreadsheet Setup - Creating Tick Box
Dec 23, 2010I have set up a spreadsheet but need to add a tick box, I just need to tick it once the item has been completed.
View 6 Replies
ADVERTISEMENT
How To Setup A Spreadsheet
Jun 26, 2008I am trying to set up a costings sheet for my other half. So far I have worked out his costs for this basics i.e. van etc. man power, days, mileage. He now wants to be able to enter his miles to a job, man power, days etc, Then to show total invoice cost and show profit i.e. if miles need to be changed.
View 3 Replies View RelatedMacros - Database Setup Using A Spreadsheet
Oct 1, 2008I'm not sure if this is something that can be done by macro, I have a database setup using a spreadsheet in Excel. The first column is a list of customer names, that can be filtered by customer name. If I filter the column, using for example the name Jones, is there a way to add up all the units of the product that they have purchased?
View 9 Replies View RelatedSpreadsheet Setup - Conditional Format Formula
Mar 7, 2013I have a small spreadsheet setup for my job where i have to input the time on arrival in L3 which is linked to a NOW() formula. this is it (=IF(L3="",NOW()
View 9 Replies View RelatedSetup A Basic Stock Control Spreadsheet
Feb 22, 2009I've set-up a basic stock control spreadsheet. Part of this requires updating prices of products. My approach was to use 3 columns A,B & C. C would show the current unit price of a product. Where there is a change in price this would be entered in A which would then result in a new average unit price to be calculated automatically in C. When ever this change occurs i need the then 'old' price which was in C to be shown in B aswell.
I've tried using various averaging formulaes but i'm thinking they were probably to basic or just plain wrong
Restrict Tick Cell Upon Selection To 1 Tick Per Row
Jan 10, 2007I was reading your Tick Cell Upon Selection article and it works great. I'm just wondering if there is a way to modify it so that they can only select one of the cells in a row.
For example, in this spreadsheet, the cells I have marked for "tick upon selection" are N8-Q8. In this worksheet, though, I only want the user to be able to select one of the four options. Is there a way to format the code so that they either cannot select another cell until they have deselected the first one, or the first one unchecks itself and the new click ticks that cell?
Example: Person selects N8. Person then selects P8. Can it not allow P8 to be selected (and give a warning message) or can it uncheck N8 when P8 is checked?
Creating Folders From Spreadsheet?
Jan 3, 2009I need some help, I know very little about macros but is it possible to create folders/directories to a certain path using the text in an excel spreadsheet cell? For example, if cell a2 has a street address and cell b2 has a city, can it automatically create a directory in the path of my choice using that data? If yes, can it go down the the rows and create directories until it is done?
Please help as I have hundreds of directories to create.
Creating CSV Files From Spreadsheet
Feb 21, 2010I am trying to create CSV files from Excel spreadsheet for each tab. But when I convert these CSV files, text in cell is limiting to 255 characters, in otherwords it is getting truncated after 255characters. I am using Excel 2003 version.
And also when convereted these windows CSV files to UNIX csv files using the command "DOS2UNIX", some charaters becoming special characters. For exmaple, I have the actual text as "If AEENDTC ne '' then do; " and is becoming "If AEENDTC ne æÆ then do; " Do you have any idea why it is doing this.
Creating Tables In Spreadsheet Won't Let To Insert New Row?
Apr 17, 2014sample worksheet Antligen.xls
I have a spreadsheet that I need to add new rows everytime I have a new client. I a formula in the N column and a formula in the F column that I would like to automatically insert itself into the new rows.
The problem is this: I have arranged my table so that I can look at clients alphabetically, and according to other date... BUT now it wont let me insert a new row when I have a new client!!!
Is there anyway of keeping it so that I can insert a new row into my table, but preserve all of the formulas that I want automatically put into both the F and N column?
Attached is the sample spreadsheet.
Creating Spreadsheet For Auction House
Apr 5, 2013I think I'm just missing something obvious here but I want to calculate commission based on £1 Plus 10% of Hammer Price. That bit's easy but I need it to ignore the hammer price if blank. In other words if I leave the hammer price empty, at the moment the sheet adds £1 to the commission cell.
In Summary:-
F3 is Hammer Price
K3 is Commission (=(F3*.1)+1)
K3 should NOT state £1 if F3 is empty
Creating A Staff Holiday Spreadsheet?
Sep 17, 2013Currently I'm working on functionality in my staff holiday spreadsheet and I've come up with this amazing idea for a calendar overview for month by month.Now the sheets I currently have is summary and jan to dec.
I plan on adding the sheets Jan (Cal) to Dec (Cal) now this is when my idea gets nifty - The calendar view will import the information from the month table and will show it on the calendar.
For example X has 1 holiday in July for the 20th - this will show up on the calendar as "x on holiday", I'm still working with spreadsheets so I'm not sure if excel is powerful enough to do this - but is this actually possible?
Creating A Text Analyzer Spreadsheet
Nov 5, 2013Is there a way to make a simple text analyser that will return the number of times each word is used in a sentence or paragraph within a cell?
I use excel to write short paragraphs to upload onto social network sites and I would like a formula or program that tells me how many times each word has been used over a number of cells, to avoid repetition. Is there a way to do this?
Creating Form On One Spreadsheet Then Pushing The Data To Another?
Aug 2, 2012I am a personal loans officer and have created a worksheet to input a range of information about an application. The information is personal details and details about the loan. The data I input runs down Column D [with line breaks to seperate the answers into categories] with the question beside it in Column C.
I do this for every new application as I use it for reporting on my loans as well as mail merge to produce documents for the loan.
Currently I am doing one per loan but would like to have a button at the bottom of the page that once clicked, it will push the data onto another worksheet so that all my loans for that month are on the one spreadsheet. The data will be pushed onto a row, not a column, but it will also need to find the next available row to put the data on.
Once the button is clicked, the first worksheet will clear ready for the next loan to input and the data will transfer to the 2nd spreadsheet. And, if possible, on the first sheet will be a drop down list of all the current loans so I can recall any application details to the first sheet if needed to update details. So if the 'loan number inputed' already exists, it wont create a new line on the 2nd spreadsheet, but will know just to update the fields.
Creating Database Excel Spreadsheet And Invoice?
Feb 9, 2014create an excel spreadsheet, where i can enter all my products name, unit price etc. so when i am doing an invoice for the customer, if i just type the product name price will show up automatically.
View 4 Replies View RelatedExcel 2011 :: Creating Button On Spreadsheet?
Dec 12, 2011In MS Excel 2011 for Macintosh can I assign a macro to an object, such that if the user clicks the object it runs the macro? That is creating a button on the spreadsheet that will execute a macro.
View 2 Replies View RelatedCreating Spreadsheet With Large Amount Of Data?
Nov 11, 2013I am creating a spread sheet with a large amount of data.
In column a I have a list of managers, in B I have a list of employees and C, I have a list of activities that have been recorded throughout the day.
What I want to do is create a list (on a new sheet) so in column A that would bring back all the managers. Then in column B, bring back the employee that is tied to the manager from column A and finally in column C, bring back the activity that is tied to the employee.
I know how I can do this by doing list validation with INDIRECT, but with the large amount of data that I have this would take forever in a day.
Is there an easier and quicker way to do this?
Creating Summary Spreadsheet From Two Seperate Spreadsheets
Mar 16, 2007I have two spreadsheets. I need to be able to match information from detailed spreadsheet for specific information from a lookup spreadsheet.
The detailed sheet (call it Purchases) has information about what was purchased during a month.
Columns: ...
Creating Button To Generate Spreadsheet From Exported Data?
Jun 9, 2014sample pic.png
I have two spreadsheets of data I export regularly from an outside source. I want to consolidate the data from these two sheets into one large sheet with all the data in a more concise form bringing in only the data related to certain parts I am conducting analysis on. I have a list of these parts already. My first thought on how to do this would be to use the list in an entry for an input box and have that list be the index for a for loop in which i searched for a part code, copied the entire corresponding row, and pasted it back into the master sheet. I have gone through and tried to do this but I am running into problems because sometimes I have multiple rows of data that correspond to a single part number. I have attached a template of the way that the data should look in the master file with the multiple rows of details that correspond to just one part entry.
Creating Curve With Multiple Values Already In Excel Spreadsheet?
Jul 11, 2013Here's the spreadsheet I am talking about : [URL]
So as you can see each row = one day divided in 2 cycles of 12 hours : every 12 hours the cat gets a new injection of insulin (the columns "U" being the number of units of insulin the cat receives)
Now I want to turn this sheet into two different curves that would look like these : [URL]
As you can see the first graph shows data based on days (x) and insulin dose (y), while the second curves shows data based on days (x), and blood glucose values (y). This is basically the only way we could clearly see how the cat's disease is evolving over a long period of time.
If he had just started to take all these values from his cat I guess it would be simple to do, but since he already has a lot of data entered in his spreadsheet, I was wondering if I could use this data (and not write each number in a new document), to make things a little more simple and to avoid mistakes.
Creating Spreadsheet - Figuring Cost Of Favorite Recipes
Nov 3, 2013I want to create a spreadsheet for figuring the cost of some of my favorite recipes. Right now I have a table of basic ingredients (milk, sugar, etc) along with cost of same.
What I want to do is be able to set up a recipe that calls for "3 eggs, 1 sugar, 1 milk" and automatically figure the cost for me.
Ideally, I'd like this to be a "building block" spreadsheet - where I can have a recipe for "roux" (1 flour, 1 butter), and then a recipe for "broth" (1 chicken, 3 water), and then a recipe for "gravy" (1 roux, 2 broth) - where the spreadsheet is smart enough to do the math for me - and if the price of chicken goes up, I can change that in my basic list and it will carry down. And obviously, I want to be able to add ingredients and recipes easily.
Creating Spreadsheet Utilizing National Vulnerability Database?
Mar 10, 2014I am creating a spreadsheet utilizing the National Vulnerability Database (NVD) from NIST.
I am successfully able to import the xml files and have the xsd mapped fine.
My problem is within each xml files for each records(1000s of records) there are sub pieces to certain record parts. I.e. software versions (that will be different per piece of software) however they will always fall under prod vendor
"
"
Excel creates a new row for each of these.
How can I make it only create the 1 row and comma seperate those?
Creating Payroll Spreadsheet With Dropdown List Linking To Values
Dec 3, 2013I am trying to attempt to create a payroll spreadsheet with certain aspects and with multiple worksheets. so what im trying to accomplish is this
1/ on my main worksheet would have the payroll template there would be 2 columns (1) would be "routes" (2) would be the dollar value of that route.
2/ i want to be able to pick from a drop down list in colume (1) which will have various routes such as A,
B, C, D, E etc
3/ once i have selected a route in colum (1) i want to have the dollar value that is associated to that route to show up in column (2)
ex/ route A worth $1
route B worth $2
create a dropdown list but thats about it, i have not been able to link any values together.
Creating Spreadsheet Of Dropdown Menus Each Affected By The Previous Choice?
Jan 11, 2014I am trying to build a complex equation that has multiple parameters filled by several choices from several different dropdown menus.
For instance:
I'm building a set of 5 dropdown menus, that each lead to filling certain boxes with a number created from a formula. I've provided a small sample to explain what I'm trying to do.
My problem is, I'm unsure of how to make it so certain drop down menus affect the information inside of the next. Like, I want to have someone select "Oscar" under the characters, and have the "Lances" list come up in the Weapons column menu. I don't want the Weapons menu to be selectable in any way unless a "Character" has been selected.
Getting Rid Of Tick Marks
Nov 28, 2008Some sent me a large spreadsheet with random rows throughout the spreadsheet highlighted in diffierent colors. I have a module that will sort the spread sheet by Color - however it doesn't work on this spreadsheet because - for whatever reason - every cell starts with a tick mark.
I tried to do a replace all - and excel just told me I was crazy.
I even tried going through and manually removing the tick marks - still no luck.
If I export the sheet in to txt and then re-import it I will loose all the highlights...
Tick Box In MsgBox
Feb 3, 2007I have this piece of code that shows a popup box when the excel spreadsheet loads up.
Private Sub Workbook_Open()
MsgBox "This spreadsheet can design both single-leaf and cavity walls." _
& Chr(13) & Chr(13) & "If only a single-leaf wall is to be designed:" _
& Chr(13) & "Deselect the cavity wall option and complete only the outer leaf input sheet." _
& Chr(13) & Chr(13) & "If a cavity wall is to be designed:" _
& Chr(13) & "Select the cavity wall option and complete both input sheets." _
& Chr(13) & Chr(13) & "All designs satisfy criteria within BS:5628-1:1992 Structural Use Of Unreinforced Masonry", , _
"Spreadsheet Information"
End Sub
Is it possible to place a tick box in the message box that says, "show this message again on startup", then if the user unticks the box the message is not shown again and if the box is left ticked the box will load up again on startup of the workbook????
Several Tick Boxes With The Same Macro
Jun 2, 2009I'm creating a form, that will contain 20-30 tickboxes. Each of these tickboxes will refer to a certain row on a seperate sheet. And it will either hide/un-hide depending on if it is tick/un-ticked.
How can I in the macro know which of the tick boxes that was ticked?
Using If Function With Tick Boxes
Oct 20, 2009I have created a Time Sheet for calculating the work hours of employees. There are various criteria which play a role in how work hours and wages earned are calculated (ex. time, over time, LOA, Travel time, stat holidays etc etc.)
In a certain cell I have placed a tick / check box which the user can tick to indicate that that particular day is a statutory holiday. The tick creates a True / False answer in another Linked Cell.
Based on the True / False result I have a formula which, using the IF function with multiple conditions whether the result is True or False, will calculate the hours worked for Regular, Time and Half and Double Time.
The Formula itself works but when I add the condition based on the check box - example: IF(c37=TRUE,...,if(...,if(...,IF(c37=FALSE,...,if(...,if(... and so on, only the TRUE option works. As soon as the check box is "unticked" I get the result "false".
I hope that all makes sense.
If it helps this is my formula... where C37 is the linked cell for the checkbox.
=IF(C37=TRUE,IF(B10<4.1,B11,IF(B10<8.1,4+(B10-B11),IF(B10<12.1,B10-B11+4,IF(B10>12,8,IF(C37=FALSE,IF(B10<8.1,0,IF(B10>8,IF(B10<12.1,B10-B11,4)))))))))
So, when the check box is ticked, the TRUE argument works fine. But when the check box is not ticked I get a "false" result.
Dropdown Box Format Tick & X
Feb 15, 2007Just put condition formatting on a cell that looks up to Windings tick & X
Now with the listing option in condition formatting
you get the option of a dropdown on the cell you are populating.. great but this is still in the worksheets standard font so shows as an O or P not a tick or X.. any way round this?
Tick Cell When Selected
Sep 28, 2007I would like to achieve the affect where if you click on the cell its contents will change. For example, if you click on it once, a checkmark will appear, but if you click on it twice and x and if you click on it a third time a - will be displayed.
I was thinking along the lines of a marco for the spreadsheet, which would run an if loop to check what was currently in the cell then change accordingly. Is there a command that would allow me to do this, or would is there an even easier way? side note how would I even display a checkmark of square root sign, through vba? This is what I have, It was working but now it does nothing and I cant remember what I tinkered with.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column = 6 Then
If Cells(Target.Row, 6) = "" Or Cells(Target.Row, 6) = "-" Then
Cells(Target.Row, 6).Formula = ""
Application.EnableEvents = True
ElseIf Cells(Target.Row, 6) = "?" Then
Cells(Target.Row, 6).Formula = "x"
Application.EnableEvents = True
Else
Cells(Target.Row, 6).Formula = "-"
Application.EnableEvents = True
End If
End If
Application.EnableEvents = True
End Sub
Check / Tick All Rows With Same Data
Mar 21, 2013So let's say I have a table like this:
Apple
Banana
Cherry
Banana
Durian
And when I tick one row:
Apple
Banana
Cherry
Banana
✓
Durian
The rest of rows of same values will also be ticked:
Apple
Banana
✓
Cherry
Banana
✓
Durian
I would like to have the macro/VBA for this.
This question was also posted at:
ExcelForum: [URL]...
MrExcel: [URL]....