Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

Filter by
Sorted by
Tagged with
4
votes
2answers
1k views

Disable OneDrive handling in Word

Since I use OneDrive, each document I create or edit in Word is handled as an online document, when I save it in the folder structure, OneDrive is syncing. Documents are handled as "http://d.docs....
0
votes
1answer
21 views

How to keep an excel file open in sharepoint or onedrive after I log out?

I have an excel file that contains some vba scripts that refreshes other excel files at specific intervals. My problem is this file must be open in order to have that macro run. My question is how can ...
0
votes
0answers
7 views

Conditional Formating sections of a table based on a cell value

In my constant drive to work more efficiently I've been trying to learn excel to make my day to day work easier. I'm using this graph I made here Sorry for the link but I'm not sure how to input ...
0
votes
0answers
8 views

Autorefresh excel file in sharepoint

I have an excel file that is connected to some external data sources (sql server...). This file is used as a data source in a power bi dashboard. What I want is to have the data in this excel updated ...
5
votes
2answers
23k views

How can I create a “Cross-Join” in excel?

I have 2 sheets in excel, each with 10 rows. Is there some sort of "cross-join" formula/macro in Excel that allows me to create a 3rd sheet with all rows cross-joined (100 rows in total).
0
votes
1answer
14 views

How to automate football pool checking

I am looking into how I can automate the process of gathering the answers from a football pool sheet. The play sheets have 2 teams per line and a box to fill in for each if the contestant believes ...
1
vote
1answer
14 views

Replace Static Table Data w/ External Source and Update Pivot Automatically (Excel)

