Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Applying conditional formating across multiple columns independently

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Applying conditional formating across multiple columns independently
It was suggested that I cross post my question from the formulas forum here. I was given a solution that saves quite a bit of time but a macro may be better? After many hours of google'ing I come before you defeated. The attached sheet is an array of various sales offices and their sales...

Excel Help Forum - Excel General: IF THEN statement and Tables

Feed2Mail notification - new post on Excel Help Forum - Excel General
IF THEN statement and Tables
I am attempting to create a table in excel that will automatically fill out another table depending on the outcome. For example, if A3> 0, then A1, but if it is not, then check A4>0, then A4, etc. I've attempted it in this manner so far, but when I get past the first one I always seem to get...

Excel Help Forum - Excel Programming / VBA / Macros: userform that will search name and pull results from a seperate workbook

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
userform that will search name and pull results from a seperate workbook
I have created a basic spreadsheet with multiple columns and will be entering data daily to the fields. However, I will have others using the form to search for people on the spreadsheet and they would prefer having a command "Search" button for a person(s) name instead of using filters. I have a...

Excel Help Forum - Excel General: quickest method for dynamic link to closed workbook

Feed2Mail notification - new post on Excel Help Forum - Excel General
quickest method for dynamic link to closed workbook
Im looking for the quickest known solution : I need to link to over 52 separate workbooks and pull back a number of cells. the problem is that depending on what week we are in some workbooks will not exist. but i need the links to stay live then update when the sheets do exist. Ive tried...

Excel Help Forum - Excel Charting & Pivots: Unknown chart type

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Unknown chart type
Here is a chart we use in a presentation. It's just an image but it looks like it was created in Excel and I want to update it. I have made many Excel charts, but I don't know how to create a chart like this. The X axis is time in years. The first row is showing that birth records exist in database...

Excel Help Forum - Excel Programming / VBA / Macros: Burning Excel program to disk with Youtube videos

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Burning Excel program to disk with Youtube videos
Hi All, I've been running in circles trying to figure this out: Is it possible to create an Excel program which uses a form with alot of rows of VBA buttons and burn it to a disk? It's not intended for the web. When clicked, each button would play a specified Youtube video. The user...

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...
Subscribe to: Posts (Atom)