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

jeanniev
Thu May 08 19:37:01 CDT 2008

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