Site Search


Help creating a macro to open another file, rename sheet and copu each one as a new workbook
Forum Q&A: I need to create a macro that open a dailog to choose an excel file, open that excel file,...
Copying data across worksheets in the same workbook
Forum Q&A: I am using Excel in Microsoft Office 2010, and I have created a Workbook for Golf Opens th...
how to use a value in a cell from one worksheet to trigger insertion/removal of a range of cells from another worksheet
Forum Q&A: I've searched this forum for an answer to my specific issue and couldn't find it.  Some o...
copying data from worksheet to another in a random numerical order
Forum Q&A: Hello, Can You please help. I am totally stuck in what formulae or function I need to use ...
Run Time Error 1004: PasteSpecial method of Range class failed ...
Forum Q&A: Hi guys, So I've Spent about 2 weeks trying to figure this error out and am simply tired o...
Why does my link keep breaking after running a macro?
Forum Q&A: Here is my issue, Every month I import data in a flat list and run a macro to sort it. The...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Quickly Combine a List of Values and Put a Delimiter Between Each Value in Excel
Tutorial: How to combine a list of data into one cell while putting a delimiter between each piece ...
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...
3D References - Formulas that Reference Multiple Sheets at Once in Excel
Tutorial: Have one simple formula that will reference the same cell or range of cells on multiple w...
Array Formula
Forum Q&A: I am using an Index match formula in an array to extract my data. The problem is when I co...
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situat...
How can an excel 2007 file be renamed to 9AE322A2.tmp and Why should this happen?
Forum Q&A: Hi everybody,I use MS Excel 2007 since last several years and I have an important excel fi...
Make All Numbers in a List Positive in Excel
Tutorial: Take a list of numbers and make them all positive, regardless of whether the list contains...
Countdown Timer in Excel
Tutorial: How to create a countdown timer in Excel. This allows you to display a timer in whatever ...
Simple Excel Function to Combine Values in All Versions of Excel - UDF
: Excel function that combines values from multiple cells or inputs using a delimiter - work...
Returning to last active sheet after a macro automatically runs
Forum Q&A: I have made an excel workbook for my trading , it has lots of sheets and each sheet has a...
Make All Text Upper Case or Lower Case in Excel
Tutorial: How to quickly change all text to upper case or lower case in Excel.  This allows you to ...
Excel Prank - Random Cell Selection
Tutorial: Excel prank where a random cell is selected each time a user tries to select a cell. For i...
Excel Prank - Hide Text on Cell Selection
Tutorial: This prank will hide the contents of the currently selected cell and then show the content...
Excel Forum