Excel 2013 :: How To Activate Developer Tab

Aug 21, 2014

How to activate Developer Tab in Excel 2013.

View 1 Replies


ADVERTISEMENT

Can't Use Text Field From The Developer Tab

Sep 30, 2013

I have already added the developer tab to excel, but under insert the last three options under Form controls (Text Field, Combo List - Edit, Combo Drop-Down) are shaded out.

View 2 Replies View Related

Excel 2013 :: Mail Merging From Excel Database To Outlook

Apr 15, 2014

Using EXcel 2013, Windows 8

I have an Excel worksheet with one column being e-mail addresses. Other columns are Christian names, etc

Ideally can I create a full Mail merge with Outlook using whatever data I want. But probably just e-mail address and Christian name?

Otherwise be able to send one e-mail to all the e-mail addresses, without a major re-type.

View 2 Replies View Related

Excel VBA To Activate When Printing Screen

Oct 19, 2010

I am trying to run vba clear clipboard. Not sure how check if Application.SendKeys "(%{1068})", is pressed.

View 5 Replies View Related

Excel Workbook Activate - Message Box Popup

Mar 19, 2012

I am writing code in Excel VBA and trying to control power-point. at the end there is message-box pop up. Everything runs fine.

But at the end I have go bottom windows bar and click on the excel file then message box comes up, otherwise excel tag keeps blinking at the bottom. I want to add something to code so message box in excel file is pop-up automatically without me clicking on excel file.

View 1 Replies View Related

Excel 2002 :: Activate Macro By Clicking A Shape

Feb 3, 2013

I found in an old file that i triggered the macro by clicking a button! I would post a pic but i don't know how. How do I activate a macro by clicking a shape on the excel 2002 page?

View 7 Replies View Related

Excel 2010 :: How To Select Userform Button And Activate With Pressing Enter Key

Jul 2, 2012

I have developed a Userform button in Excel 2010 using the developer icons, which when clicked on with my mouse it runs my super dooper macro. It works great!

But one thing I want to have happen is to have the choice of using the Enter key to start the macro or use the left mouse button

For example, I place data in (say) cell A1 and the userform button is in cell A2. When I place the data in A1 and press the Enter key, the cursor moves down to A2, but doesn't highlight the user button. When I press the Enter key again, the cursor moves to cell A3.

What I want is when I fill in the data in A1 and press the Enter key, the cursor moves to cell A2 and selects the button, so that when I press the Enter key again, it activates the macro.

View 3 Replies View Related

Excel 2010 :: How To Activate File And Create A Folder In Named CustomUI

Jul 28, 2013

I have a Excel 2010 file that I want to activate the file and create a folder in it named customUI.

the steps to achieve this?

View 7 Replies View Related

Excel 2013 :: Average Readings Per Day

Jul 2, 2014

Working in Excel 2013......... I take 3 readings per day, I would like to see the daily average per day

In cases where the data is blank or "0", just average the 2 readings.

Sample Data

Date Speed

6/1/20142560
6/1/20142550
6/1/20142558
6/2/20142554
6/2/20142537
6/2/20142532

[Code] ..........

View 4 Replies View Related

Excel 2013 :: No Column Headers?

Nov 28, 2013

My and a work college needed to combine our separate excel worksheets into a single document.

Office 2013 didn't have a function to "import sheet from file" so we used open office to import my .xlsx worksheets.

After we finished importing we exported the final workbook as .xls (so I could open it).

After opening the workbook on my pc (excel 2013) i notice some of the sheets no longer have column headers, but the row headings still exists. (No ABCD, only 1234)

Also I am unable to use features such as "Freeze Pane"

I suspect this was caused by importing and exporting through open office?

View 4 Replies View Related

Excel 2013 :: Save Workbook To PDF And Name By The Value In A3?

Dec 18, 2013

Tried a macro with no luck, I want to save workbook to PDF and have it named by the value in A3. I want the Dialog box to pop up so I pick the folder?

View 6 Replies View Related

Excel 2013 :: Add In Buttons On The Ribbon?

Jun 24, 2014

I installed excel 2013, but I don't find the (VBA) buttons on the ribbon, since.

Is there a need to install an add in / or activate an add in?

The macro's are on the ribbon on the tab VIEW.

I expect to find the buttons on that place also.

View 3 Replies View Related

Excel 2013 :: VBA - Save As (Get Filename)

May 6, 2013

I'd like to record a macro that allows me to take the current file "file.csv" and save it as "file.xlsx"

I can't get the variable right (just messing around in VBA to have it get the file name and save it as a different format (csv to xlsx)

I've tried:

Function GetFullName() As String GetFullName = ThisWorkbook.FullName End Function

View 7 Replies View Related

Excel 2013 :: VBA Connection To Access?

May 18, 2013

I currently have a workbook that has VBA functions that calculates values by looping through large amounts of data in a few large excel sheets. I want to transfer the data from these sheets into Access and then bring data into the VBA code via an array from the data in Access rather than the array being populated from the data in excel as it currently is. How to create the connection. The access DB will be situated in a public directory on a server. How to create the connection string and then how I call the data from Access? I have just downloaded Office 2013.

