Site Search


Transferring specific data from a master list to another worksheet specific cell
Forum Q&A: The "Data Input" sheet feeds the "General Ledger" adding the new data in 9 columns to the...
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...
I need help with a formula to copy from one sheet to another if cells match
Forum Q&A: I have been struggling with this, keep in mind i dont know much about excel & the gobl...
Suppressing pop up message when running macro
Forum Q&A: I have a macro to open up a bunch of files, copy data into another workbook and close the ...
Pivot Chart Formatting Copy Trick in Excel - Excel Quickie
Tutorial: Easily copy Pivot Chart formatting from one Pivot Chart to another Pivot Chart in Excel. ...
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 ...
Using VBA to auto enter data added on one sheet to another when multiple conditions are met
Forum Q&A: I have uploaded an example workbook. I am looking to get the infromation in the yellow col...
Save Excel Sheet in a new location with name as two cell reference
Forum Q&A: Hi, So i have this code that copies a sheet and then moves it to another workbook make som...
VBA - Pick up data from same format in varies worksheets and paste to a master tracker
Forum Q&A: Hi everyone, so I am trying to extract all the information from the raw data file (avail...
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...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
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...
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...
Excel 2013 filters not working
Forum Q&A: The filters on my spreasheet are in the 3rd row, and show the filtering dropdown. When I ...
Excel Forum