Writing a Marco

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Curtis - 30 Oct 2006 03:15 GMT

I need to write a macro that will pull all the information from one sheet and
copy the values to another one based on the Employee ID being the trigger

Other than taking a course does anyone have somethign that can do the trick

Thanks

Reply to this Message

Dave Peterson - 30 Oct 2006 03:32 GMT

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

> I need to write a macro that will pull all the information from one sheet and
> copy the values to another one based on the Employee ID being the trigger
>
> Other than taking a course does anyone have somethign that can do the trick
>
> Thanks

Signature

Dave Peterson

Reply to this Message