View 9 Replies View Related

Excel 2013 :: Insert New Row But Keep Formula?

May 29, 2013

I have a complicated spreadsheet with several columns. Some columns B, D, E, F, M come from calculations on other columns or are columns copied from other worksheets within the same workbook.

I have another column C which is generated entirely off a macro with no input from the user.

I insert a row at line 8 (see above). However its just a blankrow and the formula highlighted in E2 does not show in E8 but it does appear for E9. I'd need that formula to be in E8.

My dilemma is how to insert a row and have it copy the formula from too.

I'd like to avoid copying another row into it and editing data. Other thing to avoid is putting all new rows at the end of the spreadsheet if possible. Has to be in the middle of the existing table.

I have Excel 2010 or 2013.

View 3 Replies View Related

Excel 2013 :: How To Use VBA Code Cleaner

Jun 1, 2013

VBA Code Cleaner

I just can't seem to figure out how to use the Code Cleaner, after installing it I can't find any option to use it :S

I'm using Excel 2013 and W8 (if that's relevant).

Why does importing and exporting the code reduces the size? What kind of "junk" is stored and why? and when?

View 9 Replies View Related

Excel 2013 :: How To Add Date Range

Mar 4, 2014

I have a big spreadsheet with IT / Finance data. Below is the formula, I currently have. I am summing column Y in Tab Savings Data Detail, where column A does not equal Parent, and The Value in Column AK on the Savings data details tab matches the value in current tab for cell B26 and where column G on the savings detail tab equals Transition to IT. I am adding that value to the second sumifs statement essentially the values in column X on the savings detail tab with the same criteria.

Now I need to add to each of these formulas. I need to sum only the values where the date value in column W on the data details tab is greater than or equal to 01/01/2013 and less than or equal to 12/31/2013

find the easiest way?

=SUMIFS('savings data details'!$Y:$Y,'savings data details'!$A:$A,"Parent",'savings data details'!$AK:$AK,$B26,'savings data details'!$G:$G,"Transition to IT")+
SUMIFS('savings data details'!$X:$X,'savings data details'!$A:$A,"Parent",'savings data details'!$AK:$AK,$B26,'savings data details'!$G:$G,"Transition to IT")

View 1 Replies View Related

Excel 2013 :: Can't Select Shape / Dot

Apr 2, 2014

I have a construction schedule that my boss wants modified. There is a pesky dot I cannot select to delete. It is on a grid line and I can only select the cells adjacent to it.

I am using 2013

View 1 Replies View Related

Excel 2013 :: Date Stamp Modified Row

Apr 3, 2014

Looking to add automatic date stamp to a column of cells each time their corresponding row or specific cell in that row is modified.

I'm using Excel 2013.

View 1 Replies View Related

Excel 2013 :: Retrieve AutoFilter Criteria VBA

Jul 20, 2014

Is it possible to retrieve an arrary of the autofilter criteria. I know this is possible in pre 2007 but with 2007 onwards I can't find a way of doing it.

I know I can get all the available items in a list by using the scripting.dictionary and also by using the visible cells I could see what could be filtered but that is not really accurate for what I want.

E.G.

If I have multiple columns and look at the filtered information in one column I can retrieve an array of the visible cells from that column but that is not necessarily the criteria that is in the column. i.E. If another column has a filter rows may be filtered that would have otherwise been visible.

View 5 Replies View Related

Excel 2013 :: Chart Label Not Displaying?

Jun 8, 2014

I have a workbook, which I use for different departments that displays a number of different pie charts and I have found that a particular pie chart omits a specific label repeatedly. The pie chart displays the wedge within the chart itself, but does not display the label. At the moment I have data labels with percentages. All other labels display, of which there are 7. I found a solution that fixes the problem each time it arises and that is to select Chart Tools/Format/Series 1 data labels and then Format Selection. When I then select any data label, I click on "Clone Current Label" and the missing label appears with the correct percentage amount. I use the workbook for multiple uses and rather than have it present as a template (*.xltm), it is a macro-enabled spreadsheet (*.xlsm). Could this be related to the problem?

View 2 Replies View Related

Excel 2013 :: Conditional Formatting For Image?

May 12, 2014

What I'm looking to do in Excel 2013 is have it so a specified cell loads an image based on the results of a range of cells.

For example:
If cell B1 = red
and cell B2 = up
and cell B3 = yes
then cell A5 shows image X.

But then have it be comprehensive enough to do
If cell B1 = green
and cell B2 = down
and cell B3 = no
then cell A5 shows image Y.

My hangups are trying to get different images to load in the same cell. Also, all the examples of this I've found are pulling from one cell where I need it to display an image based on the results of multiple cells.

View 9 Replies View Related

Excel 2013 :: Macro To Update New Sheet?

Jun 23, 2014

