Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Text to rows macro

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Text to rows macro
Hello, I would like to write a macro which can do the following: Current situation in column A: Attachment 189040 (http://www.excelforum.com/attachment.php?attachmentid=189040) I would like to have a macro which does the following: * each number between comma should be transferred to a...

Excel Help Forum - Excel General: Highlighting rows after expiry date

Feed2Mail notification - new post on Excel Help Forum - Excel General
Highlighting rows after expiry date
Hi, i was wondering if someone could help me? i am looking for a conditional format that will highlight the entire row once the expiry date has been reached, i need the row to turn yellow 30 days be for the expiry date i need the line to turn red once the expiry date has been meet/past

Excel Help Forum - Excel Charting & Pivots: Use of Group and Outline in Pivot Table

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Use of Group and Outline in Pivot Table
when we create pivot table from a data set... then in Pivot table-->options you can group and ungroup the selection.. Anybody please explain the use of Grouping and un grouping the Pivot table... Thanks in advance AV

Excel Help Forum - Excel Programming / VBA / Macros: Macro takes approx. 15 seconds to run, how do i reduce run time?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Macro takes approx. 15 seconds to run, how do i reduce run time?
Good morning happy campers, I have a large sheet with numerous formula's etc within it, spread over 4 tabs, with a 5th tab readin info from an exported source. I have the following macro, Code: --------- Sub stopM() Dim FindString As String Dim Rng As Range

Excel Help Forum - Excel General: forgotten password

Feed2Mail notification - new post on Excel Help Forum - Excel General
forgotten password
hi guys, if i have forgotten the password to a protected sheet is there anything i can do to unprotect it?

Excel Help Forum - Excel Charting & Pivots: Pivot Table to display 'real' data not count - Help Please

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Pivot Table to display 'real' data not count - Help Please
Hi All, I have a challenge with the data that I wish to display in a pivot table. I've searched hard and can see that it may not be possible but worth a try anyway. Basically I want to display a list of jobs that each project manager has to complete within a specific month based on a set of...

Excel Help Forum - Excel Programming / VBA / Macros: Clear various cells in worksheet when changing related cells

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Clear various cells in worksheet when changing related cells
Hi, I have created 4 conditional drop down lists on a worksheet. Upon changing a cell in column S, I need the related column T to be cleared. This is to ensure that the user chooses a relevant item from the list in column T once he/she changes column S. The related cells are S15:T15, S19:T19,...
Subscribe to: Comments (Atom)