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
|