I want to put filter for empty cells in this excel and copy the L1 cell value and paste it in rest of the empty cells in L column

[Gopi_Krishna1 (Gopi Krishna)]

Suggest a macro to copy and paste the L1 values into empty cells of the L column

[Anil_G (Anil Gorthi)]

@Gopi_Krishna1

you can use read cell to read the data from L1

then use find/replace activity and give Type.Missing in value to find and replace all with value returned from L1

cheers

[vrdabberu (Varunraj Dabberu)]

Hi @Gopi_Krishna1

Input:

Macros code text file Path:
Filter Macros.txt (824 Bytes)

Change the Sheet Name Accordingly

Output:

Regards