Excel 2013 :: Unable To Create Data Form?
Feb 7, 2014
Excel 2013 on a surface tablet and attempting to create a data form. I've followed the necessary steps to try and add the "Form" button to the quick access toolbar, but "Form" is simply not a listed command. Have looked in "All Commands", "Commands not listed in the ribbon" and "Data Tab" and it's nowhere to be found. Not greyed out, just not there.
Frustrating because it's so easy to create a form on past versions of excel. All the tutorials I've seen online explain how to add "Form" to the quick access toolbar
View 1 Replies
ADVERTISEMENT
Jul 14, 2014
I have been attempting to enable the developer tab in Excel 2013, and have been unable to do so. When I check the box for the Developer tab, then click OK, the ribbon flickers, as if the tab is being added, but then the tab does not appear. When I go back to customize the ribbon, the check for the Developer tab is again not checked. I have also tried to move things around to different tabs and none of the changes stick.
View 9 Replies
View Related
Feb 7, 2014
I just discovered forms in excel and loving what custom functionality you can create with it; however, I need to include a table into the form but I've come to a road block. I don't see a way possible to render data from a query into a table inside of a form.
PS - I'm using Excel 2013
View 1 Replies
View Related
Jul 22, 2014
I have an Excel 2013 address book that has extra spaces between first names, last names and middle initials all in 1 cell.
Is there an easy way to remove all the spaces between these components?
View 3 Replies
View Related
Sep 20, 2007
I am trying to create a form to use as a golf tracker. I basically have created a scorecard where I input the date, score, fairways in regulation, greens in regulation and putts. I want to be able to put that information just like if it was a scorecard and then have a button that says submit. Then that information is output into individual sheets (i.e. one for scores, one for fairways, one for greens and one for putts).
View 13 Replies
View Related
Feb 13, 2014
I was given a spread sheet that prepares a file for export to some ones system. The macro in the spread sheet wouldn't run as I'm using excel 2013 which when you open a new work book it only opens sheet 1 and there was a bit in the macro that wanted to send information to sheet 2 which wasn't there. I added a bit of code which created sheet 2 and hey presto it worked fine. I made the mistake of telling the people who supplied the original workbook to me what I had done so that they could pass the modified sheet on to other users in case they had the same problem.
Now I've been asked if I could do a bit more work to the existing macro so that instead of the new workbook just being called Book 1 could I add a name and date to the new workbook being created.
I've had a look at the original code and it looks like it would be quicker to start from scratch as I cant follow the original code.
The existing workbook has 3 sheets, I want to copy sheet2 to the new workbook. I want to name the new workbook as "a fixed name" with the "time and date " .xlsx
View 9 Replies
View Related
Jul 21, 2014
I have the following data set with about 500 rows. It has one large value in column A, followed by a number between 1 and 24 in column B.
I am trying in Excel 2013 to develop a formula that will: divide A by the value in cell BPlace in cell C, D, E, F... the result of this division, where the number of times the value is repeated depends on the value in B. E.g.
Example of source values/data set:
A
B
18504
18
2011
2
23694
24
(about 500 rows more)
An example of the output result that I am looking for:
A
B
C
D
E
2011
2
1,005.5
1,005.5
In above example, the value in column B is 2, so the result of the division of value A with value B is repeated twice. In case value B would be 18, the value would be repeated 18 times...
I have been trying to do this in Excel for more than 2 hours, but I did not manage to complete it.
View 2 Replies
View Related
Jul 23, 2014
------ A ------------------- B
John123@gmail.com--------Blue
Bill323@gmail.com ---------Red
Sue223@gmail.com -------Green
Sue223@gmail.com -------Yellow
Bill323@gmail.com ---------Red
Bill323@gmail.com --------Yellow
John123@gmail.com ------Yellow
Sue223@gmail.com --------Blue
- C --------------- D ---
John ------------Blue, Yellow
Bill --------------Red, Yellow
Sue------------Green, Yellow, Blue
I am using Excel 2013 on Windows 7. In the above example columns A & B is the given list to process, and Columns C & D contain the result I am trying to achieve. The major part of this that I am having trouble on combining, separating them with commas in another cell, and ignoring a duplicate value. You can see bill has two red values, but I only need it displayed once in column D.
View 4 Replies
View Related
Dec 24, 2013
I am trying to create a form in excel that simulates a chess board, the code was quite extensive so I better separate it into modules, because the program suddenly began to close, how do I do that? being that I have all the pieces of a chess game and some strings and boolean variables with information on the positions of the pieces on the form?
VB:
Private Sub A1_Click()
If Turn_Player1 = True Then
If Active = "Pawn_pr1" Then
If Loc_Pawn_pr1 = "A2" Then
[Code] .....
View 1 Replies
View Related
Feb 9, 2014
I am trying to graph the amount of calls that come in on each day and at what hour. I am trying to put the days of the month along the x axis and hours along the y axis. I then want the number of calls to show as a scatter at certain times on each day. Is this possible? I have attached a sample of a table I will be working with that has made up data on it. I have tried using the select data function to try and change the axis, but I do not think I am writing the correct things in.
View 4 Replies
View Related
Nov 4, 2009
How can I create a form from data that I have in an excel sheet? Would I need to import it into access or can I do it from excel?
View 9 Replies
View Related
Jun 27, 2008
I would like to make a form where a user can fill in information in an easy to ready format, then click a submit button, and have the data moved to another sheet or file from where the data can be merged into another document. Each time the user fills out the information and clicks submit, a new line of the data is created in the destination. Here's a picture to show what I'd like to do:
http://i305.photobucket.com/albums/n...r5/example.gif
View 14 Replies
View Related
Jun 18, 2014
vba in excel 2013 pivot table that updates from an online CRM rows are a to h and it can be any number of rows. What I am trying to do is track progress. In column f values indicate probability for success 10 25 45 90, which can go up or down. The pivot table is refreshed to get the latest values from CRM. the update is handled by a connection to the crm not in the vba.
So far I been researching methods to conditionally format values that went up, down or remained the same since the last refresh with up down and across arrows. I have managed to piece together what I think should work but alas it is not. So I have come to you internet.
My code first clears any formatting and goes down the column avoiding null or empty cells, comparing the values in column f to values in column j.
I have 3 conditions greater than, less than or equal to, and would like add an icon for each based on the result of the comparison.
Finally when it finishes the column the code copies the current values in the pivot table column f to column j outside the pivot table which i hope to be able to hide once the cf works. The code is below
[Code] .....
View 1 Replies
View Related
Mar 12, 2013
IIn my example I have result data from the 2013 USPGA Tour, ordered by player (column A) with subsequent columns detailing their finishing position in each event.
I simply want to condense each player's performance data into one row - as doing it by hand after each event is very time-consuming.
Is there a way of using a simple formula, macro or pivot table (or whatever) to merge each player into one row, but keep each column in the same position (ie to correspond to each weekly event).
View 4 Replies
View Related
Apr 21, 2014
I just copied a table from the web which contains numbers in the last column.
I pasted the data into Excel, but when I try to run any type of calculation i receive a #VALUE! error.
The annoying 'workaround' is to re-type the same numerical text into it's own cell, which allows for calculation.
I've tried changing the cell formatting to 'general', and 'text', but I still receive the #VALUE! error, when trying to calculate.
View 1 Replies
View Related
Apr 19, 2008
Very simple Excel 2007 spreadsheet. It consist of four columns with either numeric or alpha data in the. No formulas, no macros etc...
She emailed the spreadsheet to me and it works fine, I can enter data without problems. Whenever she tries to use it she just can't enter any data. She clicks in a cell and it highlights but she doesn't get a cursor and can't enter data. If she tries to click in the area underneath the toolbar to enter data she also does not get a cursor!! It used to work just fine for her but has suddenly stopped!
View 5 Replies
View Related
Jun 6, 2014
I want to create a simple form for employees to enter their number of hours worked for the day. Driver name, Start Time, Finish Time and date. I need this information to populate an excel spreadsheet but I don't want the employees to be able to view the data that is being put in. Also possibly throw an error if the same employee accidentally enters their information twice.
View 1 Replies
View Related
Jan 30, 2008
I am having trouble creating a custom data entry form in excel. What steps would I need to take..
Attached is a example of the data, the Headers are in bold, the highlighted columns are to be drop boxes.
View 11 Replies
View Related
Jun 23, 2006
Trying to create new sheets with data being transfered over from a form. i.e. all the textbox's and checkbox's would appear in specific cells.
Textbox1
Textbox2
Checkbox1
Checkbox2
View 4 Replies
View Related
Aug 14, 2013
Ok just started using Excel 2013.
Trying to sort 3 columns:
Column 1:
A1/B1
A2/B2
A3/B3
Column 2:
Team 1
Team 2
Team 3
Column 3:
1
2
3
Column 3 is just a ranking from 1-30. So I select all the data in columns 1 and 2 and hit sort from largest to smallest and it looks like excel computes, but nothing changes and it doesn't sort from largest to smallest? A
View 6 Replies
View Related
Feb 5, 2014
I am using Excel 2013, and I am following the example here: VBScript Scripting Techniques: Read Excel files without using Excel that reads in Excel data as an ADO record set to a classic ASP file using VBScript. I am not able to import all the Excel data successfully, and I need to know what I'm doing wrong. Note that in all these samples cell A1 is the heading text "Column1" and the main data starts on cell A2 (consistent with the example code).
When my source Excel data looks like the following:
Code:
Column1
1
2
3
4
5
6
7
X
9
10
It imports everything OK. However, if I move the X to the next row:
Code:
Column1
1
2
3
4
5
6
7
8
X
10
...the "X" cell gets imported as an empty string. So the imported array looks like this:
Code:
arrSheet[0][0]: Column1
arrSheet[1][0]: 1
arrSheet[2][0]: 2
arrSheet[3][0]: 3
[Code] ....
But if I add another X to an earlier row in the source worksheet, like so:
Code:
Column1
1
2
3
4
5
X
7
8
X
10
...this gets imported OK.
View 3 Replies
View Related
Nov 27, 2013
I'm trying to figure out how to copy raw data from one file(emailed to me) and paste it to my existing file "File b" into a table "tbl a"(to make it dynamic). From another table "tbl b" on another sheet within in "File b" I want to auto populate "tbl b" with all the records from "tbl a" but not all columns from the records. To make it more difficult, I want to edit some of the data and the headings between the two tables are not the same. Example below.
Ship-to-name
Product Name
Date Shipped
Customer Group
ABC-Atlanta
Advil (Ibuprofen) 800MG
11-15-2013
Wholesaler
[code].....
Notice column b has different heading and the data need to be modified. Column d is not needed at all.
Also this need to happen when the raw data is copied into "tbl a" and again all records need to be copied over with changes.
This also needs to be done outside of VBA if possible using just formulas and possibly filtering.
I'm using MS Excel 2013
View 3 Replies
View Related
Mar 3, 2014
How do I transpose a horizontal reading excel into a vertical reading excel and transpose all of the data and formulas?
View 1 Replies
View Related
Aug 5, 2013
I have to import data from an external source(oracle database) to an Excel(2013) table.
Now the data in the staging table in the database keeps refreshing/changing, However in Excel i need the data to come into a new row everytime instead of refreshing the whole table and looking like the staging table in the database. So basically i need to build history in Excel.
View 3 Replies
View Related
Feb 22, 2014
I'm having trouble filtering a large list of 900 names to create mailing labels for anon-profit organization. For years I have been using Microsoft Works to create these labels, however, the people now doing the membership insist on using Excel. I have Office 2013 and am using Excel 2013 on a new Dell PC using Windows 7. I have partially solved the problem but have one hang up.
I got to a point where I could filter out the dates and a couple of other items, but can't seem to get the last two. I was able to get the minimum date (equal to or greater) than 2012 to filter and the (equal to)LIFE (life membership) one and the (equal or greater than) ID# of 9000to filter by changing the cell format in all of those columns of cells to "text" instead of "general", BUT I still can't get it to (be blank) for the M column which houses a "D" or "U" (indicating deceased or uninterested) and an E column which houses an "E" if the person receives the newsletter electronically rather than by mail.
My fieldset up is:
To Year is equal or greater than 2012
Or M Class is equal to LIFE
Or ID# is equal or greater than 9000
And M is blank
And E is blank
The first three work but the last two do not seem to filter properly.
View 8 Replies
View Related
Feb 19, 2014
I have made a Rota of sorts using Excel 2013 Desktop Edition for my charities volunteers (and stored it as a shared file via office 365 server that they can download and edit) and this rota is populated by our volunteers manually. Each day our controller needs to check the file to see who is on duty at that time.
How the Rota is populated.(the bit i managed to do myself)
The volunteer (Person A in this example) would open the excel file and go to the month they wish to choose a shift for (ref worksheet: FEB in this example). They would then pick a shift that suits them and click on the cell (ref: F32) that shows a vehicle available, then from the drop down list they select their name and then save and close the sheet.
Rather than our volunteer controller going through the sheet for the current month (ref worksheet: Sheets JAN to DEC) I would like them to use the first sheet in the workbook (ref worksheet: DC Info Page) to get an instant view of which volunteer is currently on shift.
My current problem
I don’t know how to make the excel file do the following
Search sheets JAN to DEC (ref cells: C4:I58 on each sheet) inclusive for the cell that contains today's (current actual) dateCopy the 8 (eight) cells below the cell that contains today's datePaste the copied cells in to the relative cells (ref: C8 to C15) in sheet one (ref worksheet: DC Info page)
I would also like this to be done automatically so the controller does not have to click on anything after they open the file. But if it needs a button to process the request, one could be added to the worksheet (ref: DC Info Page)
View 1 Replies
View Related
Sep 10, 2013
I have created an Excel spreadsheet in 2007. When a friend opens the workbook in Excel 2013, It does not let him add data to the cells. ( just one column which is the "date" column) The worksheet is not locked or protected.
When I right-click on the column and goto format cells, protection, the box is ticked, but the note says this doesn't take effect unless the sheet is protected witch it isnt.
View 6 Replies
View Related
Nov 14, 2013
I am using Excel 2013 and would like to input data into my spreadsheet using a barcode scanner. I've created some barcodes using an online barcode generator (Code 128-B). My barcodes are text as opposed to numeric. I initially tested it out using Access and it scanned the information just fine. However, when I try to scan in a code into Excel nothing happens, no error, no data, no nothing. Is there something I need to set in the options of Excel to recognize the barcode scanner as the input device? Or is there some other reason why the scanner might not be pulling in the data?
View 3 Replies
View Related
Mar 18, 2014
I've got large set of data(Column E) for dates from 2007 to 2013(Column B). Here dates are in chronological order.(Attachement) Now I want to match the data in to dates in Column H. Here dates are in random order. I used =INDEX(E3:E40582; MATCH(H3;B3:B40582; 0)). But it doesn't work.
View 5 Replies
View Related
May 27, 2014
Please see the attached example. I'm trying to highlight cells only if 2 values in the row match 2 values in another row. If a book title/author combination matches that of another title/author combination in a different row, it would highlight. Some alternate rows will contain different titles by the same author, and some rows will have like titles by different authors...but they should not highlight.
The only situation where highlighting would occur is if the title/author pairing appears in another row.
I'm trying to decide if this would be a conditional formatting/highlighting rule, or if it would be a macro/vbs?
I'm using Excel 2013.
Pairing example.PNG
View 14 Replies
View Related
