sheet10

Dear Friends and Respected Seniors, I am using this VBA code to show current time every second in cell A1 of Sheet10. Public Sub show_current_time() Application.DisplayAlerts = False Application.EnableAnimations = False Application.EnableEvents = False Sheet10.Range("A1") = Time...

Can anyone show me how to get a list of unique values but only if a condition is met? So I need the unique values from Column C on Sheet10 put into Column A of Sheet18, (from A3), but only if the cell in the same row of Column A on Sheet10 has the value "Toolbox". I can generate a unique list...

Hi All, How do I write in code the following verbal: Many thanks in advance! R/ Pinaceous

I am creating an MS-Excel sheet, with hyperlinks, which would point to other MS-Excel Workbooks, in various network, locations/file folders. How do I create a hyperlink, using Insert, pointing to an MS-Excel Workbook, Sheet10, Cell M100. (As an example, and the file is located in a network...