Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing a Marco
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing a Marco
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 Curtis wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ask user for input during marco | Excel Discussion (Misc queries) | |||
Writing a Marco | Excel Discussion (Misc queries) | |||
Writing to excel is very slow | Excel Discussion (Misc queries) | |||
I need some help with a Marco | Excel Discussion (Misc queries) | |||
excel Marco question ... need help please | Excel Discussion (Misc queries) |