Functions
in [Excel]
|
Auto saving sheets from a workbook as separate files. Hi I need some help with some VBA code. My workbook has 50 sheets. Numbered 1 - 50. I'd like to have a macro save each sheet as a separate file to a path and in a format specified by response to a popup. Can someone assist with this? Grateful for any help. ... 18 May 2010 14:48
LINECOLOUR CHANGE IN EXCEL WORKSHEET? how to change entire linecolour in a MS Excel work sheet at a time? ... 17 May 2010 01:36
Individual sheet protection in shared workbook I have a shared excel workbook with multiple sheets used by different people. I want them to have their own password for their sheet so that only sheet owner can edit the content of sheet. Please advise how do i do that? ... 15 May 2010 23:32
Sort by Colour HI I have a worksheet of 650 rows. Certain of the rows are highlighted in green. How can I group the highlighted rows at the top of the sheet? Grateful for any advice. Best Wishes ... 15 May 2010 23:32
Excel Formula to colourfill cells when condition met I daily populate a sheet sent to me with answers (time & dates) of 1,2 or 3 star items, the 3 star items I manually fill with a certain colour. Is there any way of filling a row that contains a cell with 3 stars automatically with a designated colour. In this example colour filling the whole row because one of ... 15 May 2010 09:22
Search for cell value Is it possibly to look at cell value and if in a range to place the record # in a cell ? E.g. Value in A2 that I need to know if in a range "R1234JK-3" RANGE Record # Proj # Billing # Review # 1 R1234JK-3 KIKII-87 KL12367 2 RM334 ... 15 May 2010 14:50
Totalling Subtotals Less Than 1 I am trying to total subtotals, but only if they are less than 1. I've tried doing =SUM(G12,G24,G36,G48,G60,G72,G84,G96,G108,G120,G132,G144,G156,G168,G180,G192,G204,G216,G228,G240,G252,G264,G276,G288,G300,G312), but it gives me an answer of -12 when I should get 18. I've also tried =SUMIF(I12,I24,I36,I48,... 14 May 2010 23:45
Find first and last cells in range, return info beside Hi All, I hope someone can help with a tricky formula. Given this type of sample data: A B C D E F G 1 Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 Jul-10 2 x x x 3 ... 14 May 2010 23:45
Date and Time I have cells in a worksheet that are formatted as date but still show as date and time. How do I pull out the time. E.g. 04/07/2009 1:00:00 AM I have tried the =left() and also =right () formulas with no luck. ... 14 May 2010 20:31
COUNT FORMULA??? I need to use a formula to find out how many times the value in B2 appears in column B. ... 14 May 2010 20:31 |