Pages

Search

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

Excel Help Forum - Excel General: VLookup Syntax required to look up period date if I put 'Yes' in a cell

Feed2Mail notification - new post on Excel Help Forum - Excel General
VLookup Syntax required to look up period date if I put 'Yes' in a cell
Hi, could anyone please advise me of the Vlookup syntax to look up the current period dates from a range of period dates if I put 'Yes' in a cell? What I have is a workbook with two worksheets i.e. 'This Period' and 'Admin'. The 'Admin' tab has this finacial years dates in columns C & D...

Excel Help Forum - Excel Formulas & Functions: Counting number of times a word appears across worksheets

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Counting number of times a word appears across worksheets
Hi , Basically I have created a spreadsheet with details of several different people for HR purposes. Each person is assigned to a worksheet called 'People Info' and I have 70 copies of that worksheet with each persons details on. One of the criteria is each persons work status which has a drop...
Subscribe to: Comments (Atom)