Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Help Requested in Creating Hyperlink VBA

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help Requested in Creating Hyperlink VBA
I posted this originally in the Excel General, but I believe it should be posted here... Hi. I am using MS Excel 2007, and I have very basic knowledge on how to use visual basic . I need help with a macro, and I believe this is the best place to ask for help. I have column "A" a list of my...

Excel Help Forum - Excel General: Need help with function and date sorting

Feed2Mail notification - new post on Excel Help Forum - Excel General
Need help with function and date sorting
I am tryign to run the following statement in excel: =IF(O42="AB",VLOOKUP(WIPCOEI2012!O42,WIPCOEI2012!$O$51:$R$52,3,FALSE),IF(O42="AT",VLOOKUP(WIPCOEI2012!O43,WIPCOEI2012!$O$51:$R$52,3,FALSE))) When I cut and paste this row of cells, one of which has the above statement, the "O42" reference...

Excel Help Forum - Excel Charting & Pivots: How to Plot Data Labels on a Chart with a text value instead of a numeric value

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
How to Plot Data Labels on a Chart with a text value instead of a numeric value
So I've been having this trouble with a chart in Excel for months and just haven't been able to figure it out. It involves a chart that has labels that are supposed to show as change1, change2, change3, ect. plotted along a chart with a date range. If I change the date range to anything but...

Excel Help Forum - Excel Programming / VBA / Macros: Moving an entire row to new worksheet based on variable cell value.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Moving an entire row to new worksheet based on variable cell value.
So hooray for my first post! Now on to the serious business... I have read many posts relating to this for moving an entire row based on text of one cell, but only for one word. I am havin no luck finding the script to move it to a different sheet based on different words (in the same cell). ...

Excel Help Forum - Excel General: Hide duplicate information

Feed2Mail notification - new post on Excel Help Forum - Excel General
Hide duplicate information
Hello, I have a spreadsheet with two tabs. One tab is a sheet of employee names and addresses, the other tab is a list of employee names. I want to compare list and only show what is different and hide the duplicates. I have tried with the advanced setting under filters but it hides the...

Excel Help Forum - Excel Charting & Pivots: How to Plot a Bar Chart with FY and Quarters displaying on the Horizontal Axi...

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
How to Plot a Bar Chart with FY and Quarters displaying on the Horizontal Axis in 2007
I am using Excel 2007. I have a stacked bar chart that I am using for a timeline for a project at work. The x-axis is the dates and the y-axis is the various tasks of the project. I want to use bar chart to show the time each company believes a milestone event will happen so I want the horizontal...

Excel Help Forum - Excel Programming / VBA / Macros: Why are certain Macros grouped in a single Module?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Why are certain Macros grouped in a single Module?
When I select the "View Macros" option in Macros and select one to view, it gives me the option to scroll up and down and view several other macros. Usually about 3 or 4 of them will be in the same module. What I don't understand is how it decides which macros are in a given module. I simply...
Subscribe to: Posts (Atom)