Pages

Search

Excel Help Forum - Excel General: How to Share Workbooks between Multiple Users?!?

Feed2Mail notification - new post on Excel Help Forum - Excel General
How to Share Workbooks between Multiple Users?!?
I feel like I'm so close, but I'm missing something important Here's what I've done: 1. Clicked the 'Share Workbook' button on the Review tab 2. Checked the box that says 'Allow changes changes by more than one user at the same time' 3. Selected the settings I want ...now what... If I...

Excel IT Pro Discussions Forum: Excel 2010, Data Validation List, wrong order.

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel 2010, Data Validation List, wrong order.

Hello, 

I created a Data Validation to, "List" some items in drop down menu.  It works fine, but I have about 20 items in it, and when I click the "Down" arrow to view the drop down list, it starts from the bottom.  I'd like to view the first item in the list to be shown on top.  

Any suggestions? 

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