- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
Articles & Videos
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and anything else related to the spreadsheet user interface, including error messages.
I would like to find a formula to convert ranked data to a fixed variable range 5 to -5
Please refer to attachment
What is the best/simplest way to create an image of selected content from Excel or Word with a transparent background?
For example, suppose you have a table of values in Excel (or a coupl…
I'm working to incorporate several formulas that are presently in a very complex WB that has several hundred "Range Names". Here is the question:
1.) I can drop and drag "Modules" to my new WB, bu…
We are trying to calculate a specific character that may repeat it self within a Excel.
We want the last "\" of the following string:
We want the posi…
Hi All - Is it possible to hide all the toolbars in Excel 2016 the way Excel 2003 did to make things look more like a program? My coding doesn't seem to do anything on E2016.
Hi, I have a simple formula in a cell.
When (IF) the value returned is an even number, I want the result returned to be +1.
In other words if the Weeknum returned is 2, I want to…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you…
There is often more than one way to accomplish a particular coding task and one of the criteria that can be used to determine which method to use is to determine which one is the fastest. But how do …
hi, i wrote this little bit of code myself. i think if you look at it you'll see what i'm trying to achieve... onOpen, set value of I1 to No
it runs through the script ok without error …
I'm using excel. My spreadsheet looks like this:
So if you notice cells D1, E1,F1 and G1
This is just a sample spreadsheet. In my actual spreadsheet I have like 300 columns.
I have a reasonably complicated Excel 2013 spreadsheet used each month for various calculations. The spreadsheet contains a number of Pivot Tables whose source is a Table that pulls data directly fro…
I installed the plug-in MySQL for Excel, and after that default saving changed to .xlsx, so each time I had to change back to .xlsm
But when I tried to open that .xlsm file, it didn't work, I got …
I have a list of macros in an excel file (also have them in a .bat file)
When I open excel, I want these macros to open as well so I can use them.
I know I can add the excel file to the…
for the selected cells in a column (contiguous range) I would like to perform the following VBA Action.
If the macro hits a cell (of this selected range) which starts with a numbe…
I have a set of 20 Excel files that need to have information redacted from them. For the purpose of redaction, I just need to change the background and text to black.
For each row in my worksheet,…
Below is the table i am working with. i 'd like to populate data in cell c1, c2, c3, c4 based on a criteria. For example: If the criteria is 4 i want cells C1,C2,C3,C4 to display 70,80,90,100 r…
I got thousands of records where I have to concatenate two cells as follows
The Formula in D5 is as follows:
Copying it down all the way does…
Below is the table i am working with. i 'd like to populate data in cell c1, c2, c3, c4 based on a criteria. For example: If the criteria is 4 i want cells C1,C2,C3,C4 to display 11,23,304,40 r…
Excel: Can I make a dropdown list that removes the dropdown's selected values from the dropdown list in future iterations & builds a list of previously used values?
List named "USERS" originally co…
I have a query that when I run it producing the attached error. I am not sure what it is saying, I am exporting the results of the query to a Excel Spreadsheet with the following:
Private Sub Com…
I would like to modify the attached spreadsheet.
I would like a script to look into each field which contains the UPC code, and compare Year 1 to Year 2 to Year 3.
If some UPC codes are not shown in…
I would like to sort through the Data in Sheet 1, and produce the output shown in Sheet 2.
I will add much more data to Sheet 1, perhaps over 600 rows and perhaps it may grow.
Can someone help me ei…
I can copy entire cells like this - values, formats, everything.
I want to copy only the Formats, Conditional Formats. How do I amend the above please?
Edit: I want to avoid …
by Patrick G. Matthews Introduction VLOOKUP is a tremendously useful function that allows you to "fetch" data from a specified rectangular range (the "lookup table"); this …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you…