Create a Macro with a List
 

Hi Experts:

I would like to build a macro with the List for multiple individuals that
will then enter the data from the List to the Summary Worksheet in the same
Workbook. This is the example of what I want to do....

List Sheet

John Jones in Column A....123456 in Column B...ABCDF in Column C and 90.05%
in Column D

Put that data on the Summary Worksheet in Columns B, C, D & E

I would also like to remove the % sign in Column D

Can anyone help me with this? I would appreciate any assistance you can
provide. I'm working on a new reporting document that is using VLOOKUPs....a
lot of them every month....I think the Macro would be more efficient, but I
need your help to build on.
--
jeannie v

Create a Macro with a List
 

My Bad....I posted to Worksheet Functions rather than Excel Programming...I
apologize.
--
jeannie v


"jeannie v" wrote:

Hi Experts:

I would like to build a macro with the List for multiple individuals that
will then enter the data from the List to the Summary Worksheet in the same
Workbook. This is the example of what I want to do....

List Sheet

John Jones in Column A....123456 in Column B...ABCDF in Column C and 90.05%
in Column D

Put that data on the Summary Worksheet in Columns B, C, D & E

I would also like to remove the % sign in Column D

Can anyone help me with this? I would appreciate any assistance you can
provide. I'm working on a new reporting document that is using VLOOKUPs....a
lot of them every month....I think the Macro would be more efficient, but I
need your help to build on.
--
jeannie v