Macro to Filter and Fill

[Greaser2k]

Hi
I have a spreadsheet that i need to filter by column H (Indicator) so it show any rows that have a letter in
The letter are generated by a formula

So wherever there is a letter in column H in need an “x” putting in column I
There is a formula like to the “x” that changes the time in column F to 00:00:00

I tried using the IF formula but I get and Circular reference

I have attached a copy of the spreadsheet
There could be up to 50000 rows of data by the end of the week

Thanks for your help

Mike

[arlu1201]

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

[Greaser2k]

Thanks very much
works a treat

Mike