Macro to insert text into empty cells with a specified criteria

[wrightie]

Hi,

I'm trying to write a macro that will insert some text like * for example into two empty cells on the same row where on that same row in a different cell it says Client No.

any help is much appreciated.

[royUK]

More details would help.
Which column contains the text?
Are there only 2 empty cells?

[wrightie]

Sorry Roy.
I have approx 15000 rows of data.
I need the macro to go through and insert an asterisk into columns F & G where ever Client No appears in Column A.

thanks

[royUK]

If You are searching for the text "Client No", can you autofilter the data?

[wrightie]

Hi, yes i can but i just wanted to know if there was some way i could use a macro to automate it.

[royUK]

Record a macro whilst filtering, then the macro can be edited & used in future. Post the generated code for further help.

[wrightie]

this is a monthly task and the number of client no's differ from month to month so won't i have to edit the macro every month ?