Pages

Search

Excel Help Forum - Excel General: Post Rotation

Feed2Mail notification - new post on Excel Help Forum - Excel General
Post Rotation
I am looking for a formula that will rotate each name up one row each month. The problem is that I need it to rotate to the bottom of the list of names, not the bottom of the range of cells. I have 6 slots, and sometimes only 3 names in that area to rotate, or otherwise it would be simple. See...

Excel Help Forum - Excel General: how to break excel file password any software /if any trick

Feed2Mail notification - new post on Excel Help Forum - Excel General
how to break excel file password any software /if any trick
how to break excel file password any software /if any trick

Excel Help Forum - Excel Programming / VBA / Macros: Use macros to hide and unhide certain rows on another sheet

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Use macros to hide and unhide certain rows on another sheet
Hello All, In this attached file I am looking to keep the current macros that I have (if at all possible) and add the following: A macros that can link the check boxes with the corresponding categories and rows in the other two sheets. If the box is checked the corresponding rows in the other...

Excel Help Forum - Excel General: Equation(s) That Will Automatically Find Bad Data And Correct It.

Feed2Mail notification - new post on Excel Help Forum - Excel General
Equation(s) That Will Automatically Find Bad Data And Correct It.
On a weekly basis my team has to run a large excel export from a database. With thousands of data rows and columns, most of the information is correct, but some of the information is not and must be manually located by our team and manually corrected in each cell before submitting it to management....

Excel Help Forum - Excel Programming / VBA / Macros: Help!!!

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help!!!
Hi, I am trying to copy text from multiple specific cells and send the text to another sheet in a spicific cells. Also, once its done coping and sending that the text was copied orginally would bet delted automaticly. At first i used a button and code. (didnt work) then macro(didnt work) so im...

Excel Help Forum - Excel Charting & Pivots: Configuring Pivot table to display certain data

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Configuring Pivot table to display certain data
Hi: Please refer to attached sheet. I am using the pivot table as shown. Column K shows Week# Column L shows the total hours worked in that week. I need to see if it is possible to configure the pivot table so to display weekly data only which has over 40 hours. Please help.

Excel Help Forum - Excel Programming / VBA / Macros: Help to return only first 12 characters when a cell contains specific text

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help to return only first 12 characters when a cell contains specific text
Hi Guys, I have a spreadsheet which has some unnecessary characters added onto the end of some records which I need to remove. I am essentially trying to ensure that if a Cell in column A begins with (or contains) "PR" that it only returns the first 12 characters. Other records in column A may...
Subscribe to: Posts (Atom)