st tab is a table with data manually pasted from a file nd tab is a pivot based on the 1st tab Is it possible to replace the 1. st tab with an external data source (load-in the file without pasting ...
1
vote
1answer
14 views

Conditional VLOOKUP based on dates

I have two tables I want to merge in Excel: +---------------------+-----------------------+ | Date | Email | +---------------------+-----------------------+ | 2019-07-...
0
votes
2answers
2k views

VBA Code for filtering a column using Input Box

Im looking to filter a column based on a code the user puts into an input box. I used the following code: Sub Filter() ' ' Filter Macro Dim strName As String strName = InputBox(“What DMA would you ...
1
vote
0answers
14 views

auto populate cells based off of list selection

I have drop down lists and dependent drop down lists, but I would like to find a method to populate other cells based off of these selections. For example, my position drop down is predicted by the ...
1
vote
1answer
16 views

Hide Rows based on multiple cells

My database is getting massive and I am trying to make things a little more manageable. What I am basically trying to do is: If cell E:E = "Complete" hide the corresponding row Else If cell F:F = "...
0
votes
1answer
38 views

I need to determine how many new sales reps to hire based on an estimated number of future clients in Excel

We have to do an analysis on how many new sales reps to hire based on the number of expected onboarded clients. The dynamic part of the problem is that when we hire a sales rep, they have a 2 quarter ...
0
votes
0answers
8 views

How to get a list of keyboard shortcuts that I use for my macros?

I know I can find a list of standard keyboard shortcuts of excel in google or through Microsoft Office Help. But I have overwritten some of them (I wasn't using them) to assign for some of my macros ...
0
votes
0answers
12 views

Pasting a URL into a cell and, based on a formula, the cell retains the text in it

When you COPY (CTRL+C) a URL from your browser and then go to a cell in an Excel sheet that displays the word LINK (with the formula I copied below in it) and replace the formula (Select all and ...
2
votes
1answer
8k views

Conditional formatting of percentages using Icon Sets

I have a column with percentages, for example +------+ | -19% | | 17% | | 4% | | 30% | | -31% | I'm trying to use the Icon Set green, yellow and red. For a negative percentage, I would like to ...
1
vote
1answer
19 views

Run macro continuously when button on QAT is pressed

I have added two macros to "Quick Access Toolbar"(QAT). Macros are for navigating left and right in the sheet, like when you press arrows at the bottom right corner of the workbook. When you press ...
4
votes
3answers
33k views

How to execute a stored SQL procedure in Microsoft Excel?

How can I execute a stored procedure in Microsoft Excel and get all the data it returns?
0
votes
1answer
3k views

Incorrect total averages showing in excel pivot tables

I have a pivot table report, and in the Filter Field I have 3 options "All", "Indigenous People", and "non-Indigenous people". If I select the Filter option to "Indigenous People" and put in the ...
8
votes
3answers
17k views

Delete ALL custom cell styles EXCEL

Is it possible to delete ALL the custom/created cell styles in a workbook ? Just leaving the default styles. Without having to delete them all one by one
0
votes
3answers
61 views

IF formula to calculate hourly costs

I want to set an =IF formula to show as follows: If cell B6 = 0, then result is 0 If B6 = 1 or more, then result is B6*2.5+2.5. This is to calculate hourly costs, first hour is £5.00, second and ...
4
votes
3answers
84 views

How to create (truly) blank cells from formula so that they get skipped in Ctrl+Arrow?

This question asks about how to use a formula to create truly blank cells so that they won't show up in a chart. The solution is to use the formula NA() which makes the cell take on the value #N/A. ...
5
votes
4answers
14k views

Custom Formula Not Updating

I followed this guide to create the following custom function which counts the number of cells of a certain colour in my spreadsheet: Function ColorFunction(rColor As Range, rRange As Range, Optional ...
1
vote
3answers
12k views

Why is sharepoint (onedrive) giving the error “Links to external workbooks are not supported and have been disabled” when there are no external links?

I have tried everything I can think of, and everything the internet has to offer: Find function Go-To Special, Objects - manually inspect each An add-in for finding external links Manually searching ...
1
vote
3answers
32 views

Excel - Extracting data if a cell contains a text

I have created an example image of what I am trying to do. I want cells r3 to R11 to add up the any hours that in that row but holiday hours only. Can anyone help? thank you
-1
votes
1answer
29 views

How to define a code text for a predefined result?

I couldn't word it very well in my question but a detailed explanation will be easier to understand. I want to define a code -such as "A"- and a result text for that code or in my case I need a date. ...
0
votes
0answers
27 views

Refreshing an excel file without opening it

I have an excel file that is somehow connected to some external data sources. In turn, the excel file itself is used to feed a chart in power bi. What I want is to have the file updated at regular ...
0
votes
0answers
11 views

Spinning Button To Work on added row instead of the existing row

There are 2 objectives on this document. To simplify: 1. Count the # of clicks (3 buttons to count since there are 3 different categories to count off each click) and 2. Use the counter on a daily ...
5
votes
2answers
748 views

How can I change Excel so that I can enter English rather than German formulas?

I want to change my Excel installation such that I can enter formulas in English rather than in German. I believe, I should be able to change the corresponding settings under File -> Options -> ...
1
vote
2answers
11k views

Unable to Add Row in Excel

I have a worksheet formatted as a table. I was able to insert a row immediately prior to running into this issue, but now I cannot insert a row (right click+Insert is greyed out). Not sure what might ...
0
votes
2answers
6k views

PC unable to find EXP_PDF.DLL

I have an Excel workbook that uses VBA to create PDFs from sheets, and send them via email through Outlook. When I click the button to create the PDFs and send, Microsoft Visual Basic gives me the ...
0
votes
1answer
50 views

Counting list items in Excel

I am creating a statistical analysis workbook, and I have a question. If I create a list on one of the worksheets, and make a data validation for only the values in that list in more than one ...
0
votes
1answer
5k views

how to create list with all possible combinations

I have the following table: a b c d ... q w e r ... z x v ... p I am having lots of trouble finding an algorithm (preferably VBA but the thinking is almost the same in other languages) that will ...
1
vote
0answers
48 views

Excel: Expand list to include duplicates [duplicate]

I am trying to dynamically expand a list to include duplicates. I managed to achieve this without VBA, but after condensing several columns containing intermediary functions I have tied myself in a ...
0
votes
1answer
53 views

Create a list from a range of values in cells

Can someone help me with this ? I would like excel to create a list depending on a range: Range1: B1: 1 C1:5 Range2: B2: 10 C2: 15 I Column A4 and below :1,2,3,4,5,10,11,12,13,14,15 Range input will ...
4
votes
4answers
953 views

Microsoft Office 2003 document (Excel and Word), intermitently, takes 30 seconds to load

I am trying to figure out why a simple .XLS EXCEL workbook is taking, randomly, 30 seconds to open. Before answering: Please, bear mind the following: Main symptoms Using Windows Explorer, here is ...
0
votes
1answer
2k views

Load a picture from one inserted ActiveX Image to another - VBA Excel

I got a set of named pictures on an Excel sheet, created by the "Insert" button in development tag, and from the section "ActiveX controls" from the "Insert" button. What I want is, when I click on ...
0
votes
1answer
7k views

Excel VBA: Loop to Fill in Sequence Numbers in a Column

I am new to Excel VBA and I am currently working with a project that needs to autofill sequence numbers in Column A depending on the filled range in Column B. With the code below that I found in ...
0
votes
1answer
12 views

Can I Create a Soft Data Validation Table of Joined Cells?

I have a set of data that makes up a list that would be good to use for data validation in another table. However, in the other table, I would like the fields to show a combination of two fields from ...
6
votes
3answers
110k views

Creating a “grouped” bar chart from a table in Excel

Firstly, I have almost no experience with Excel charts. :) I'm trying to create a fairly simple chart from a fairly simple table. But I'm having more problems than I thought I would have and spending ...
0
votes
1answer
277 views

Google Drive Not Syncing Folder Correctly

I have a bit of a strange issue with my 'Backup and Sync' Google Drive. Specifically only 1 file in a particular folder I have selected to sync is not syncing to my device and I cant figure out why. ...
0
votes
1answer
11 views

How to populate a master sheet for multiple other sheets

I have a workbook that had 7 different sheets, Each sheet has a column that is labeled Companies. How would I go about setting up a formula that would add the companies names to master sheet as they ...
0
votes
1answer
26 views

VBA debug on counting blank cells in a filtered list with VBA code

Apologies if the answer is obvious, only been using VBA for a week. Want to filter the cells in a separate sheet, then count the blanks left in the filtered list. I have got the code basics from ...
1
vote
0answers
17 views

VBA excel - Is there any way to ensure the user cannot call/run a macro in the immediate window?

So I have written a VBA application and locked the VBAProject (unviewable). But of course, the user can still have access to the Immediate Window (if they open another excel file for example and ...
2
votes
1answer
23 views

Filtering empty cells

Notice that B2 and B3 are merged and a filter is created on the B column When I'm going to apply the filter it shows Empty (Vazias in Portuguese) as one of the options as there are merged cells in ...
0
votes
1answer
25 views

Selecting certain columns based on their value

I have created a spreadsheet of all my inquiries. I want to select all the columns for example with "B". My main aim is to see as a quick summery, all the people who have booked. Then if I wanted to ...
0
votes
0answers
15 views

EXCEL machine epsilon of grg solver

I use very often the onboard solver of EXCEL (grg nonlinear) and I am quite happy with its performance. Since I use the data generated by the solver for further calculations I would like to knwo the ...
0
votes
0answers
46 views

Dragging and dropping cells in Excel causes unwanted shading to be applied

When I drag and drop cells, shading sometimes gets applied to the original location of the moved cells. It's always some shade of grey but the exact shade can differ. Sometimes all the 'moved-from' ...
0
votes
1answer
17 views

Possible to check if a VBAProject is clicked?

VBA excel -- When a VBAProject is clicked or double-clicked, it will trigger a macro. <<<< Is there any way to do that? How to determine if my VBAProject is clicked or double-clicked? ...
4
votes
3answers
3k views

Sum of cells based on a vertical criteria and horizontal date range

Hoping someone can help me! I am looking for a formula that will sum a range based on a vertical criteria and a horizontal criteria - but this second one is actually a date range not a single date. ...
0
votes
0answers
18 views

Need Help Building a SQL Toolkit

I have taken a new job where I work with other client's data. It's been almost all MS SQL with one Oracle job. My job has two main parts. The first is to review their data. I usually get a massive ...