I've got a spreadsheet that pulls data from a SQL server.

I'm looking to have a button on the first sheet that extracts the data from SQL and inserts it into sheet 2 of spreadsheet. The data connection from SqL is working fine but when I click on the button sheet 2 is blank.

View 1 Replies View Related

Excel 2013 :: Placing Date Value To 3 Different Groups

Jul 11, 2014

I am rather new to excel and currently using excel 2013.

I have a worksheet with column A ( data group) Column B ( Sent date with MM/DD/YY) , Column C Aged Group {using this formula =IF(B2="","",(TODAY()-B2))} , Column D status ( if the record is open or close).

I would like to create a table that can segregate the data group and how many days it has already aged. And then group them with different aged group. Refer to the attached screenshot.

From:-

Data GroupSent Date AgedStatus
Quotation 06/06/1435Open
Invoice 07/11/140Open
invoice 05/01/1471Open
PO 07/01/1410Open
PO 07/05/146Open
SO 06/30/1411Open
Quotation 05/18/1454Open
SO 05/05/1467Open
Cash Note 07/03/148Close

To:-

Data Group0-15 15-3030 above
Quotation
Invoice
PO
SO
Cash Note

testtest.xlsx‎

View 6 Replies View Related

Excel 2013 :: AutoFill Formula Down A Column

Dec 9, 2013

I am trying to auto fill this formula down a column but it doesn't keep the C4,D4,E4...ETC to stay constant

I manually did these two correct ones

=SUM(C5*C4+D5*D4+E5*E4+F5*F4+G5*G4+H5*H4+I5*I4+J5*J4+K5*K4+L5*L4+M5*M4+N5*N4
+O5*O4+P5*P4+Q5*Q4+R5*R4+S5*S4+T5*T4+U5*U4+V5*V4+W5*W4+X5*X4+Y5*Y4+Z5*Z4+AA5*AA4)

=SUM(C6*C4+D6*D4+E6*E4+F6*F4+G6*G4+H6*H4+I6*I4+J6*J4+K6*K4+L6*L4+M6*M4+N6*N4
+O6*O4+P6*P4+Q6*Q4+R6*R4+S6*S4+T6*T4+U6*U4+V6*V4+W6*W4+X6*X4+Y6*Y4+Z6*Z4+AA6*AA4)

when I drag it down it incorrectly looks like this:

=SUM(C7*C6+D7*D6+E7*E6+F7*F6+G7*G6+H7*H6+I7*I6+J7*J6+K7*K6+L7*L6+M7*M6+N7*N6
+O7*O6+P7*P6+Q7*Q6+R7*R6+S7*S6+T7*T6+U7*U6+V7*V6+W7*W6+X7*X6+Y7*Y6+Z7*Z6+AA7*AA6)

I want C6,D6,E6 to be C4,D4,E4 ETC

View 3 Replies View Related

Excel 2013 :: Sorting And Connecting With Formula?

Jan 15, 2014

I have a list with different categories and several characteristics per category. My goal is to identify the 10 strongest growing characteristics (I guess by sorting them in descending order) and then show them in this order, but organized in the respective categories. e.g.: if "Psychographic">"Demographic" and "geographic" and "behavioralistic", then put "Psychographic, including its subordinated characteristics that are included in the top 10, first. Follow this order until all Top10 members are included.

View 2 Replies View Related

Excel 2013 :: Delete Using Microsoft Query?

Apr 8, 2014

Using Excel 2013. Is it possible to delete some records from Sheet1 if the records exist on Sheet2?

I tried several SQL variations in MSQuery but all come back with error messages.

I tried:

[Code].....

View 3 Replies View Related

Excel 2013 :: Change Cursor Colour?

Apr 14, 2014

how to change cursor colour in excel 2013.

using Control PanelEase of AccessEase of Access CenterMake the mouse easier to use does not work as it will change mouse instead of cursor colour in excel 2013. e.g. original cursor colour in excel 2013 is green, change to any colours.

View 2 Replies View Related

Excel 2013 :: Properties Dropdown Box Not Working?

May 13, 2014

I am using Excel 2013/365 on a Windows 7 OS. Recently (today) I added a command button to a worksheet, opened the properties window and tried to change the Backcolor property. When I clicked on the dropdown arrow no list appeared, it highlighted the default in the designated area. I then tried the Forecolor property - same response. I tried all the other dropdown arrows and they worked perfectly. To me I believe I may have inadvertently hit a key to disable these two color property dropdown arrows

View 1 Replies View Related

Excel 2013 :: Automatically Reapply Filter

May 22, 2014

I have a Table ("Table2") in a worksheet ("Dashboard") that contains monthly data arranged in rows. I have made the data fields show #NA for months I want to exclude based on dynamic criteria.

Now, I would like to automatically filter out the rows (months) with #NA so that they are not charted.

It works manually but I have to Right Click on the Table --> Filter --> Reapply every time the source data changes. How can I make this happen automatically so that the user does not have to manually reapply each time.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved