Pages

Search

Excel Help Forum - Excel Formulas & Functions: Converting a date serial number back to a date within a string

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Converting a date serial number back to a date within a string
Hi all, I'm working on something that will return the applicable dates given certain conditions. I have one condition that would return a date range. I am currently trying to use, as an example: =if(A3="Marriage", A3&" - "&A3+31-DATE(A3+31)+1) In theory, this would return 10/15/2012 -...

Excel Help Forum - Excel Programming / VBA / Macros: Copy values from one CSV to an excel worksheet?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Copy values from one CSV to an excel worksheet?
Is there a way that you can have a macro automatically copy and paste values from one excel sheet to another and possibly reformat some of the copied information?

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

 
Subscribe to: Posts (Atom)