Pages

Search

Excel Help Forum - Excel General: Creating Date Ranges

Feed2Mail notification - new post on Excel Help Forum - Excel General
Creating Date Ranges
Is there a way possible to take a date range Ex: (1/1/2007-6/1/2007) and create in the excel file a list of each of those months. So I want it go from: Stmt Start date Stmt End Date # of Documents 1/1/2007 6/1/2007 6 TO end up like this : Stmt Date 1/18/2007...

Excel IT Pro Discussions Forum: Excel 2007 does not prompt user that the file is opened by another user. Thi...

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel 2007 does not prompt user that the file is opened by another user. This is NOT a shared file.
We have had multiple incidents where 2 employees access the same file but neither are prompted that it is in use.  This is NOT a shared file so why does it not prompt?

Excel Help Forum - Excel Charting & Pivots: Switching axises

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Switching axises
I have this chart (see attached) that I want to change the x axis for the y axis and the y axis for the x axis. Attachment 189413 (http://www.excelforum.com/attachment.php?attachmentid=189413)

Excel Help Forum - Excel Programming / VBA / Macros: How to dynamically update links based on data (not Cells) in PowerPoint via E...

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
How to dynamically update links based on data (not Cells) in PowerPoint via Excel?
Ok say I have an Excel sheet that gives me all my data and each section in that Excel sheet is linked (embeded object) to a PPT slide. How do I get the data in the powerpoint slides to update based on data (primary key) rather than cell position? For example (see excel data source table below): If...

Excel Help Forum - Excel General: Organize List of Reps

Feed2Mail notification - new post on Excel Help Forum - Excel General
Organize List of Reps
Good Afternoon, Within Column A exists sales reps names; I.E. bob billy brooke bob

Excel Help Forum - Excel Programming / VBA / Macros: Matrices

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Matrices
Hi, I have a cummulative matrix (based on the help from a previous thread) which I use for deciding the probability of a program switching between values, but I'd like to use a simpler transition matrix as input (as people understand that a bit better). Currently I have a matrix that looks...

Excel Help Forum - Excel General: If Value in Sheet 1 Exists in Another Workbook/Worksheet, Copy/Paste Entire Row

Feed2Mail notification - new post on Excel Help Forum - Excel General
If Value in Sheet 1 Exists in Another Workbook/Worksheet, Copy/Paste Entire Row
I have a sheet named Tracking File and the value that I want to use for reference is contained in Column A, let's call Column A, order_id. The Tracking File workbook only contains the order_id column, but I need to be able to find each of these order_id values in other sheets (or workbooks in...
Subscribe to: Posts (Atom)