Create a Macro with a List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jeannie v - 09 May 2008 01:35 GMT

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.

Signature

jeannie v

Reply to this Message

jeannie v - 09 May 2008 01:37 GMT

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

Signature

jeannie v

> Hi Experts:
> >
[quoted text clipped - 15 lines]
> > lot of them every month....I think the Macro would be more efficient, but I
> > need your help to build on.

Reply to this Message