Pages

Search

Excel Help Forum - Excel General: Running clock in excel 2010

Feed2Mail notification - new post on Excel Help Forum - Excel General
Running clock in excel 2010
Hello. Is there a way to build a running clock that automatically scrolls through a selected range on a dashboard. I have attached a very basic mock upAttachment 188555 (http://www.excelforum.com/attachment.php?attachmentid=188555)

Excel Help Forum - Excel Formulas & Functions: Frustrations with Pivot Tabels

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Frustrations with Pivot Tabels
Hello, I'm probably going to kick myself when this finally sinks in, but I'm having trouble getting data out of a pivot table. On the attached book the sheet 'Age of Stock' shows a stock item, a date and a quantity. On sheet 'Stock Report' in cell M4 i want to match the stock item...

Excel Help Forum - Excel Programming / VBA / Macros: Only one computer adding leading apostrophes to drop downs

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Only one computer adding leading apostrophes to drop downs
I am testing out a tool that I have been working on for the past few months, and I have sent it to several people on my floor to test it. It works fine for everyone. I tried to give a demo to a manager this morning, but on his computer it kept getting errors. The tool is built to set pivot...

Excel Help Forum - Excel General: Mail Merge: The merge provides data from the previous record

Feed2Mail notification - new post on Excel Help Forum - Excel General
Mail Merge: The merge provides data from the previous record
I hope someone can help please. I have created a data source (Excel 2000) and the data is sitting in the right columns; I have also created a word document (Word 2000) for the mail merge. I have inserted the merge fields into the word document but when I preview the merged document (using...

Excel IT Pro Discussions Forum: Excel/Sharepoint

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel/Sharepoint

I have a very an App with, multiple SSs and charts. I would like to make the App available to many clients  via the web instead of downloading the app to their computer. I understand, however, that when attempting this porting (HTML Conversion) many features that I am using will be lost.

Can Sharepoint be a solution, i,e., web access to Excel with no loss of local Excel features???

 

Excel Help Forum - Excel Formulas & Functions: advanced excel counting with running totals

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
advanced excel counting with running totals
I have an excel spreadsheet--in which I cannot use VBA (for security reasons)--and I am trying to count cells. Each day that an occurance does not happen, an accident for example, I add 1 to the current day (for weekdays) and one for each weekend. However, if an occurance does happen, I need to...

Excel Help Forum - Excel Programming / VBA / Macros: Need help in Search database

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Need help in Search database
Hello! I am building a search database. The data that I have is captured as below (Just an example of how the database looks Index1 | Index2 | Data1| Data2 | Data3 10 | 50 | A | B | C 100 | 150 | X | Y | Z