The macro for filling the text in blank column

Dear all big brothers and sister,

I have an excel for recording sales manager's products sales.
I use the following macro for sumproduct function. However, in recent days, it doesn't work.
It may be because there are increase more than 200 account managers in the company (i mean integration).

The code is run very smooth if there are only 50 account managers. after adding more than 100 managers in the list, it run very slow.

Appreciate your reply.

I attached the excel. It is simplified version, it runs smooth. However, if you add more account managers (more than 100), it runs very slow.

Please Login or Register  to view this content.

Hi,

Could you please walk us through what you are doing exactly? All I can tell is that its filling the branch manger's names if they are missing from the last populated cell in Column A, but I could be totally off (need wake me up )

abousetta

Watersev,

Thanks a lot. May I ask last question? If the column of employee name is in column b, therefore, I just need to change [a:a] to [b:b] in macro?

Secondly, if employee name start at row 20, it there any difference for macro? By the way, if one workbooks contain many sheet, i only want to applied on specific sheet, how should I do / add statement in macro.

I have several files require to use this macro, therefore, I may modify macro by myself. Thanks

Please Login or Register  to view this content.

Dear Watersev,

Thanks for your reply. I just went to another province. May I ask which value I should enter for preceding non empty cell value?

For the attached file, I would like to fill in the blank column for A12-A14, A16-A18.
Then, should I enter A18, however, there is no result.(nothing happen)


Thanks