reset

I have two validation lists. The second list is dependent on what is selected from the first list using the =indirect function and defined ranges. However, when the value in list 1 is changed, the value in the second list remains unchanged, and therefore incorrect. I would like list 2 to...

So I have a column filled with email addresses, and I need to count the number of unique values in this column, as long as the date hasn't changed in another column. Once the date changes, then I need to reset the count. I have a formula that works for counting the number of unique text values...

hey ex(cel)perts, i was wondering if there was a way to return a worksheet to its pre-use state without closing it. i have prepared an invoice sheet and it has dynamic ranges so the total, discount and stuff like that move one row down as one row of products purchased is added on top. for the...

Hello These days I was quite busy with Excel, so I paid many visits to this site, from where I got great advise. For one more I am looking now: What is the easiest way to reset a particular array, say $A$:$AA$30 on the original conditions (font, color, cell unmerged, borders reset, content...

Hello everyone, I have searched the forums but I couldnt find a post that I can apply to my question.. Sorry if this has been posted before and thanks in advance for all your input. I cant figure out the formula I have to use for this.. Maybe I have to use dynamic ranges but I am not advanced...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

I have a worksheet "Latest Rates" which uses autofilter and so I have setup a macro to reset filtering when the exel sheet is opened and works fine; however if the sheet is opened and reset is not applicable i.e. no filter criteria saved from last time it was used, the macro crashes. below is...

Hi All, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I currently have a macro linked to a button which does the following when someones clicks on it. <o:p> </o:p> - Filters a pivot table by certain values, then selects the pivot table, then exports to...

Hi All, I have a problem with a production planning spreadsheet I use. Heres the format: Column A: order of work (1 to 10). This column has a sort macro on it so tasks can be re-arranged in order of importance. Column B: Task (text) Column C: Length of takes (hrs, from a look up of task vs...

Hello, I have a spreadsheet where I keep track of information for a bi-weekly payroll system. Most years there are 26 pay periods in the year. I want to have the pay period number reset the suffix to "01" when it reaches 26. I also would like it to switch the prefix to the next year. Here...

Hi. I have used a few ontime events in a sheet that call a macro when time is reached as stated here. I have noticed that, even if you close excel, the ontime vars are still stored and, if I re-open the file and change times in cells which are referenced from the ontime statement, some strange...