auto add column

[apple]

Hi,

Can anyone help me to do auto add column
Explanaton as below:
1. User will insert tab "MAIN" from which column, from row to row details that user want to search in sheet "TASK"
2. Then system will check the tab "DATABASE" for the employee number
3. If meet the employee number it will auto add another column "NAME" besides employee number column

Hope to hear from you soon. Thanks

[Bob Phillips]

In B3

=VLOOKUP(A3,DATABASE!A:B,2,FALSE)

and copy down.

[apple]

Hi,

I need to auto add column because the column is not permanently arrange. Every time got changes column sequence. Vlookup method cant be use because when one of the row is empty it will become NULL value. Can you show me how to auto add column and copy. Can u look in my macro? I already done half way.

Thanks