Pages

Search

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...

Excel IT Pro Discussions Forum: 2010 Excel Spreadsheet not saving on the network

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
2010 Excel Spreadsheet not saving on the network
We have about 25 Desktops in the office. We are upgrading them to Office 2010 from Office 2003. We have a group of desktops that work together on an excel spreadsheet. The spreadsheet is located on the server. When 1 computer makes changes and saves it and opens it later on she notices that her pervious save was not saved. Another Desktop is doing the same thing, but not confirmed. Is this a Office 2010 Excel problem, because we had 2003 for years and no issues. 

Excel Help Forum - Excel Charting & Pivots: Multiple Charts Issue

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Multiple Charts Issue
Greetings everyone! I am one of the Local Desktop Support Techs, and I am having an issue with a user in excel. This user has multiple .xls spread sheets that link to one .xls master spread sheet with Multiple charts/graphs. The issue she is having is when she opens the master spread sheet it...

Excel Help Forum - Excel Programming / VBA / Macros: Converting numbers to date format

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Converting numbers to date format
Hi, I have a few columns E,X and Z with the dates in the form of 20120426 and I need to convert it to 04/26/2012 format using VBA. Any help is appreciated. Thanks, David

Excel Help Forum - Excel General: Count unique cases in a weekly bucket

Feed2Mail notification - new post on Excel Help Forum - Excel General
Count unique cases in a weekly bucket
Hello, I am trying to develop a report for my boss to summarize how many cases my group works on in a week. My issue is that we have duplicate cases listed in the data I'm working with. I only want to count unique cases. Can someone please help me with the formula? When I used this formula:...

Excel Help Forum - Excel Programming / VBA / Macros: Question about importing data from one file to another

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Question about importing data from one file to another
Hi! I am new here, and hope I am posting in the correct Forum. I need to figure out a way to import data from several sources into an Excel Add in that I had created for me. Currently I need to go to WebTrends and Filemaker to bring data into this Add in report. The only common point of data is...
Subscribe to: Posts (Atom)